Create_Sheets

When Create_Sheets is selected in the General tab, the input for the activity is as follows.

Input Item Data Type Description
FilePath String Enter the absolute path for the Excel file with double quotation marks, where the newly created sheets are added.
Note: The FilePath is not displayed when Use Process Data check box is selected on the General tab.
processData Binary Get binary data on the Input tab when Use Process Data check box is selected on the General tab.

Available only when Use Process Data check box is selected on General tab.

SheetName String Enter a name for the sheet with double quotation marks. This element supports duplication.
You can right-click the SheetName node and click Duplicate to create multiple sheets.
Note:
  • Ensure that the name of each sheet is different. Otherwise, only one sheet is created.
  • If the maximum length of the sheet name is more than 31 characters, the process can run successfully, and only the first 31 characters of the sheet name are used.