Insert Spreadsheet
Object to insert a new sheet in the Excel file
Last updated
Object to insert a new sheet in the Excel file
Last updated
This object depends on the "New Excel" or "Open Excel" object to work.
Field
Descriptive
Title
Object title
Select Main Object
Option to select the Excel object
New Spreadsheet
Name of the new spreadsheet
To add a new worksheet in Excel, you must have a pre-existing Excel file or create a file:
1 - For this tutorial, select the "Create Excel" object from the "Excel" menu and drag it to your working area.
First you must define a unique name for the object in the "Object Identifier Name" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.
2 - Then select the "Insert Sheet" object from the "Excel" menu, select the main object defined when creating the Excel file, and define the name of the new sheet to be inserted:
3 - The working area will look like this:
