Posted 17 December 2021, 8:59 am EST
Hi
I am trying to make setArray to also setup styling along with data array.
for example:
sheet.setArray(0, 0, [[“10/1/2021”, “11/1/2021”] ], false) I am trying to transform to something like
sheet.setArray(0, 0, [[{style: “Date: mm/dd/yyyy”, value: “10/1/2021”}, style: “Date: mm/dd/yyyy”, value: “11/1/2021”}] ], false)
Is there something that follows this approach?