Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #71839

Re: Reading OpenOffice spreadsheet in Python?

Show all headers | View raw

Skip Montanaro <skip@pobox.com> writes:
> ...
> That then puts me in the market for an xlrd
> replacement. Is there something akin to xlrd for OpenDocument
> spreadsheets?

Unlike the binary "excel" format (at least for early versions),
"OpenDocument" is a well documented
file format (a zip file containing various XML files; processible
by standard XML tools). Thus, you may get at the content
via "zipfile" and Python's "xml" tools.

It might be possible to create an "xlrd" replacement based
on "zipfile" and the "xml" package -- but, of course, one
would need to study the (complex) description for the involved
XML files.

In the "Plone" world, there are text extractors/html converters
for "OpenDocument" which go this route. I do not know how
well they work.

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Reading OpenOffice spreadsheet in Python? dieter <dieter@handshake.de> - 2014-05-21 08:25 +0200

csiph-web