removeSheetNumber - cfsimplicity/spreadsheet-cfml GitHub Wiki

Removes a sheet specified by number from a spreadsheet workbook.

removeSheetNumber( workbook, sheetNumber )

Required arguments

• workbook spreadsheet object
• sheetNumber numeric: the number of the sheet to remove

Chainable? Yes.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new(); //creates "sheet1" by default
spreadsheet.createSheet( workbook,"sheet2" );
spreadsheet.removeSheet( workbook,2 );