command get excel

get - Excel (.xlsx)

Available paths for getting Excel document elements.

Paths

Path	Description
/	Workbook root (lists all sheets)
/{SheetName}	Sheet overview
/{SheetName}/A1	Single cell
/{SheetName}/A1:D10	Cell range
/{SheetName}/row[N]	Row N
/{SheetName}/col[A]	Column by letter
/{SheetName}/col[1]	Column by number
/{SheetName}/validation[N]	Data validation rule
/{SheetName}/picture[N]	Embedded picture
/{SheetName}/chart[N]	Chart
/{SheetName}/table[N]	Table (ListObject)
/{SheetName}/comment[N]	Comment/note
/{SheetName}/cf[N]	Conditional formatting rule
/{SheetName}/autofilter	AutoFilter settings
/namedrange[N]	Named range by index
/namedrange[Name]	Named range by name

Examples

# List all sheets
officecli get data.xlsx /

# Get sheet overview
officecli get data.xlsx /Sheet1

# Get single cell
officecli get data.xlsx /Sheet1/A1

# Get cell range
officecli get data.xlsx /Sheet1/A1:D10

# Get row
officecli get data.xlsx /Sheet1/row[5]

# Get column
officecli get data.xlsx /Sheet1/col[A]

# Get named range
officecli get data.xlsx /namedrange[1]
officecli get data.xlsx "/namedrange[SalesRange]"

# Get validation rule
officecli get data.xlsx /Sheet1/validation[1]

# Get table
officecli get data.xlsx /Sheet1/table[1]

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

See Also

• get - Command syntax
• Excel Reference - All Excel elements

---

Based on OfficeCLI v1.0.33