Use this action to create a new workbook with one sheet.
Step 1. Create a process and give it a name.
Step 2. Drag the Create Workbook action to the canvas and link it to the other actions.
Step 3. Create the variables needed for the configuration of the action, and then add them to the configuration panel:
- Workbook name: you must enter a string variable that represents the workbook name (.xlsx file extension is added automatically)
- Sheet name: you must enter a string variable representing the name of the first sheet in the workbook
- Workbook: file variable output which contains the workbook with your given name and given sheet name
Step 4. Save, Validate and Run the process.
Step 5. You will be prompted to add the file for our input variable (if the values are not already added as default values for each variable). Click Run.
Step 6. To verify the process click Check instance.
Step 7. In the Output section, you can see the file variable with the .xls content as defined. You can download the file: