Insert Formula
Object to insert formulas into a new worksheet in an Excel file
Last updated
Object to insert formulas into a new worksheet in an Excel file
Last updated
This object depends on the use of the "New Excel" or "Open Excel" object to work.
Field | Descriptive |
Title | Object title |
Select Main Object | Option to select an Excel spreadsheet |
Select Range | Allows you to enter a range of cells |
Cell | Option to inform the cell |
Formula | Option to inform the formula |
Type | Option to select the data type |
To insert formulas into a spreadsheet you need to follow a few steps and have a pre-existing file:
1 - Select the "Open 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 "Select Sheet" object from the "Excel" menu, the main object defined when opening Excel and define the name of the sheet to be selected.
3 - Then you must select the "Insert Formula" object in the "Excel" menu, the main object and enter the cell in which the formula will be inserted.
If you select the "Select Range" option, inform the corresponding columns and rows for formatting.
4 - Finally, enter the formula and the data type.
