reading in excel xml file format

[jamietssg]

Hi Thomas
Thanks for the support!

I am wondering if ruby-roo can read the new EXCEL xml file format?
I've tired the code but get the following error:

are you sure, this is an excel file?
c:/ruby/lib/ruby/gems/1.8/gems/parseexcel-0.5.2/lib/parseexcel/
olestorage.rb:354:in `get_header': OLE::UnknownFormatError
(OLE::UnknownFormatError)

I take it that this means the ruby-roo/ parseexcel cannot read the
excel xml file type? Are you aware if it is possible and if exists
another library for this?

If not I'll go with reading in the xml file as done to normal ruby
way.

Thanks
Jamie

[Kent Dahl]

ti., 22.07.2008 kl. 03.43 -0700, skrev jamietssg:
> Hi Thomas
> Thanks for the support!
>
> I am wondering if ruby-roo can read the new EXCEL xml file format?

Do you mean this:
"* Excel new file format .xlsx"
as mentioned on:
http://roo.rubyforge.org/

> I take it that this means the ruby-roo/ parseexcel cannot read the
> excel xml file type? Are you aware if it is possible and if exists
> another library for this?

I think you need to use the Excelx class for this. I.e.:
file = Excelx.new("path/to/file.xlsx")

But I haven't tried it myself. Not too fond of the latest MS XML formats
and their "standardization" efforts. :P

--
Kent Dahl <ken...@pvv.org> --- http://www.pvv.org/~kentda/

[jamietssg]

Thanks for the feedback Kent,

What i mean is a file created with excel with the format .xml not
xlsx.

Any ideas on that one?

Thanks
jamie

[Thomas Preymesser]

Hi Jamie,

2008/7/24 jamietssg <jamie...@gmail.com>:

Thanks for the feedback Kent,

What i mean is a file created with excel with the format .xml not
xlsx.

is this xml-format an exported file from an excel spreadsheet or can excel also read these xml files?
Currently roo does only support the internal .xlsx file format.

-Thomas