let workSheet = Api.GetActiveSheet();
let data = [[“A1”,“B1”],[“A2”,“B2”],[“A3”,“B3”]];
workSheet.GetRange(“A1:B3”).SetValue(data);
How to transpose a value? I mean result like this:
for (let j = 0; j < data.length; j++) {
workSheet.GetRangeByNumber(0+j,0).SetValue(data[j][0]);
workSheet.GetRangeByNumber(0+j,1).SetValue(data[j][1]);
}