Whatever message this page gives is out now! Go check it out!
SpreadsheetRemoveSheet
Last update:
May 18, 2026
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 a spreadsheet.
Returns
Nothing
Category
Microsoft Office Integration
Function syntax
SpreadsheetRemoveSheet (spreadsheetObj, sheetname)
See also
History
ColdFusion 9.0.1: Added the function.
Parameters
Parameter | Description |
spreadsheetObj | The Excel spreadsheet object from which you delete the sheet. |
sheetname | Name of the sheet that must be removed. |
Example
<cfset spreadsheetVar= spreadSheetNew("New")>
<cfset spreadsheetCreateSheet(spreadsheetVar,"A")>
<cfset spreadsheetCreateSheet(spreadsheetVar,"B")>
<cfspreadsheet action="write" filename="#dirname#mySpreadSheet.xls" name="spreadsheetVar" overwrite="true" >
<cfspreadsheet action="read" src="#dirname#mySpreadSheet.xls" name="spreadSheetVar" >
<cfset spreadsheetRemoveSheet(spreadsheetVar,"B")>
<cfspreadsheet action="write" filename="#dirname#mySpreadSheet.xls" name="spreadsheetVar" overwrite="true" >
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
|
