HELP on Parsing XLSB File!

[Rafi A]

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.

Regards,
Seeni Rafiyullah Khan A,

P Please consider the environment before printing this email

[Walter Lee Davis]

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

> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
> To post to this group, send email to rubyonra...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CA%2BfXU%2B3f7JMzvhDj%3DxPK6NoE-QvoDnndc4fX9F8mnV8s6Ay--A%40mail.gmail.com.
> For more options, visit https://groups.google.com/d/optout.