场景需求:
有一张excel表,表名为test.xlsx。格式如下
nam | age |
---|---|
jhon | 18 |
hack | 19 |
james |
希望读成对应的json对象:
[{u’age’: 18.0, u’name’: u’john’}, {u’age’: 19.0, u’name’: u’hack’}, {u’age’: u”, u’name’: u’james’}]
#!/usr/bin/env ython
# encoding:utf-8
from xlrd import open_workbook
from itertools import izip_longest
def main():
xlsfilename = 'test.xl