| 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 |
|---|
|
| Opens a workbook so that it may be used in the script. |
Opens a workbook so that it may be used in the script.
Parameters
| Table plus |
|---|
| applyColStyleToCell | true |
|---|
| columnTypes | s,s,s,s |
|---|
| heading | 0 |
|---|
| multiple | false |
|---|
| enableSorting | false |
|---|
|
Parameter name | Type | Required | Description |
|---|
path_to_excel_file | String | Yes | File path of the workbook to open. | |
Return Type
Integer
Example
Opens a workbook, adds a new worksheet and then saves and closes the workbook.
| Code Block |
|---|
|
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. |
See also
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 25 |
|---|
| showSpace | false |
|---|
| cql | label = "excel_routine" and space = currentSpace ( ) |
|---|
| labels | array_routines |
|---|
|