User Guide Cancel

SpreadSheetAddPagebreaks

 

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:

  1. Log in with your Gmail or Facebook credentials.
  2. Navigate to the project in the left pane.
  3. Once you make some changes in any cfm in the project, a pop up displays asking you to save the project.
  4. 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)>

Get help faster and easier

New user?