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

AssertionError: Malformed: couldn't find workbookPr node element in 'xl/workbook.xml' #121

Closed
cmcaine opened this issue Nov 13, 2019 · 4 comments
Assignees
Labels
bug Something isn't working

Comments

@cmcaine
Copy link

cmcaine commented Nov 13, 2019

julia> XLSX.readxlsx(fname)                                                                                                             
ERROR: AssertionError: Malformed: couldn't find workbookPr node element in 'xl/workbook.xml'

ExcelReaders.jl is able to read the file.

I'm not able to share the file because it contains confidential information and resaving a smaller example does not reproduce the issue. Possibly the file is slightly malformed and libreoffice is fixing that?

Edit: Resaving the whole file takes ages in libreoffice, but does produce a file that XLSX can read.

The file contains three sheets. Sheets have parentheses in their names. Each sheet contains ~50k rows.

@felipenoris
Copy link
Owner

Oh, this is an easy one.

felipenoris added a commit that referenced this issue Nov 13, 2019
Assumes workbook.date1904 = false when xl/workbook.xml does not have a workbookPr node.
@felipenoris felipenoris self-assigned this Nov 13, 2019
@felipenoris felipenoris added the bug Something isn't working label Nov 13, 2019
@felipenoris
Copy link
Owner

@cmcaine , please check if the XLSX.jl version on the master branch fixes your problem.

@cmcaine
Copy link
Author

cmcaine commented Nov 14, 2019

readxlsx now loads the sheet, but it takes literally minutes to do so.

When it does load, I can't access the data of most cells because they are "inlineStr". I've made a new issue for that, #123

@cmcaine
Copy link
Author

cmcaine commented Nov 14, 2019

Thanks very much for the rapid fix!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants