spreadsheet_decoder fix xml elements namespace and sharedString/styles file search

fix xml elements namespace and sharedString/styles file search

Open dorym opened this issue 2 years ago • 2 comments

This fixes 2 things:

I encountered some spreadsheets that have namespaces in their xml tags. This sets the default lookup for any namespace.
styles and shareStrings file paths are concatenated in a wrong way where is some cases the given path in workbook.xml.rels is absolute. I used the same solution in _parseTable(). It may be useful to extract this logic.

Apr 12 '23 11:04 dorym

Thank you for this PR. Can you add a test file and a test case for it?

Apr 12 '23 15:04 sestegra

@dorym To merge the PR, a test file and its related test case are required.

Apr 22 '23 14:04 sestegra