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]);

}