So I’m looking at a project that needs to insert data in to a worksheet in an excel workbook, about 200 cells. this will happen once a week and the worksheet changes very week.
I’d like to do this within Ignition using a script. I found the openpyxl python library and this seems to fit the bill, however the latest versions only support Python down to 2.6 not 2.5 that Ignition uses. I found version 1.7 (the latest to support python 2.5) and it works fine except it will not maintain the spreadsheet conditional formatting that I need. If I try to use a newer openpyxl version then I get errors in the first few lines of library as it loads.
I don’t really know how big the changes between python 2.5 and 2.6 are, is it worth me trying to modify openpyxl to work with 2.5 (feels like a massive job) or do we know if 2.6 or higher will be implemented in Ignition 7.8?
Is there a better way?