Last updated on
Feb 25, 2025
Description
Removes the column break in the spreadsheet.
Returns
None
History
ColdFusion (2025 release): Added the function.
Syntax
spreadsheetRemoveColumnBreak(spreadSheetObject, int column)
Parameters
Name
|
Required
|
Type
|
Description
|
spreadSheetObject
|
Yes
|
ExcelInfo
|
The Excel spreadsheet object to which you’ll add a column break.
|
column
|
Yes
|
Integer
|
The column number to remove the break in the spreadsheet.
|
Example
<cfquery name="art" datasource="cfartgallery"> SELECT * FROM ART </cfquery> <cfscript> theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art-col-break.xls"; // create a spreadsheet object theSheet=spreadsheetNew("SampleData") // add rows from the table to the spreadsheet spreadsheetAddRows(theSheet,art) // add row break on col 3 spreadsheetSetColumnBreak(theSheet,3) // remove the row break spreadsheetRemoveColumnBreak(theSheet,3) // write the spreadsheet spreadsheetWrite(theSheet,theFile,"yes") </cfscript>