search

CoreOffice / CoreXLSX

Excel spreadsheet (XLSX) format parser written in pure Swift
Apache License 2.0
831 stars 87 forks source link

XLSB file support #104

Open pankajsoni19 opened 4 years ago

pankajsoni19 commented 4 years ago

Is there any roadmap to support xlsb file format?

MaxDesiatov commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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

MaxDesiatov commented 4 years ago

And another one in Python...

pankajsoni19 commented 4 years ago

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.