excelCreate

Version 23.4.8800


excelCreate

Version 23.4.8800


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.