excelCreate

Version 21.0.8222


excelCreate

Version 21.0.8222


Create a new Excel worksheet.

必要なパラメータ

  • sheet:The name of the Excel worksheet to create inside the workbook. The default value is ‘sheet1’.

オプションのパラメータ

  • file:The path to the Excel workbook.
  • version:The version of Excel you are using. The allowed values are ‘AUTO, 95, 97-2003, 2007’.デフォルト値はAUTO です。
  • overwrite:Indicates whether to overwrite the file if it already exists.true またはfalse が使用可能です。デフォルト値は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.