Last updated on
Apr 27, 2021 06:02:48 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 a spreadsheet.
Returns
Nothing
Category
Microsoft Office Integration
Function syntax
SpreadsheetRemoveSheet (spreadsheetObj, sheetname)
See also
SpreadsheetSetActiveSheetNumber, SpreadsheetAddColumn, SpreadsheetAddImage, SpreadsheetAddRow,
SpreadsheetDeleteRow, SpreadsheetDeleteRows, SpreadsheetFormatRow, SpreadsheetFormatRows,
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" > |
Sign in to your account