Query on setDataAtCell Method

[chandup83]

Hi @aleksandra_budnik,

I am using setDataAtCell(row, column, value, source) to update the value in the cell for a column.
As i am having 1000 rows that i am copying from an excel, I am passing Array for the row parameter as below.

"setDataAtCell(rowArray, column, value, source)",

Question:
Is there a option to pass value also as an Array as below?
setDataAtCell(rowArray, column, valueArray, source).

[aleksandra_budnik]

Hey @chandup83

a single cell can only hold one value so it can't be an array. As we can see here https://jsfiddle.net/AMBudnik/7dgscwku/1/ the array gets flattened to a string.

[aleksandra_budnik]

Hey @chandup83

Have you change the data structure?