-
Notifications
You must be signed in to change notification settings - Fork 528
excel table
zmworm edited this page Jun 8, 2026
·
52 revisions
Table (ListObject) management for structured data ranges.
Path: /{SheetName}/table[N] or /{SheetName}/table[Name]
officecli get data.xlsx /Sheet1/table[1] officecli get data.xlsx /Sheet1/table[SalesData]
officecli query data.xlsx "/Sheet1/table[*]" officecli query data.xlsx "/Sheet1/table[style=TableStyleMedium2]"
officecli remove data.xlsx /Sheet1/table[SalesData] officecli remove data.xlsx /Sheet1/table[1]
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