Last updated on
Apr 27, 2021 06:02:54 AM GMT
|
Also Applies to ColdFusion
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)> |
Sign in to your account