python与excel交互-Python和Excel交互

Python和Excel交互

初级的例子：

def write_excel(info_list,colums,name,sheetname):

import xlsxwriter

workbook = xlsxwriter.Workbook(name)

worksheet = workbook.add_worksheet(sheetname)

info_length = len(info_list)

col_len = len(colums)

print info_length

for row in range(0, info_length):

row_value = info_list[row]

if isinstance(row_value, dict):

for col in range(0, col_len):

value = info_list[row][colums[col]]

worksheet.write(row, col, value)

else:

worksheet.write(row,0,row_value)

workbook.close()

调用的方法：

columns = ['port','cpname','dba','developer']

file_name = 'weibo_offline.xlsx'

sheet_name = 'weibo_offline'

write_excel(info_list, columns, file_name, sheet_name)