-
Notifications
You must be signed in to change notification settings - Fork 541
excel table add
zmworm edited this page Apr 9, 2026
·
51 revisions
Add a table (ListObject) for structured data ranges.
Path: /{SheetName}
| 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) |
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=trueBased on OfficeCLI v1.0.40