excel cell

Excel: Cell

Cell, row, column, and range operations.

Path: /{SheetName}/A1, /{SheetName}/A1:D10, /{SheetName}/row[N], /{SheetName}/col[A], /{SheetName}/A1/run[N]

Operations

• get - Returned attributes and output format

• add - Add cells with values, formulas, and formatting

• set - Modify cell content, style, and row/column properties

get

officecli get data.xlsx /Sheet1/A1
officecli get data.xlsx /Sheet1/A1:D10
officecli get data.xlsx /Sheet1/row[5]
officecli get data.xlsx /Sheet1/col[A]

query

Selectors: cell, column letters (A, B)

Attribute	Description
value	Exact value match
type	String, Number, Boolean
formula	true/false
empty	true/false

Pseudo-selectors: :contains("text"), :empty, :has(formula)

officecli query data.xlsx "cell:has(formula)"
officecli query data.xlsx 'cell:contains("Revenue")'
officecli query data.xlsx "B[value!=0]"
officecli query data.xlsx "Sheet2!cell[formula=true]"

remove

officecli remove data.xlsx /Sheet1/A1
officecli remove data.xlsx /Sheet1/row[3]
officecli remove data.xlsx /Sheet1/col[B]

When removing a row or column, a warning is printed if other cells have formulas that reference the deleted row/column (cells that will become #REF!) or that reference shifted rows/columns. See remove for warning format.

---

Based on OfficeCLI v1.0.28