How to fix the error 400 in Create Excel Table with Headers
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."
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.
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.
