Last updated on
Apr 27, 2021 06:02:52 AM GMT
|
Also Applies to ColdFusion
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
Deletes the data from multiple columns of an Excel spreadsheet object. This function does not remove the columns.
Returns
Nothing
Category
Syntax
SpreadsheetDeleteColumns (spreadsheetObj, range)
See also
History
ColdFusion 9: Added the function.
Parameters
Parameter |
Description |
---|---|
spreadsheetObj |
The Excel spreadsheet object from which to delete the columns. |
range |
A string containing the columns to delete, using any combination of the following formats:
|
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. Set xml to true as this is an xlsx file 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,"ColdFusion1"); // new query for the new sheet Artists=QueryExecute("Select * from APP.ARTISTS",[],{datasource="cfartgallery"}); // Add rows to the sheet SpreadSheetAddRow(mySheet,"ARTISTID,First Name,Last Name,Address,CITY,STATE,POSTALCODE,EMAIL,PHONE,FAX,THEPASSWORD"); SpreadSheetAddRows(mySheet,Artists); // Delete columns 5-8 in the sheet ColdFusion1 SpreadsheetDeleteColumns(mySheet,"5-8"); SpreadsheetWrite(mySheet,"#myFile#",true); </cfscript>
Output

Sign in to your account