Closed dragonworks closed 4 years ago
When importing an Excel xlsx file it reads the cell formulas instead of the cell values.
I think when importing an Excel spreadsheet it's the values that would be wanted and not the formulas?
For example, if a cell has the formulas '=SUM(A1:A3)' it will read that string instead of the calculated number in Excel.
Passing data_only=True to openpyxl's load_workbook will load the cell values instead of formulas.
I created a pull request that does this https://github.com/jazzband/tablib/pull/461
When importing an Excel xlsx file it reads the cell formulas instead of the cell values.
I think when importing an Excel spreadsheet it's the values that would be wanted and not the formulas?
For example, if a cell has the formulas '=SUM(A1:A3)' it will read that string instead of the calculated number in Excel.
Passing data_only=True to openpyxl's load_workbook will load the cell values instead of formulas.
I created a pull request that does this https://github.com/jazzband/tablib/pull/461