spreadsheetRemoveColumnBreak

ColdFusion

Open app

Description

Removes the column break in the spreadsheet.

Returns

None

History

ColdFusion (2025 release): Added the function.

Syntax

spreadsheetRemoveColumnBreak(spreadSheetObject, int column)

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

SELECT * FROM ART

</cfquery>

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>

<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>

<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>

Get help faster and easier

New user?