How to obtain only calculated values from a formula driven column in an excel file

Trying to get only the calculated values from a formula driven column in an excel file but
it collects the formula that is present in every cell.
Making use of ‘Get Table Column’.

2 Likes

Hi @adb_2022

You can open the workbook with parameter data_only=True to get the values.

# Open workbook with path provided and reading formulas in cells
# as the value stored
# Note: Can only be used with XLSX workbooks
Open Workbook    path/to/file.xlsx    data_only=True
1 Like

hi @mika
this solution worked fine when working with a single sheet but when merged with the entire code where operations with multiple sheets and workbooks are involved(which are involved in other tasks), it is failing to collect the values when tried to save in a list.
The list saves values as none.