In [5]:
!pip install tablib
In [18]:
import tablib
data = tablib.Dataset(headers=[u'LOL选手', u'位置', u'KDA'], title=u"LOL主播信息")
data.append((u'Dopa', u'中单', 9.9))
data.append_separator(u'--------------分割线----------------')
data.append((u'炸姐', u'ADC', 8.8))
with open("excel/single_sheet.xls", "wb") as f:
f.write(data.xls)
In [19]:
import tablib
data = tablib.Dataset().load(open('excel/single_sheet.xls', "rb").read(), "xls")
print (data.headers) # 表头,也就是第一行
print (data[u'KDA']) # KDA这一列数据
for row in data: # 遍历除头以外的行
print(row)
In [20]:
import tablib
data1 = tablib.Dataset(headers=[u'主播', u'擅长英雄', u'KDA'], title=u"虎牙主播信息")
data1.append((u'Dopa', u'卡萨丁', 666))
data1.append_separator(u'--------------分割线----------------')
data1.append((u'骚男', u'男刀', 555))
data2 = tablib.Dataset(headers=[u'主播', u'擅长英雄', u'KDA'], title=u"斗鱼主播信息")
data2.append((u'55开', u'卡牌',333))
data2.append_separator(u'--------------分割线----------------')
data2.append((u'小智', u'剑圣',111))
book = tablib.Databook((data1, data2))
with open("excel/multi_sheet.xls", "wb") as f:
f.write(book.xls)
In [28]:
import tablib
datas = tablib.Databook().load("xls", open('excel/multi_sheet.xls', "rb").read())
print (len(datas.sheets())) # sheet个数
data = datas.sheets()[1] # 选取第二个sheet
print (data.headers) # 表头,也就是第一行
print (data[u'主播']) # 主播这一列数据
for row in data: # 遍历除头以外的行
print (row)