excelCreate
Version 22.0.8473
excelCreate
Version 22.0.8473
Create a new Excel worksheet.
Required Parameters
- sheet: The name of the Excel worksheet to create inside the workbook. The default value is ‘sheet1’.
Optional Parameters
- file: The path to the Excel workbook.
- version: The version of Excel you are using. The allowed values are ‘AUTO, 95, 97-2003, 2007’. The default value is ‘AUTO’.
- overwrite: Indicates whether to overwrite the file if it already exists. The allowed values are ‘true, false’. The default value is ‘false’.
- columnnames: Comma-separated list of the column names of the new spreadsheet. Column names cannot contain white space.
Output Attributes
- file: The name of the Excel workbook updated.
- sheet: The name of the Excel worksheet to be created inside the workbook. May be different from the sheet specified if the name conflicts with one already existing.