python-calamine
python-calamine
Python binding for beautiful Rust's library for reading excel and odf file - calamine.
Is used
calamine
pyo3
maturin
Installation
Currently, whl's builds are provided only for linux.
pip install python-calamine
Example
from python_calamine import get_sheet_data, get_sheet_names
get_sheet_names("file.xlsx")
# ['Page1', 'Page2']
get_sheet_data("file.xlsx")
# [
# ['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
More Articles of DIVYANSHU SRIVASTAVA:
| Name | Views | Likes |
|---|---|---|
| python-tiktok | 277 | 0 |
| python-youtube | 152 | 0 |
| python-calamine | 138 | 0 |
| vouched-python | 108 | 0 |
| python-cephclient | 132 | 0 |
| python-pylontech | 139 | 0 |
| higlass-python | 136 | 0 |
| python-metallum | 112 | 0 |
| ai-python | 106 | 0 |
| python-cardano | 101 | 0 |
| switchboard-python | 87 | 0 |
| python-mistralclient | 88 | 0 |
| pyqode.python | 89 | 0 |
| joycon-python | 91 | 0 |
| python-minesweeper | 103 | 0 |
| petro-python | 101 | 0 |
| python-dali | 95 | 0 |
| python-binance | 132 | 0 |
| pyzwave | 101 | 0 |
| python-datamatrix | 123 | 0 |
| python-ninegag | 89 | 0 |
| python-brihome | 98 | 0 |
| python-stacktaskclient | 85 | 0 |
| python-multimapwithttl | 92 | 0 |
| python-geoip-python | 89 | 0 |
| Messages | 120 | 0 |
Comments