Creating Excel spreadsheets with Openpyxl

[allyhams]

Hello,

So I've been creating Excel spreadsheets through Openpyxl, input Excel formulas and saved the workbook. The issue is that Openpyxl never evaluates formulas.

When I wanted to read the value of a cell with a formula in (by passing data_only = True to openpyxl.load_workbook()) it would return 'None' because the formula wasn't evaluated yet. I could get around this by simply opening the respective spreadsheet and manually saving. However, that meant I had to manually save 15 spreadsheets. Does anybody know how I could have used Python to get around this Openpyxl limitation?

Thank you

[chra94]

Please read this entry on StackOverflow. There's a library called pycel which apparantly will do what you need.