removeSheet - cfsimplicity/spreadsheet-cfml GitHub Wiki

Removes the named sheet from a spreadsheet workbook.

removeSheet( workbook, sheetName )

Required arguments

• workbook spreadsheet object
• sheetName string: the name of the sheet to remove

Chainable? Yes.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.createSheet( workbook,"test" );
spreadsheet.removeSheet( workbook,"test" );