FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

Parse XLSX files with unusual structure by stenlarsson · Pull Request #129 · pythonicrubyist/creek · GitHub

Parse XLSX files with unusual structure - #129

Open
stenlarsson wants to merge 2 commits into
pythonicrubyist:masterfrom
burtcorp:parse-unusual-structure
Open

Parse XLSX files with unusual structure#129
stenlarsson wants to merge 2 commits into
pythonicrubyist:masterfrom
burtcorp:parse-unusual-structure

Conversation

Copy link
Copy Markdown

Normally you will find workbook.xml in the xl directory, but recently we got a file where it was located in the root.

To find the actual location of workbook, we must parse the file _rels/.rels. A separate rels file located relative to the workbook then points out the locations of the sheets, styles and shared strings.

Copy link
Copy Markdown
Author

This has conflicts with master because I based it on 2.5.3 which doesn't have the performance regressions described in #122.

Normally you will find `workbook.xml` in the `xl` directory, but recently we got a file where it was located in the root.

To find the actual location of workbook, we must parse the file `_rels/.rels`. A separate rels file located relative to the workbook then points out the locations of the sheets, styles and shared strings.
stenlarsson force-pushed the parse-unusual-structure branch from 661a6c6 to e46a9d8 Compare October 11, 2024 07:45
We found an XLSX missing the `_rels/.rels` file, and in this case falling back to the default path worked.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
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

Successfully merging this pull request may close these issues.

1 participant


Back | FazBrowse Home | New Git URL