Page Comparison

Button handy

blank	true
color	#0052CC
name	Send Feedback
link	https://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=excelOpenWorkbook+-+15485062
width	auto

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	excelOpenWorkbook(path_to_excel_file)	Package	excel
Alias		Pkg Usage	openWorkbook(path_to_excel_file)

Description

Excerpt

hidden	true

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

...

Table plus

Parameter name	Type	Required	Description
id	Integer	Yes	The id.

Integer

Opens a workbook, adds a new worksheet and then saves and closes the 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.