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