excel colbreak

Excel: Column Break

Manual page break inserted before the specified column. Accepts a numeric index or a column letter.

Path: /{SheetName}/colbreak[N]

Operations

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

add

Parent: sheet

Property	Required	Description
col (aliases: column, index)	yes	Column index or letter the break is inserted before (e.g., F)

set

Property	Required/Default	Description
col (aliases: column, index)		Column index or letter the break is inserted before
manual		true ⇒ user-inserted (manual) break; false ⇒ automatic
min		Zero-based start row the break spans (OOXML brk@min)
max		Zero-based end row the break spans (OOXML brk@max)

Examples

# Insert a manual column break before column F
officecli add data.xlsx /Sheet1 --type colbreak --prop col=F

# Insert a break using a numeric column index
officecli add data.xlsx /Sheet1 --type colbreak --prop col=6

# Change the column a break is anchored to
officecli set data.xlsx /Sheet1/colbreak[1] --prop col=D

# Mark a break as manual and set the row span it covers
officecli set data.xlsx /Sheet1/colbreak[1] --prop manual=true --prop min=0 --prop max=20

# Query all column breaks
officecli query data.xlsx colbreak

# Remove a column break
officecli remove data.xlsx /Sheet1/colbreak[1]

Notes

• The break is placed before the named column, so col=F starts a new printed page at column F.
• col accepts either a column letter (F) or a numeric index (6).
• min and max are zero-based row indices that define the vertical extent the break spans, mapping directly to the OOXML brk@min and brk@max attributes.
• manual=true marks the break as user-inserted; manual=false marks it automatic.

See Also

• Sheet - Worksheet print and page-setup options
• Excel Reference - All Excel elements

---

Based on OfficeCLI v1.0.119