Parse excel(xlsx/xls/csv) to other format(dict, csv, json, ...).
Project description
xlparser
Parse excel(xlsx/xls/csv) to other format(dict, csv, json, ...).
Warning: some old versiones of xls are not supported.
Install
pip install xlparser
pip3 install xlparser
Usage
$ xlparser
CLI Usage
Convert xlsx to csv
$ xlparser src.xlsx | tee test.csv
foo, bar
看,我,变
Convert csv to json
$ xlparser test.csv -json | tee test.json
[["foo", "bar"], ["看", "我", "变"]]
Module Usage
Parse any type of file
The parse
function supports the following file format:
def parse(src):
if src.endswith('.xls'):
return parseXls(src)
if src.endswith('.xlsx'):
return parseXlsx(src)
if src.endswith('.csv'):
return parseCsv(src)
parse
any type of file to rows:
>>> from xlparser import parse, saveCsv
>>> rows = parse('some.xlsx')
>>> list(rows)
[['foo', 'bar'], ['看', '我', '变']]
Save rows to csv
>>> saveCsv(rows, 'test.csv')
Csv operation
>>> from xlparser import *
>>> rows = [('foo','bar'), ('看','我','变')]
>>> saveCsv(rows, 'test.csv')
>>> list(parseCsv('test.csv'))
[['foo', 'bar'], ['看', '我', '变']]
Zip operation
>>> from xlparser import loadZip
>>> zf = loadZip('test.xlsx')
>>> print(zf.filelist)
......
>>> zf.extract('xl/media/image1.png', '/tmp')
>>> os.rename('/tmp/'+'xl/media/image1.png', './image1.png')
Required
- python>=3.5
- xlrd: required by xls
- openpyxl>=2.5.4: required by xlsx
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
xlparser-0.2.13.tar.gz
(4.1 kB
view hashes)
Built Distribution
Close
Hashes for xlparser-0.2.13-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7c78e6a259f719d23f438d7d990c4fc792d4c6f2dbb926abdbd2537bb27b3b3d |
|
MD5 | 1866c7738bb2ffc93262e88e47757c87 |
|
BLAKE2b-256 | 0a863920df8fd43656e91688a532f69c3ac260dada3f9eb5e7995c23b7cab2cb |