How to Clear Table Style in Office Scripts

Question

How can I remove all of the styles from a table? I attempted to record the macro, but when I do so and attempt to run it, it fails (Table setPredefinedTableStyle: The argument is invalid or missing or has an incorrect format.).

function main(workbook: ExcelScript.Workbook) {
  let selectedSheet = workbook.getActiveWorksheet();
  let mainTable = selectedSheet.getTable("MainTable");
  mainTable.setPredefinedTableStyle("undefined");
}

How can I clear the table style?

https://learn.microsoft.com/en-us/javascript/api/office-scripts/excelscript/excelscript.table?view=office-scripts#setpredefinedtablestyle-predefinedtablestyle-

Answer 1

Excel tables on the web are constantly styled. There is no method to delete every style. The most fundamental style, "none," doesn't seem to be assignable in any way. I'll check in on that.

The closest I can get to was to use TableStyleLight1 style as shown below.

function main(workbook: ExcelScript.Workbook) {
  let selectedSheet = workbook.getActiveWorksheet();
  let mainTable = selectedSheet.getTable("MainTable");
  mainTable.setPredefinedTableStyle('TableStyleLight1')
}