Add cells with values, formulas, and formatting.

Path: /{SheetName}

• Formula auto-detect: A value starting with = is automatically treated as a formula — no need for a separate formula property. For example, value="=SUM(A1:A10)" works identically to formula="=SUM(A1:A10)".
• Formula prefix: Leading = sign is automatically stripped from the formula property (e.g., formula="=SUM(A1:A10)" works the same as formula="SUM(A1:A10)").
• Array formula literal braces rejected: formula='{=SUM(...)}' throws — use the arrayformula=... property instead.
• Literal value clears stale formula: writing value=... on a cell that previously held a formula clears the cached formula.
• Boolean normalization: type=boolean converts true/yes/1 to 1, and false/no/0 to 0.
• Conflicting value + formula: supplying both value= and formula= emits a warning; the formula wins.
• Cell length limit: values exceeding Excel's 32767-char per-cell limit are rejected.
• ISO datetime with time: value=2024年01月15日T09:30:00 is converted to the OADate serial.
• Cell-ref path tail: add /Sheet1/A5 --type cell --prop value=... writes to A5 (path tail honored, not just auto-appended to row 1).
• Dynamic-array functions: Excel 2016+ dynamic-array functions (FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY, XLOOKUP, etc.) are auto-prefixed with _xlfn. for legacy compatibility.
• OFFSET / INDIRECT: the calc engine now produces reference values for OFFSET and INDIRECT, so =OFFSET(A1,0,0) resolves rather than returning null. Defined names whose body is a formula (e.g. =OFFSET(...)) are inlined at parse time.
• Auto-ref: Adding a cell without ref auto-assigns the next available cell in row 1.

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

Inserts a row at the specified index. Existing rows at or below the index automatically shift downward. Merge cells, conditional formatting, data validations, AutoFilter references, named ranges, hyperlinks, table refs, and formula references are all rewritten across the sheet (Path A: regex-based). Cell-content shorthand: pass c1=/c2=/c3= to seed values into the inserted row's cells in order.

Use --index N to specify insertion position (1-based). Omit to append. --from /Sheet1/row[N] (or --from /Sheet1/col[L]) copies cells from an existing row/col with values, formulas, and styles; formula refs are delta-shifted to match the destination row/col.

officecli add data.xlsx /Sheet1 --type row --index 3
officecli add data.xlsx /Sheet1 --type row --index 3 --prop cols=5
officecli add data.xlsx /Sheet1 --type row --index 5 --from /Sheet1/row[2]
officecli add data.xlsx /Sheet1 --type row --index 6 --prop c1=Alice --prop c2=42

Inserts a column at the specified position. Existing columns at or after the insert position shift right. Merge cells, named ranges, conditional formatting, data validations, AutoFilter, hyperlinks, table refs, and formula references are all rewritten across the sheet.

Use --index N (1-based number) or --prop name=C (column letter) to specify the insert position. Both forms are equivalent.

# Insert column at position 3 (shifts existing column C → D)
officecli add data.xlsx /Sheet1 --type col --index 3
# Insert column by letter name
officecli add data.xlsx /Sheet1 --type col --prop name=C
# Insert column with custom width
officecli add data.xlsx /Sheet1 --type col --index 2 --prop width=20

Note: Excel's native path notation (Sheet1!A1, Sheet1!A:A, Sheet1!1:1) is also accepted as an alias for the DOM-style paths (/Sheet1/A1, /Sheet1/col[A], /Sheet1/row[1]).

Based on OfficeCLI v1.0.97