Python: read .xls with formula inside

  dataframe, openpyxl, pandas, python, xlrd

I need to transform an input file (.xls) with formula into an .xlsx file that has only the value/data of the formula.

-Openpyxl cant read xls files, but got the "data only" flag when reading the file.
-xlrd etc. can read xls files, but cant read these with "data only" flag like openpyxl can..

When I try to transform the xls file to an xlsx in python to open it with openpyxl afterwards, all the values with formula become "0".

Does anyone know how I can deal with this issue?

Source: Python Questions

LEAVE A COMMENT