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

Read xlsx file contains ole objects and save it make xlsx file corrupted or ole objects missing #36

Open
Pandaaaa906 opened this issue Jul 24, 2023 · 2 comments

Comments

@Pandaaaa906
Copy link

from openpyxl.reader.excel import load_workbook

xlsx_fp = r"D:\xslx_with_ole.xlsx"
out_fp = r"D:\xslx_with_ole_processed.xlsx"


wb = load_workbook(xlsx_fp, keep_vba=True)   # cause corrupted file
wb = load_workbook(xlsx_fp)   # cause ole missing

wb.save(out_fp)
@abdellahaski
Copy link

I run into the same situation, ended up here
were you able to find any workaround ?

@Pandaaaa906
Copy link
Author

I run into the same situation, ended up here were you able to find any workaround ?

found out that this repo is not the official repo

https://foss.heptapod.net/openpyxl/openpyxl/-/issues/2130

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

2 participants