Skip to main content

Read ODS files into a pandas DataFrame while preserving direct formatting (bold, italic, underline) as markup (AsciiDoc, Markdown, HTML).

Project description

direct-formatting-pandas-ods-reader

Inspired from pandas-ods-reader, but with the ability to read direct formatting. pandas-ods-reader relies on ezodf to extract cell content, but ezodf ignores direct formatting, so we need to go at a lower level.

The direct formatting is turned into markup in the resulting pandas DataFrame.

Dependencies

  • lxml
  • pandas

Usage

from direct_formatting_pandas_ods_reader import read_ods

read_ods("test/test.ods")

read_ods("test/test.ods", format="markdown")

read_ods("test/test.ods", format="html", sheet=0)

The format argument can be either html, markdown or asciidoc, and defaults to asciidoc. There is also a sheet argument that defaults to 0, which corresponds to the first sheet of the file.

License

Licensed under the GNU GPL v3.0, Yann Trividic.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

direct_formatting_pandas_ods_reader-0.1.0.tar.gz (43.5 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

File details

Details for the file direct_formatting_pandas_ods_reader-0.1.0.tar.gz.

File metadata

File hashes

Hashes for direct_formatting_pandas_ods_reader-0.1.0.tar.gz
Algorithm Hash digest
SHA256 3eec47e871524360b0a6db3c6d3d0feee553a65e1bc2d26e8aed3c41241bc186
MD5 9b28e6d88c9a4eb24d6435e4a0d610df
BLAKE2b-256 913e777a25e2f92d662b81f7e34f7aa95030b1c1e02813af64ff720b44b14ef7

See more details on using hashes here.

File details

Details for the file direct_formatting_pandas_ods_reader-0.1.0-py3-none-any.whl.

File metadata

File hashes

Hashes for direct_formatting_pandas_ods_reader-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 1871e82d1712aba21f9f5d7e1160bf0eb0bf10cff656fe94b667e57991448141
MD5 1a9fc94b5f9c71607092a05555fdcdcc
BLAKE2b-256 a7f77515d5095506c2c73516b12ec6b6537d655718b650ee7e4141119481dea0

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page