I manage several large Excel files that are updated multiple times each day. Rather than rely on macros or VBA, I'd like to programmatically update the data by extracting the relevant zipped sheets and streaming through them one at a time.
That's easy enough with XLSX files since their components are all XML. There are many resources for doing this with XLSX files. There are very few (if any?) for XLSB files because their components are all binary.
How does one convert binary files to human-readable formats, or parse them in a human-readable way?
No comments:
Post a Comment