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;
}
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter