excel table get

Excel: Table - get

Get table (ListObject) properties.

Path: /{SheetName}/table[N]

Attributes

Attribute	Type	Description
name	string	Table name
displayName	string	Display name
ref	string	Table range (e.g., A1:D10)
style	string	Table style name
showRowStripes	boolean	Banded rows enabled
showColumnStripes	boolean	Banded columns enabled
showFirstColumn	boolean	First column highlighted
showLastColumn	boolean	Last column highlighted
headerRow	boolean	Header row visible
totalRow	boolean	Total row visible
columns	string	Comma-separated column names
totalFunction	string	Per-column totals-row function readback (surfaces on the column child node)
totalLabel	string	Per-column totals-row label readback (surfaces on the column child node)

Examples

officecli get data.xlsx /Sheet1/table[1]
officecli get data.xlsx /Sheet1/table[1] --json

See Also

• Table - Overview
• Table add - Create tables
• Table set - Modify tables

---

Based on OfficeCLI v1.0.64