excelOpenWorkbook

Syntax	excelOpenWorkbook(path_to_excel_file)	Package	excel
Alias		Pkg Usage	openWorkbook(path_to_excel_file)

Description

Opens a workbook so that it may be used in the script.

Parameter name	Type	Required	Description

Parameter name	Type	Required	Description
path_to_excel_file	String	Yes	File path of the workbook to open.

Integer

Opens a workbook, adds a new worksheet and then saves and closes the workbook.

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

Click here to download the workbook used in this example.