I am working on a project where i want to load/update around 100 recipe at a time in MySQL database.
To achieve this we planned to import excel sheet (.xlsx format) in to ignition tag and using transition group or by database script we can load it in MySQL.
We tried using xlrd python lib version ( 0.7.9 ) since my ignition version is 7.9.16. with this we can achieve the goal but the xlrd 0.7.9 version can extract data from old excel version ( .xls format ).
Is there any other way to read to excel workbook using script. we don’t want to import any new module in platform.
Thanks in advance.