Skip to content

excel table add

zmworm edited this page Apr 9, 2026 · 51 revisions

Excel: Table - add

Add a table (ListObject) for structured data ranges.

Path: /{SheetName}

Properties

Property Default Description
ref (required) Table range (e.g., A1:D10)
name Table{N} Table name
displayName same as name Display name
style TableStyleMedium2 Table style name
headerRow true First row is header
totalRow false Show totals row
columns Column names (comma-separated, e.g., Name,Revenue,Quantity)

Examples

officecli add data.xlsx /Sheet1 --type table --prop ref=A1:D10 --prop name="SalesData"
officecli add data.xlsx /Sheet1 --type table --prop ref=A1:C5 --prop name="Summary" --prop style=TableStyleLight1 --prop totalRow=true

Based on OfficeCLI v1.0.39

Clone this wiki locally