Metadata-Version: 2.1
Name: xlparser
Version: 0.2.1
Summary: Parse excel(xlsx/xls) to other format(dict, csv, json, ...).
Requires-Dist: xlrd
Requires-Dist: openpyxl (>=2.5.4)

Home-page: http://github.com/ahuigo/xlparser
Author: ahuigo
Author-email: ahui132@qq.com
License: MIT
Description: # xlparser
        Parse excel(xlsx/xls) to other format(dict, csv, json, ...).
        
        ## Install
        
            pip install xlparser
            pip3 install xlparser
        
        ## Usage
        
        ### CLI Usage
        
            $ xlparser.py src.xlsx -csv
            [['asdf', 'bbb'], ['看', '我', '变']]
        
            $ xlparser.py src.xlsx -json
            [['asdf', 'bbb'], ['看', '我', '变']]
        
        ### Module Usage
        
        ### parse
        The `parse` function support 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)
        
        The `parse` will automatically parse any file to `rows` generator:
        
            >>> from xlparser import parse, saveCsv
            >>> rows = parse('some.xlsx')
            >>> list(rows)
            [['asdf', 'bbb'], ['看', '我', '变']]
        
        ### Csv operation
        
            >>> from xlparser import *
        
            >>> rows = [('asdf','bbb'), ('看','我','变')]
            >>> saveCsv(rows, 'test.csv')
        
            >>> list(parseCsv('test.csv'))
            [['asdf', 'bbb'], ['看', '我', '变']]
        
            toCsv(rows, 'to.csv')
        
        ## Required
        1. python>=3.5
        2. xlrd: required by xls
        2. openpyxl>=2.5.4: required by xlsx
        
Platform: UNKNOWN
Requires-Python: >=3.6.1
Description-Content-Type: text/markdown
