openpyxl
openpyxl copied to clipboard
Error when saving excel with chart
There is only 2 line of code
workbook = load_workbook(filename='input.xlsx', keep_vba=True, rich_text=True)
# I will do operator here, but there is an error, so I comment this line
workbook.save('output.xlsx')
The input.xlsx
When I try to open output.xlsx, This notification appear
And Result: The Chart was remove by MS Excel, Sometime I cannot open it by MS Excel Office, but another App like LibraOffice can open with no error.
- Allow openpyxl to read the charts with the right way.
- Make openpyxl read specific sheet, and other sheets will be pass.
- Avoid openpyxl decrease the size of file (I think openpyxl do it for perfomance)