How to fix the error 400 in Create Excel Table with Headers

gtamon — Mon, 07 Apr 2025 02:12:12 GMT

Hi I'm working in an QAA involving Create Excel Table with Headers but I'm getting the error 400 "The number of rows or columns in the input array doesn't match the size or dimensions of the range."

Anyone can help me fix this issue?

Re: How to fix the error 400 in Create Excel Table with Headers

Shai_E — Mon, 07 Apr 2025 13:09:44 GMT

Hi @gtamon

The error mentions what needs to be done, check your values input and see if its in the range of the start cell and end cell that you configured for the block.

Say that i chose

start cell A1

end cell A2

That means that i can only add one value, this is one column
If i add more then one value to one of the rows i will get the same error you got, ie if i insert the following value in the values field

[["RON", "SHAI"],["RON"]]

When the value should look like so

[["RON"],["RON"]]

An array of arrays (these are basically row representations), where each child array has one item in it in my cell configuration case.

Best Regards

topic How to fix the error 400 in Create Excel Table with Headers in Qlik Automate

How to fix the error 400 in Create Excel Table with Headers

Re: How to fix the error 400 in Create Excel Table with Headers