Registry / data / pyexcel-ods3

pyexcel-ods3

library0.6.1pypypi✓ verified 87d ago

A wrapper library to read, manipulate and write data in ODS (Open Document Spreadsheet) format, version 0.6.1. It is part of the pyexcel ecosystem and requires Python 3.6+. Release cadence is low; last release was in 2020.

data serialization

pip install pyexcel-ods3

github ↗package ↗

INSTALL

IMPORT

SIG · PYEXCEL-ODS3

pyexcel-ods3

datapythonv0.6.1

Install

2.3s avg

Import

99ms

Disk

29MB

Pass rate

10/ 10

Env Coverage10 / 10

glibc

3.9–3.13

musl

3.9–3.13

Install & Compatibility

Where this runs

tested against v0.6.1 · pip install

no network on importno background threads

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

py 3.10–3.95 runs

installs and imports cleanly · install 0.0s · import 0.106s · 30.8MB

glibc

py 3.10–3.95 runs

installs and imports cleanly · install 2.3s · import 0.092s · 31MB

29MB installed

● package 29MB

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

get_data

✓ from pyexcel_ods3 import get_data

✗ import pyexcel_ods3

pyexcel-ods3 exposes functions directly, not as a module with a class.

save_data

✓ from pyexcel_ods3 import save_data

✗ from pyexcel_ods3 import save

Function is named save_data, not save.

Write and read ODS files with a simple 2D list. Note that keys in the result dict are sheet names.

from pyexcel_ods3 import save_data, get_data data = [[1, 2, 3], ['a', 'b', 'c']] save_data('test.ods', data) loaded = get_data('test.ods') print(loaded)

Debug

Known issues

breakingIn v0.6.0, the plugin system was revamped. If you upgraded from <0.6.0, you must reinstall or update pyexcel-io and pyexcel-ezodf.

fix

Run: pip install --upgrade pyexcel-ods3 pyexcel-io pyexcel-ezodf

affects: >=0.6.0

gotchapyexcel-ods3 uses dicts for sheet data; sheet names are dict keys. If the file has multiple sheets, the dict will have multiple entries. Iterating over dict values yields sheets as 2D lists.

fix

Always iterate over dict values or handle sheet names explicitly: for sheet_name, sheet_data in get_data('file.ods').items(): ...

affects: all

deprecatedPython 3.5 support was dropped in v0.6.0. pyexcel-ods3 now requires Python >=3.6.

fix

Use Python 3.6 or newer.

affects: >=0.6.0

Errors

Common errors & fixes

ModuleNotFoundError: No module named 'pyexcel_ods3'

Package not installed or incorrect import name.

fix

Install with: pip install pyexcel-ods3. Then import: from pyexcel_ods3 import get_data

AttributeError: module 'pyexcel_ods3' has no attribute 'save'

Using wrong function name (save instead of save_data).

fix

Use: from pyexcel_ods3 import save_data

Upgrade

Version history

0.6.1latest on PyPI · released Jan 30, 2022

Audit

Dependencies

pyexcel-iorequiredCore plugin system for reading/writing tabular data

pyexcel-ezodfrequiredODS file handling library

lxmlrequiredXML parsing used by ezodf

Agent activity

7 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/pyexcel/pyexcel-ods3 ↗

packagehttps://pypi.org/project/pyexcel-ods3/ ↗