excel reference

Excel (.xlsx) Reference

Complete reference for OfficeCLI operations on Excel documents.

Elements

Element	Path	Operations
Sheet	/{SheetName}	add
Cell	/{SheetName}/A1	add, set
Validation	/{SheetName}/validation[N]	add, set
Table	/{SheetName}/table[N]	add, set
Comment	/{SheetName}/comment[N]	add
Named Range	/namedrange[Name]	add, set
Picture	/{SheetName}/picture[N]	add, set
Shape / Textbox	/{SheetName}/shape[N]	add
Chart	/{SheetName}/chart[N]	add, set
Conditional Formatting	/{SheetName}/cf[N]	add
AutoFilter	/{SheetName}/autofilter	add, remove
Sparkline	/{SheetName}/sparkline[N]	add, set, remove
Pivot Table	/{SheetName}/pivottable[N]	add, set

Path Notation

Excel-native path notation is accepted as an alias for DOM-style paths:

Excel Notation	DOM Path	Description
Sheet1!A1	/Sheet1/A1	Single cell
Sheet1!A1:D10	/Sheet1/A1:D10	Cell range
Sheet1!row[2]	/Sheet1/row[2]	Row by index
Sheet1!1:1	/Sheet1/row[1]	Whole row (N:N notation)
Sheet1!A:A	/Sheet1/col[A]	Whole column (Col:Col notation)

Both notations work in all commands (get, set, add, remove, query).

Workbook Root

Path: /

Document Properties

Property	Description
title	Document title
author / creator	Author name
subject	Subject
description	Description
category	Category
keywords	Keywords
lastmodifiedby	Last modified by
revision	Revision number
created	Creation date
modified	Last modified date

officecli get data.xlsx /
officecli get data.xlsx / --depth 2
officecli set data.xlsx / --prop title="Q4 Report" --prop author="John Doe"

View Modes

Mode	Description
text	Plain text dump of cell values
annotated	Cell values with formatting metadata
outline	Structural overview (sheets, tables, charts)
stats	Summary statistics (row/column counts, data types)
issues	Potential problems (empty sheets, broken formulas, missing refs)

officecli view data.xlsx --mode text
officecli view data.xlsx --mode stats
officecli view data.xlsx --mode issues

Raw XML Parts

Part Path	Description
/ or /workbook	Workbook XML
/styles	Stylesheet XML
/sharedstrings	Shared string table
/{SheetName}	Worksheet XML
/{SheetName}/drawing	Drawing container
/{SheetName}/chart[N]	Chart XML

XPath prefixes: x (SpreadsheetML), r (Relationships), a (DrawingML), c (Charts)

officecli raw data.xlsx /Sheet1 --start 1 --end 50 --cols A,B,C
officecli raw data.xlsx /styles

---

Based on OfficeCLI v1.0.22