XLSB file support

[pankajsoni19]

Is there any roadmap to support xlsb file format?

[MaxDesiatov]

Hi @pankajsoni19, thanks for bringing this up. Unfortunately, there's no such roadmap. Any pull requests adding such support would be appreciated, but after a cursory look at the spec of that format it doesn't look like that is going to be easy.

SheetJS seems to be providing some support for this format if you'd be interested in using that. Again, looking at that code it confirms my suspicion that supporting .xlsb in CoreXLSX would be hard, I don't think it would map to our Codable models well if at all.

[pankajsoni19]

I did try sheetJS demo examples. I have around 300-500K rows in table with 10 columns. It just crashes my browser window. I would see if our system input can be changed, else will send a pull request shortly.

[MaxDesiatov]

I've found yet another implementation, doesn't look that scary actually in terms of complexity, leaving the link here for posterity

[MaxDesiatov]

And another one in Python...

[pankajsoni19]

What i did was install libreoffice, and use it's headless tool to convert it to csv. then read csv line by line. It helps my use case as the excel sheet is quite big ~150mb and this keeps memory usage low too.