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]

Row-by-column-name selectors

row[ColumnName op value] selectors match table rows by header name (also works on detected header-row tables that aren't formal ListObjects). query, set, and remove all support this — boolean and is fine, but OR'd table-column predicates inside row[…] fail loud (never silent):

# Highlight high earners
officecli set data.xlsx 'Sheet1!row[Salary>5000]' --prop fill=FFFF00

# Drop rejected records (shift-safe)
officecli remove data.xlsx 'Sheet1!row[Status=rejected]'

# Pure-AND combinations
officecli query data.xlsx 'Sheet1!row[Region=EMEA and Salary>5000]'

Outline mode also surfaces detected tables (and charts) at the worksheet level alongside the formal ListObject list.

---

Based on OfficeCLI v1.0.105