excel cell add

Excel: Cell - add

Add cells with values, formulas, and formatting.

Path: /{SheetName}

Properties

Property	Default	Description
ref	(required)	Cell reference (e.g., A1)
value		Cell value
formula		Formula (e.g., =SUM(A1:A10))
type	auto	string/str, number/num, boolean/bool
(style keys)		See Cell set for style properties

Examples

officecli add data.xlsx /Sheet1 --type cell --prop ref=A1 --prop value="Hello"
officecli add data.xlsx /Sheet1 --type cell --prop ref=B1 --prop formula="=SUM(A1:A10)"
officecli add data.xlsx /Sheet1 --type cell --prop ref=C1 --prop value=100 --prop type=number --prop bold=true --prop fill=FFFF00

Row add

Property	Default	Description
cols		Number of empty cells to create in the row

officecli add data.xlsx /Sheet1 --type row --index 3
officecli add data.xlsx /Sheet1 --type row --index 3 --prop cols=5

---

Based on OfficeCli v1.0.6