python 读写xlsx demo

1、读xlsx

#读activity.xlsx表
import xlrd
def read_activity_xls_file(src_activity):
    dataset = []
    workbook = xlrd.open_workbook(src_activity)
    table = workbook.sheets()[0]
    print(table.nrows)
    for row in range(table.nrows-1):
    dataset.append(table.row_values(row+1))   #dataset：[[],[]...]
    # print(dataset[0:2])  
    data = DataFrame(dataset)

2、写xlsx

import xlwt
def write():
    # 设置单元格样式，生成style
    style = xlwt.XFStyle()
    font = xlwt.Font()
    font.name = "Times New Roman"
    font.bold = False
    font.colour_index = 4
    font.height = 220
    style.font = font 
   
    #写入xlsx
    wd = xlwt.Workbook()                                   #表示一个表格空间   
    sheet = wd.add_sheet('activity',cell_overwrite_ok=True)     #添加一个            sheet..cell_overwrite_ok=True表示内容可覆盖
    row0 = ['activity']                #列名
    for i in range(0,len(row0)):
        sheet.write(0,i,row0[i])       #write(行，列，value，style)
    for i in range(1,len(list)+1):     #list = [['物品体力'], ['物品钻石']...]
        for j in list[i-1]:
            sheet.write(i,0,j)
    #以上三行的另一种表达
    #i = 1
    #for j in list:
    #   sheet.write(i,0,j[0])
    #   i += 1
    wd.save('test2.xlsx')

存表之后的结果: