Hi,
I am using ROO gem on my application for parsing excel files. Now I got an scenario to parse xlsb file but that gem throws me an error. Also I have tried with Creek, spreadsheet gems to parse the xlsb file but no luck.
Is there a way to do that in Rails then please let me know.
I would start by looking at the contents of that file with a text editor, see if there is any XML in it. (Note: you may need to convert the file from a Zip package before you can do that, or use a Mac and BBEdit (which can read "into" Zipped formats like ePub and XSLX and show the plain-text contents therein). The Excel-reading gems that I know of only work on "modern" Excel, the XML-based formats. I've not heard of this XSLB format before, could it mean that it's a binary file? You should know when you look in the package. If it does turn out to be that, you may need to use something like OpenOffice or a Windows server and COM objects to deal with it.
Walter
Keep up to date with Rails on Twitter and This Week in Rails
Policies: Conduct, License, Maintenance, Security, Trademarks