excel rowbreak

Excel: Row Break

A manual page break inserted before a specified row on a worksheet.

Path: /{SheetName}/rowbreak[N]

Operations

• add - Insert a manual row page break
• set - Update an existing row break
• get, query, remove - Standard operations

add

Parent: /{SheetName}

Property	Required/Default	Description
row / index	yes	1-based row index where the break occurs.

set

Property	Required/Default	Description
row / index		1-based row index where the break occurs.
manual		true => user-inserted (manual) break; false => automatic.
min		Zero-based start column the break spans (OOXML brk@min).
max		Zero-based end column the break spans (OOXML brk@max).

Examples

# Insert a manual page break before row 20
officecli add data.xlsx /Sheet1 --type rowbreak --prop row=20

# Update the row index of an existing break
officecli set data.xlsx /Sheet1/rowbreak[1] --prop row=25

# Mark a break as manual and span it across a column range
officecli set data.xlsx /Sheet1/rowbreak[1] --prop manual=true --prop min=0 --prop max=10

# Read back a row break
officecli get data.xlsx /Sheet1/rowbreak[1]

# Query all row breaks
officecli query data.xlsx rowbreak

# Remove a row break
officecli remove data.xlsx /Sheet1/rowbreak[1]

Notes

• The break is placed before the specified row.
• pagebreak with a col= value routes to colbreak instead.

See Also

• Sheet - Parent worksheet element
• Excel Reference - All Excel elements

---

Based on OfficeCLI v1.0.119