You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Right now, the XLSXReader will output the values of column Y as '=A2*2', '=A3*2', '=A4*2', i.e. the formula strings. You would probably want the column to be read as 2, 4, 6, i.e. the calculated values.
Suggested implementation
Looks like this is fixed if you use data_only=True when calling openpyxl.open_workbook. Not sure if that affects anything else, though. Also, perhaps there are cases where the user does want the original formula?
The text was updated successfully, but these errors were encountered:
Say a user has written a spreadsheet like this:
Right now, the
XLSXReader
will output the values of column Y as'=A2*2'
,'=A3*2'
,'=A4*2'
, i.e. the formula strings. You would probably want the column to be read as2
,4
,6
, i.e. the calculated values.Suggested implementation
Looks like this is fixed if you use
data_only=True
when callingopenpyxl.open_workbook
. Not sure if that affects anything else, though. Also, perhaps there are cases where the user does want the original formula?The text was updated successfully, but these errors were encountered: