CreateWorksheet
Creates a new worksheet in an Excel workbook. If the workbook does not exist, the workbook will also be created.
Input
Name | Type | Description |
File | String | The path to the Excel workbook. |
Sheet | String | The name of the Excel worksheet to create inside the workbook.
The default value is sheet1. |
Columnnames | String | Comma-separated list of column names to add to the new spreadsheet. Column names cannot contain white space. |
Result Set Columns
Name | Type | Description |
File | String | The name of Excel workbook that has been updated. |
Sheet | String | The name of the Excel worksheet created inside the workbook. May be different from the sheet specified if the name conflicts with an existing sheet. |