Page Comparison

Table plus

applyColStyleToCell	true
heading	0
columnTypes	s,s,s,s
multiple	false
columnAttributes	style="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold,
enableSorting	false

Syntax	excelRemoveSheet(workbookFID, worksheet_name)	Package	excel
Alias		Pkg Usage	removeSheet(workbookFID, worksheet_name)

Description

Excerpt

hidden	true

Removes the selected sheet from an open workbook.

Table plus

Parameter name	Type	Required	Description
workbookFID	Integer	Yes	The file id of the open workbook. The file id is returned from running the excelOpenWorkbook() routine.
worksheet_name	String	Yes	The name of the worksheet to be deleted

Boolean

Returns true if the operation was successful, false otherwise.

Opens a workbook, deletes a sheet and then saves and closes the workbook.

Code Block

language	js

use "excel";
int fid = openWorkbook("snakes.xlsx");
removeSheet(fid, "Venemous Snakes", 4);
closeWorkbook(fid);

Result: The 'Venemous Snakes' sheet will be removed.

Note
Click here to download the workbook used in this example.