command set excel

set - Excel (.xlsx)

Settable elements in Excel documents.

Elements

Element	Path	Reference
Workbook Root	/	Excel-Workbook-Set
Cell / Row / Column / Range	/{Sheet}/A1	Excel-Cell-Set
Sheet	/{SheetName}	Excel-Sheet
Validation	/{Sheet}/validation[N]	Excel-Validation-Set
Table	/{Sheet}/table[N]	Excel-Table-Set
Comment	/{Sheet}/comment[N]	Excel-Comment
Named Range	/namedrange[N]	Excel-NamedRange-Set
Picture	/{Sheet}/picture[N]	Excel-Picture-Set
Chart	/{Sheet}/chart[N]	Excel-Chart-Set
Conditional Formatting	/{Sheet}/cf[N]	Excel-ConditionalFormatting
AutoFilter	/{Sheet}/autofilter	Excel-AutoFilter
Sparkline	/{Sheet}/sparkline[N]	Excel-Sparkline
Pivot Table	/{Sheet}/pivottable[N]	Excel-PivotTable-Set

See Also

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

---

Based on OfficeCLI v1.0.64