Skip to main content

Run Formul

The Run Formul component in Robbot RPA is used to run a formula in a specified cell in an Excel file. You can specify the row number, column number, formula, and sheet name.

Parameters​

Row Number : Specify the row number of the cell where you want to run the formula. Type : Integer

Column Number : Specify the column number of the cell where you want to run the formula. Type : Integer

Formula : Specify the formula that you want to run in the cell. Type : String

Sheet Name : Specify the name of the sheet where the cell is located. Type: String

Result : The output of the RunFormula component, which is a boolean value indicating the status of the operation. The value is "True" if the operation is performed correctly, and "False" otherwise. Type : Boolean

Usage​

To use the RunFormula component in your Robbot RPA project, follow these steps:

Open your Robbot RPA project.

Drag and drop the RunFormula component into your sequence or workflow.

Configure the parameters based on your requirements:

Enter the Row Number of the cell where you want to run the formula. Specify the Column Number of the cell where you want to run the formula. Enter the Formula that you want to run in the cell. Specify the Sheet Name where the cell is located. The output of the RunFormula component will be a boolean value indicating the status of the operation. You can use this output to perform further actions or validations based on the success or failure of running the formula.

Continue building your sequence or workflow by adding other components or actions that require the updated Excel file.

Execute the workflow or sequence to run the formula in the specified cell.

The RunFormula component provides a convenient way to run a formula in a specific cell in an Excel file using Robbot RPA. You can specify the row number, column number, formula, and sheet name as parameters.

Note: The RunFormula component relies on external libraries or APIs to modify Excel files. Ensure that you have the necessary dependencies installed or configured in your environment to successfully run the formula in the Excel file.

Please refer to the Robbot RPA documentation or consult your system administrator for more information on working with Excel files and running formulas in Robbot RPA.