Whatever message this page gives is out now! Go check it out!
SpreadSheetAddPagebreaks
Last update:
May 18, 2026
Note: 
You can find the CFFiddle demo of this function and other spreadsheet functions as part of a project that is shared with you.
Click the button below to launch CFFiddle.
To copy the project in your workspace in CFFiddle, follow the steps below:
- Log in with your Gmail or Facebook credentials.
- Navigate to the project in the left pane.
- Once you make some changes in any cfm in the project, a pop up displays asking you to save the project.
- Give the project a suitable name and click Save.
Description
A function to add page breaks for rows and columns.
Returns
Does not return a value.
Category
Microsoft Office Integration
Function syntax
SpreadSheetAddPagebreaks(Spreadsheetobj, rowbreaks, colbreaks ) |
History
ColdFusion 11: Added the function.
Parameters
Parameter | Description |
spreadsheetObj | The Excel spreadsheet object to which to add the column. |
rowbreaks | Comma-delimited row numbers where the page breaks will be applied. |
| colbreaks | Comma-delimited column numbers where the page breaks will be applied. |
Example
<cfset rowCount = 200>
<cfset colCount = 150>
<cfloop from="1" to="#colCount#" index="i">
<cfset val_arr[i] = "some random text row#i#">
</cfloop>
<cfset val_list = #ArrayToList(val_arr)#>
<cfset xlObj = spreadsheetNew("testsheet", true)>
<cfloop from="1" to="#rowCount#" index="r">
<cfset spreadsheetAddRow(xlObj, "#val_list#")>
</cfloop>
<cfset SpreadSheetAddPagebreaks(xlObj, "50,90", "4,9")>
<cfset SpreadSheetWrite(xlObj, "#Expandpath("./")#test_pagebreak.xlsx",true)>
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Share additional feedback to help us improve.
0/255
|
