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
Environment: Ubuntu 20.04, Qt5.14.1, Python3.8.10, Pip 20.0.2, Openpyxl3.0.9/Openpyxl3.1.5
In the above environment, I used Python to call openpyxl to create an xlsx file and write a string into it, then saved it as "openpyxl_create.xlsx". Afterwards, when I tried to read the content of openpyxl_create.xlsx using a Qt project with QXlsx, I found that the reading failed. Only after first saving the openpyxl_create.xlsx file as an Excel 2007-365 formatted xlsx file using LibreOffice Calc, was QXlsx able to read the file's content. This method yielded the same test results for both openpyxl3.0.9 and openpyxl3.1.5. I hope QXlsx can directly read and write files created by openpyxl and that openpyxl can directly read and write files created by QXlsx; that would be really cool.
The text was updated successfully, but these errors were encountered:
Here is the Python script I wrote to generate an xlsx file:
import openpyxl
path = './exa.xlsx'
wb = openpyxl.Workbook()
sheet = wb.active
record_data = ['step','loss']
sheet.append(record_data)
wb.save(path)
wb.close()
Environment: Ubuntu 20.04, Qt5.14.1, Python3.8.10, Pip 20.0.2, Openpyxl3.0.9/Openpyxl3.1.5
In the above environment, I used Python to call openpyxl to create an xlsx file and write a string into it, then saved it as "openpyxl_create.xlsx". Afterwards, when I tried to read the content of openpyxl_create.xlsx using a Qt project with QXlsx, I found that the reading failed. Only after first saving the openpyxl_create.xlsx file as an Excel 2007-365 formatted xlsx file using LibreOffice Calc, was QXlsx able to read the file's content. This method yielded the same test results for both openpyxl3.0.9 and openpyxl3.1.5. I hope QXlsx can directly read and write files created by openpyxl and that openpyxl can directly read and write files created by QXlsx; that would be really cool.
The text was updated successfully, but these errors were encountered: