Skip to main content

Read Cell Formula

UiPath.Excel.Activities.Business.ReadCellFormulaX

Description​

Copies the formula from a spreadsheet cell. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

Configuring the activity​

Designer panel​

  • Cell - Select Plus on the right side of the field and then, from the menu, select an Excel file and a named cell whose formula to read, or select Indicate in Excel to indicate a cell directly from the file. Alternatively, you can select Custom Input to enter a cell address manually, or Open in Advanced Editor to enter a VB expression.

  • Save to - Select Plus on the right side of the field and then, from the menu, select where to save the formula:

    • Save to the Project Notebook or a parent Excel file. For example, you can save to a cell in an Excel file.
    • Copy to clipboard - Save the formula to the clipboard.
    • Save for Later Use - Save the formula for later use in the project.
    • Open in Advanced Editor - Enter a VB expression.

Properties panel​

Common​

  • DisplayName - The name displayed for the activity in the Designer panel.

Input​

  • Cell - See Cell in the body of the activity.

Misc​

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output​

  • Save to - See Save to in the body of the activity.