#tablib.Dataset()操作exl类型数据之“类方法”研究import tablib#初始化data=tablib.Dataset()#设置列标题data.headers=('name','where')some_collector=[('xiaodeng','enshi'),('xiaoming','hubei'),('xiaodong','enshi')]#写入数据for key,value in some_collector:    data.append((key,value))#append方法里面是一个元组#新增一列数据data.append_col((90, 67,100), header='age')#查看所有的数据#print(data)"""name    |where|age--------|-----|---xiaodeng|enshi|90xiaoming|hubei|67xiaodong|enshi|100"""#抓取第一列数据，注意坐标是0，data.get_col(0)#print(data.get_col(0))#['xiaodeng', 'xiaoming', 'xiaodong']#对数据排序#sort(self, col, reverse=False)，返回一个复制的数据data#升序排列#col参数：表示第几列#print(data.sort(2, reverse=False))data=data.sort(2, reverse=False)"""name    |where|age--------|-----|---xiaoming|hubei|67xiaodeng|enshi|90xiaodong|enshi|100"""#删除最后一行数据data.pop()"""#toDictdata = tablib.Dataset()data.dict = [{'age': 90, 'first_name': 'Kenneth', 'last_name': 'Reitz'}]#toJsondata = tablib.Dataset()data.json = '[{"age": 90, "first_name": "John", "last_name": "Adams"}]'"""