Getting Cell Values from Excel Sheets with Cell Functions

I need to grab data from a cell for calculating, but the cell value has a function like =TODAY() or =SUM(A1:B9) and the recorder variables aren’t recording the actual values produced by these equations.

Any workarounds?

Hi @martina_r we are planning to add Excel actions that work with cells that have formulas later this month.

The workaround for now would be to open the Excel file on the screen and copy the data using mouse clicks, keystrokes and clipboard actions.

Hi @martina_r Excel actions now work with formulas.

2 Likes