python-calamine 0.0.8

Python binding for Rust's library for reading excel and odf file - calamine

python-calamine

Python binding for beautiful Rust's library for reading excel and odf file - calamine.

Is used

• calamine
• pyo3
• maturin

Installation

pip install python-calamine

Example

from python_calamine import get_sheet_data, get_sheet_names


get_sheet_names("file.xlsx")
# ['Sheet1', 'Sheet2']

get_sheet_data("file.xlsx", "Sheet1")
# [
# ['1',  '2',  '3',  '4',  '5',  '6',  '7'],
# ['1',  '2',  '3',  '4',  '5',  '6',  '7'],
# ['1',  '2',  '3',  '4',  '5',  '6',  '7'],
# ]

By default, calamine skips empty rows/cols before data. For suppress this behaviour, set skip_empty_area to False.

from python_calamine import get_sheet_data

get_sheet_data("file.xlsx", "Sheet1", skip_empty_area=False)
# [
# ['',  '',  '',  '',  '',  '',  ''],
# ['1',  '2',  '3',  '4',  '5',  '6',  '7'],
# ['1',  '2',  '3',  '4',  '5',  '6',  '7'],
# ['1',  '2',  '3',  '4',  '5',  '6',  '7'],
# ]

Also, you can use monkeypatch for pandas for use this library as engine in read_excel().

from pandas import read_excel
from python_calamine.pandas import pandas_monkeypatch


pandas_monkeypatch()

read_excel("file.xlsx", engine="calamine")
#            1   2   3   4   5   6   7
# 0          1   2   3   4   5   6   7
# 1          1   2   3   4   5   6   7

Also, you can find additional examples in tests.