Whatever message this page gives is out now! Go check it out!
spreadsheetSetColumnHidden
Last update:
May 18, 2026
Description
Hides or shows a specified column in a spreadsheet.
Returns
None
History
- ColdFusion (2025 release): Added the function.
Syntax
spreadsheetSetColumnHidden(spreadSheetObject,column,hide)Parameters
Name | Required | Type | Description |
spreadSheetObject | Yes | ExcelInfo | The Excel spreadsheet object where the row is to be hidden or displayed. |
column | Yes | Integer | The column number which needs to be hidden. |
hide | No | Boolean | True to hide the row. False to show the row. |
Example
<cfquery name="art" datasource="cfartgallery">
SELECT * FROM ART
</cfquery>
<cfscript>
theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "art-another.xls";
// create a spreadsheet object
theSheet=spreadsheetNew("SampleData")
// add rows from the table to the spreadsheet
spreadsheetAddRows(theSheet,art)
// hide column 6 in the spreadsheet
spreadsheetSetColumnHidden(theSheet,6,"TRUE")
// write the spreadsheet
spreadsheetWrite(theSheet,theFile,"yes")
// show column 6 that was previously hidden
spreadsheetSetColumnHidden(theSheet,6,"FALSE")
// write the spreadsheet
spreadsheetWrite(theSheet,theFile,"yes")
</cfscript>
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Share additional feedback to help us improve.
0/255
|
