Extracting cell formulas

Activity Description

Extracting cell formulas from an Excel worksheet

Property Description

Output cell formulas

output variable, by setting the output variable, the cell formula will be saved to this variable

cell name

fill in the need to get the name of the cell value, such as “B5”.

Working Sheet Name

fill in the name of the Excel worksheet Sheet

Full path of the file

Fill in the full path of the Excel file, you can also click the icon on the right side of the input box, to select the full path of the file

Example of using

Run Result:

Execution steps: Get the specified Excel file, Sheet1 worksheet in cell B5 of the formula - to get the results output to the tqdyggs variable - with the log will be the tqdyggs variable content print out!

Note: the implementation of the activity, the first activity to close the need to use the Excel file