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.