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