Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when saving excel with chart #57

Open
cuong02n opened this issue Jun 17, 2024 · 0 comments
Open

Error when saving excel with chart #57

cuong02n opened this issue Jun 17, 2024 · 0 comments

Comments

@cuong02n
Copy link

cuong02n commented Jun 17, 2024

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
Error Notification

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.
Result

The alert:
enter image description here

  1. Allow openpyxl to read the charts with the right way.
  2. Make openpyxl read specific sheet, and other sheets will be pass.
  3. Avoid openpyxl decrease the size of file (I think openpyxl do it for perfomance)

I asked this question in StackOverFlow

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant