将表数据转换为json格式输出
simple-xls2json的Python项目详细描述
simple-xls2json
将表数据转换为json格式输出
要求
- xlrd公司
安装
pip3 install simple-xls2json
使用
^{pr2}$输出
{
"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"
}
]
}
]
}
- 项目
标签: