excel table

Excel: Table

Table (ListObject) management for structured data ranges.

Path: /{SheetName}/table[N] or /{SheetName}/table[Name]

Operations

• add - Add a table with style and structure options
• set - Modify table properties

get

officecli get data.xlsx /Sheet1/table[1]
officecli get data.xlsx /Sheet1/table[SalesData]

query

officecli query data.xlsx "/Sheet1/table[*]"
officecli query data.xlsx "/Sheet1/table[style=TableStyleMedium2]"

remove

officecli remove data.xlsx /Sheet1/table[SalesData]
officecli remove data.xlsx /Sheet1/table[1]

---

Based on OfficeCLI v1.0.64