Read and write list of `pandas.DataFrame`s of tabular data from/to excel file.
Project description
xlsx2dfs
Easy loading from and writing to excel sheets to/from pandas DataFrames (and list of sheet_names).
Installation
pip install xlsx2dfs
Usage
from xlsx2dfs import xlsx2dfs, withNames, dfs2xlsx
# xlsx file path
fpath = "test.xlsx"
# read from it:
dfs, sheet_names = xlsx2dfs(fpath)
# write to it
out_fpath = "out_test.xlsx"
dfs2xlsx(dfs, sheet_names=["sheet1", "sheet2", "sheet3"], out_fpath=out_fpath)
# or using `withNames` which allows alternate input of sheet_name and corresponding df
dfs2xlsx(withNames("sheet1", dfs[0], "sheet2" dfs[1], "sheet3", dfs[2]), out_fpath)
document the version:
- Linux:
$ pip freeze | grep xlsx2dfs
- Windows:
c:\> pip freeze | findstr xlsx2dfs
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
xlsx2dfs-0.1.0.post5.tar.gz
(2.5 kB
view hashes)
Built Distribution
Close
Hashes for xlsx2dfs-0.1.0.post5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | eb88b731cd1c698f796d1f41e5137e3595bc128c9657636463b05eb1b42c4b6c |
|
MD5 | ce2c8ed97657d8e174ef486ab7422723 |
|
BLAKE2b-256 | 038fe11a1265bea957940c9228cc817d0f77562067d253d9e625ad8afe24ba3b |