Skip to main content

Parse excel(xlsx/xls/csv) to other format(csv, xlsx, json).

Project description

xlparser

Parse excel(xlsx/xls/csv) to other format(csv, xlsx, json).

Install

pip install xlparser
# or
pip3 install xlparser

If you want to filter fields, it will be convenient with xcut.

pip install xcut 
# or
pip3 install xcut 

Usage

$ xlparser -h
xlparser [options] INFILE [OUTFILE]\n
    options:\n
        -h       For help.\n

CLI Usage

From xlsx to csv.

$ xlparser source.xlsx new.csv 

From csv to xlsx.

$ xlparser source.csv new.xlsx 

From csv to json.

$ xlparser source.csv new.json

From xlsx to csv(stdout).

$ xlparser source.xlsx | head 

$ xlparser src.xlsx | tee test.csv
name, score
"李雷,韩梅",15
小花,16

Use xcut to filter fields.

$ xlparser src.xlsx | xcut --from-csv -f name 
name
"李雷,韩梅"
小花

$ xlparser src.xlsx | xcut --from-csv -f score,name
score,name
15,"李雷,韩梅"
16,小花

Convert xlsx to csv

$ xlparser src.xlsx test.csv; 
$ cat test.csv
name, age
李雷,15
小花,16

Convert csv to json

$ xlparser test.csv test.json
[["name", "age"], ["李雷", "15"], ["小花", "16"]]

Module Usage

Parse any type of file

parse any type of file to rows:

>>> from xlparser import parse, saveCsv
>>> rows = parse('some.xlsx')
>>> list(rows)
[['foo', 'bar'], ['看', '我', '变']]

The parse function supports the following file formats: .csv, .xls, .xlsx .

Save to any type of file

Save rows to csv

>>> from xlparser import saveCsv
>>> rows = [['foo', 'bar'], ['看', '我', '变']]
>>> saveCsv(rows, 'test.csv')

Save rows to xlsx

>>> saveXlsx(rows, 'test.xlsx')

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

  1. python>=3.5
  2. xlrd: required by xls
  3. openpyxl>=2.5.4: required by xlsx

Project details


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.6.1.tar.gz (6.4 kB view hashes)

Uploaded Source

Built Distribution

xlparser-0.6.1-py3-none-any.whl (7.7 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page