Puts Data in a table after sorting
Sun Jun 05 2022 02:42:33 GMT+0000 (Coordinated Universal Time)
Saved by
@bobgorbold
//Puts all the data into a Table called "Data"
let range = selectedSheet.getUsedRange();
let tbl = selectedSheet.addTable(range, true);
tbl.setPredefinedTableStyle("TableStyleLight1");
tbl.setName("Data");
tbl.setShowBandedRows(false);
tbl.setShowFilterButton(true);
tbl.getSort().apply([{ key: 5, ascending: true }]);
content_copyCOPY
Comments