let summaryTable = sheet.addTable("Q2:U2", true); summaryTable.getHeaderRowRange().setValues([["Label", "Name", "Billable", "Non-Billable", "Drive Time"]]); summaryTable.setPredefinedTableStyle("TableStyleLight1"); summaryTable.setShowBandedRows(false); summaryTable.setShowFilterButton(true); summaryTable.getRange().getFormat().autofitColumns(); let summaryTable2 = sheet.addTable("W2:Z2", true); summaryTable2.getHeaderRowRange().setValues([["Location", "Billable", "Non-Billable", "Drive Time"]]); summaryTable2.setPredefinedTableStyle("TableStyleLight2"); summaryTable2.setShowBandedRows(true); summaryTable2.setShowFilterButton(false); summaryTable2.getRange().getFormat().autofitColumns(); summaryTable.setName("SummaryTable"); summaryTable2.setName("SummaryTable2"); let errorTable = sheet.addTable("W7", true); errorTable.getHeaderRowRange().setValues([[ "Issues"]]); errorTable.setPredefinedTableStyle("TableStyleLight3"); errorTable.setName("Issues");
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