How to read data from Excel (.xlsb) Binary File Format?

java perl xlsb
Martin picture Martin · Jun 19, 2013 · Viewed 11.9k times · Source

I am using the POI 3.9 to read data from xlsx. But now I face an issue, the POI don't support the xlsb files, and I need to read data from xlsb programly. Does anybody know how to read data from xlsb programly? Appreciated.

Answer

Tim Allison picture Tim Allison · May 31, 2017

Apache POI added support for streaming reading of XLSB (no write support) in 3.16. Apache Tika 1.15 now supports extraction from XLSB.

Related questions

Difference between \w and \b regular expression meta characters

Can anyone explain the difference between \b and \w regular expression metacharacters? It is my understanding that both these metacharacters are used for word boundaries. Apart from this, which meta character is efficient for multilingual content?

Read More
How can I download all emails with attachments from Gmail?

How do I connect to Gmail and determine which messages have attachments? I then want to download each attachment, printing out the Subject: and From: for each message as I process it.

Read More
How are nested capturing groups numbered in regular expressions?

Is there a defined behavior for how regular expressions should handle the capturing behavior of nested parentheses? More specifically, can you reasonably expect that different engines will capture the outer parentheses in the first position, and nested parentheses in subsequent …

Read More