excel table set

Excel: Table - set

Modify table properties.

Path: /{SheetName}/table[N]

Properties

Property	Accepted Values	Description
name	string	Table name
displayName	string	Display name
style	style name	Table style
headerRow	bool	Toggle header row
totalRow / totalsRow	bool	Toggle totals row. totalsRow is an accepted input alias (v1.0.134+).
ref	range	Update the table range reference

Examples

officecli set data.xlsx /Sheet1/table[1] --prop style=TableStyleDark1
officecli set data.xlsx /Sheet1/table[1] --prop totalRow=true
officecli set data.xlsx /Sheet1/table[1] --prop name="RevenueData"

---

Based on OfficeCLI v1.0.134