SpreadsheetGetColumnCount

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:

Log in with your Gmail or Facebook credentials.
Navigate to the project in the left pane.
Once you make some changes in any cfm in the project, a pop up displays asking you to save the project.
Give the project a suitable name and click Save.

Description

This function returns the number of columns in a worksheet.

Returns

Integer

History

New in Adobe ColdFusion (2016 release)

Syntax

SpreadsheetGetColumnCount(ExcelInfo, Sheetname / Sheet number)

Parameters

Parameter	Description
ExcelInfo	The spreadsheet object for which you want to return the number of columns.
Sheetname / Sheet number	The name of the spreadsheet or the sheet number.

Example

<cfscript>
       ArtOrders=QueryExecute("SELECT orderid,customerfirstname,customerlastname,address,total,city FROM orders
       ORDER BY orderid",[],{datasource="cfartgallery"});
       // Set the file path in the same location as this cfm
       myFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "myexcelfile.xls";
       // create spreadsheet object. 
       mySheet=SpreadsheetNew("ColdFusion",false);
       // Create another worksheet coldfusion1
       SpreadsheetCreateSheet(mySheet,"ColdFusion1");
       // Set headers for the xlsx file
       SpreadSheetAddRow(mySheet,"Order,First Name,Last Name,Address,Amount,City");
       SpreadSheetAddRows(mySheet,ArtOrders);
       
              
       // set coldfusion as active sheet
       SpreadsheetSetActiveSheet(mySheet,"ColdFusion");

        // new query for the new sheet
 Artists=QueryExecute("Select * from APP.ARTISTS",[],{datasource="cfartgallery"});
 SpreadSheetAddRow(mySheet,"ARTISTID,First Name,Last Name,Address,CITY,STATE,POSTALCODE,EMAIL,PHONE,FAX,THEPASSWORD");
 SpreadSheetAddRows(mySheet,Artists);

       // Get number of columns in the active sheet
       getCount=SpreadsheetGetColumnCount(mySheet,"ColdFusion");
       WriteOutput("Number of columns are: " & #getCount#);

</cfscript>

Output

Number of columns are: 6

Sign in to your account