excel sheet get

Excel: Sheet - get

Get worksheet properties and contents.

Path: /{SheetName}

Attributes

Attribute	Type	Description
freeze	string	Freeze pane anchor cell (e.g., A2, B3) or empty if none
autofilter	string	AutoFilter range if set (e.g., A1:D10)

Children

When retrieved, a sheet lists its rows and cells as child elements. Use --depth to control how deep the output traverses.

Child	Description
row[N]	Rows with data or formatting
A1, B2, ...	Cells within those rows

Examples

# Get sheet overview
officecli get data.xlsx /Sheet1

/Sheet1
  freeze: A2
  children:
    /Sheet1/row[1]
    /Sheet1/row[2]
    /Sheet1/row[3]

# Get sheet with deeper traversal
officecli get data.xlsx /Sheet1 --depth 2

# Get as JSON
officecli get data.xlsx /Sheet1 --json

See Also

• Sheet - Overview of sheet operations
• Sheet add - Add a new sheet
• get - Excel - All Excel get paths

---

Based on OfficeCli v1.0.6