simple-xls2json

Convert table data to json format output

Requirements

• xlrd

Installation

pip3 install simple-xls2json

Usage

from xls2json.xls2json import *

xls = Xls2Json()
xls.setConfig(
        Config().start(1).end(-1) # configure the startline & endline, -1 for end means all lines
        .values([(0, 'click_time'), (1, 'create_time')])    # configure which columns to be used, set the keys
        .value(2, 'pay_time')
        .value(3, 'balance_time')
        .value(5, 'item_id')
        .value(6, 'pic')
        .value(7, 'title')
        .value(11, 'price')
        )
xls.toJson('test.xls')

Output

{
    "code":0,
    "pageCount":1,
    "pages":[
        {
            "name":"Page1",
            "lines":[
                {
                    "click_time":"2020-06-16 23:28:11",
                    "create_time":"2020-06-17 00:24:02",
                    "pay_time":"2020-06-17 00:24:12",
                    "balance_time":"2020-07-07 21:54:53",
                    "item_id":"521537285175",
                    "pic":"//img.alicdn.com/tfscom/i4/2185500387/TB2Z2bvnSVmpuFjSZFFXXcZApXa_!!2185500387.jpg",
                    "title":"Bellroy澳洲进口Coin Fold折叠硬币信用卡片收纳包皮夹卡包男包邮",
                    "price":"528.00"
                },
                {
                    "click_time":"2020-06-16 23:28:11",
                    "create_time":"2020-06-17 00:24:02",
                    "pay_time":"2020-06-17 00:24:12",
                    "balance_time":"2020-07-07 21:54:53",
                    "item_id":"521537285175",
                    "pic":"//img.alicdn.com/tfscom/i4/2185500387/TB2Z2bvnSVmpuFjSZFFXXcZApXa_!!2185500387.jpg",
                    "title":"Bellroy澳洲进口Coin Fold折叠硬币信用卡片收纳包皮夹卡包男包邮",
                    "price":"528.00"
                },
                {
                    "click_time":"2020-06-16 23:28:11",
                    "create_time":"2020-06-17 00:24:02",
                    "pay_time":"2020-06-17 00:24:12",
                    "balance_time":"2020-07-07 21:54:53",
                    "item_id":"521537285175",
                    "pic":"//img.alicdn.com/tfscom/i4/2185500387/TB2Z2bvnSVmpuFjSZFFXXcZApXa_!!2185500387.jpg",
                    "title":"Bellroy澳洲进口Coin Fold折叠硬币信用卡片收纳包皮夹卡包男包邮",
                    "price":"528.00"
                },
                {
                    "click_time":"2020-06-16 23:28:11",
                    "create_time":"2020-06-17 00:24:02",
                    "pay_time":"2020-06-17 00:24:12",
                    "balance_time":"2020-07-07 21:54:53",
                    "item_id":"521537285175",
                    "pic":"//img.alicdn.com/tfscom/i4/2185500387/TB2Z2bvnSVmpuFjSZFFXXcZApXa_!!2185500387.jpg",
                    "title":"Bellroy澳洲进口Coin Fold折叠硬币信用卡片收纳包皮夹卡包男包邮",
                    "price":"528.00"
                }
            ]
        }
    ]
}