Read formula from Excel Action(Power Automate Desktop)
This action sets the formula of the specified cell to a variable.
You cannot read the value with this action.
To get values, use “Read from Excel worksheet”.
How to use
First, specify the target Excel file in the Launch Excel Action or the Attach to Running Excel Action, then drag the "Read formula from Excel" Action from "Excel.Advanced" onto the workspace.
Set parameters.
Parameters
Excel instance
Specify the target Excel file.
Specify the Variables produced for the Launch Excel Action or the Attach to running Excel Action.
Retrieve
Choose how to get the value.
The parameters you specify additionally will differ depending on your choice.
- The formula of a single cell
- The formula of a named cell
Because there is no worksheet specification, the active
worksheet will be the target.
If there are multiple worksheets, it is unclear which sheet is active.
Therefore, we recommend specifying the sheet in “Set active Excel worksheet”.
The formula of a single cell
The cell position is specified by “Start row” and “Start column”.
If both are specified as 1, the formula is obtained from cell A1.
The formula of a named cell
Get the formula of the named cell.
If you specify the name of a cell range, the formula of only the top-left cell will be obtained.
Variables produced
CellFormula
This is a variable that stores the formula that has been read in.
If the contents of the specified cell are not a formula, it will be left blank. Even if there is a value, it will be ignored.
For those who want to learn Power Automate Desktop effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.