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	excelAddSheet(workbookFID, worksheet_name [, make_default])	Package	excel
Alias		Pkg Usage	addSheet(workbookFID, worksheet_name [, make_default])

Description

Excerpt

hidden	true

Adds a new sheet to the 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 added.
make_default	Boolean	No	If the newley added worksheet should be made the default worksheet, true/false.

Boolean

Returns true if the operation was successful, false otherwise.

Add a new worksheet to an existing workbook.

Code Block

language	js

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

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