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

Groups > comp.lang.python > #71839 > unrolled thread

Re: Reading OpenOffice spreadsheet in Python?

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

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

#71839 — Re: Reading OpenOffice spreadsheet in Python?

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.

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web