spreadsheetAddPagebreaks Code Examples and CFML Documentation

spreadsheetAddPagebreaks

A function to add page breaks for rows and columns to a Spreadsheet Object.

spreadsheetAddPagebreaks(SpreadsheetObj, rowbreaks, colbreaks) → returns void

This function requires Adobe ColdFusion 11 and up. Not supported on Lucee, etc.

spreadsheetAddPagebreaks Argument Reference

SpreadsheetObj any
Required

Excel spreadsheet object to apply page break to.

rowbreaks string
Required

Comma-delimited row numbers where the page breaks will be applied.

colbreaks string
Required

Comma-delimited column numbers where the page breaks will be applied.

Examples sample code invoking the spreadsheetAddPagebreaks function

Simple spreadsheetAddPagebreaks Example

CF 11+ Here,we've example to break the excel using spreadsheetaddpagebreaks. It is supported only in adobe coldfusion.

<cfset Detail=SpreadsheetNew("student",false)>
<cfset SpreadSheetAddRow(Detail,"id,Name,Department,marks,average")>
<cfset SpreadSheetAddRow(Detail,"1,Dhar,CS,500,50")>
<cfset SpreadSheetAddRow(Detail,"2,DharC,EEE,600,85")>
<cfset SpreadSheetAddRow(Detail,"3,DharCf,EC,700,90")>
<cfset spreadsheetAddPagebreaks(Detail,'1,2', '3,4')>
<cfset SpreadsheetWrite(Detail,expandPath("./Detail.xls"),true)>