Skip to main content

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

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

Uploaded Source

Built Distribution

xlparser-0.2.12-py3-none-any.whl (4.6 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