export to json
Tue Jul 19 2022 03:32:31 GMT+0000 (Coordinated Universal Time)
Saved by
@bobgorbold
function main(workbook: ExcelScript.Workbook) {
let tbl = workbook.getTable("Table1");
let tblrange = tbl.getRangeBetweenHeaderAndTotal();
let tblValues: string[][] = tblrange.getValues() as string [][];
let returnArray: string = JSON.stringify(tblValues);
return returnArray;
}
content_copyCOPY
Comments