xlsxwriter 试炼（python模块）

案例测试1：

import xlsxwriter
workbook = xlsxwriter.Workbook('data1.xlsx')
worksheet = workbook.add_worksheet('南湖渔歌Python')
# worksheet.set_column(0,1,50) # 设置第一列的列宽
bold = workbook.add_format({'border': True, 'bold': True,'bg_color':'yellow','font_size': 12})
#写入数据以元组套列表形式
data = (
    ['春天',20],
    ['夏天',30],
    ['秋天',25],
    ['冬天',10],
)
#设置初始的输入数据的位置
row = 1
col = 0

#for循环添加数据
for weather, tem in (data):
    worksheet.write_row(0,0,['字段1','字段2'],bold) # write_row 使用write code发生报错
    worksheet.write(row, col,weather)
    worksheet.write(row, col + 1, tem)
    row += 1
workbook.close()

案例测试2：

import xlsxwriter
workbook = xlsxwriter.Workbook('data2.xlsx')
worksheet = workbook.add_worksheet('南湖渔歌Python')
# worksheet.set_column(0,1,50) # 设置第一列的列宽
bold = workbook.add_format({'border': True, 'bold': True,'bg_color':'yellow','font_size': 12,'align':'center'})
border = workbook.add_format({'border':True,'align':'center'}) # 设置边框

data = [
    [3, 6, 9, 12, 15],
    [2, 4, 6, 8, 10],
    [1, 2, 3, 4, 5],
]

# worksheet.write_row('A1',[3, 6, 9, 12, 15],bold)

col = 0
for i in range(len(data)):
    worksheet.write_row(0,0,['字段1','字段2','字段3'],bold) # write_row 使用write code发生报错
    worksheet.write_column(1,col,data[i],border)
    col+=1
workbook.close()