Description

This function returns the number of columns in a worksheet.

Returns

Integer

History

New in Adobe ColdFusion (2016 release)

Category

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

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy