Python实现自定义顺序、排列写入数据到Excel的方法

data=a

import xlsxwriter

workbook = xlsxwriter.Workbook('F:/chart1.xlsx')

worksheet = workbook.add_worksheet('请求接口')

title = [u'订单号',u'债权编号',u'请求参数',u'创建时间',u'结果']

print data.iloc[:,0]

format=workbook.add_format()

format.set_border(1)

format_title=workbook.add_format()

format_title.set_border(1)

format_title.set_bg_color('#cccccc')

format_title.set_align('center')

format_title.set_bold()

format_ave=workbook.add_format()

format_ave.set_border(1)

format_ave.set_num_format('0.00')

worksheet.write_row('A1',title,format_title)

worksheet.write_column('A2:', data.iloc[:,0],format)

worksheet.write_column('B2', data.iloc[:,1],format)

worksheet.write_column('C2', data.iloc[:,2],format)

worksheet.write_column('D2', data.iloc[:,3],format)

worksheet.write_column('E2', data.iloc[:,4],format)

workbook.close()