python读写excel文件

 1 '''
 2 读取XLS,XLSX文件
 3 '''
 4 def readExcelFile(filename):
 5     # 打开工作表
 6     workbook = xlrd.open_workbook(filename=filename)
 7     # 用索引取第一个工作薄
 8     booksheet = workbook.sheet_by_index(0)
 9     # 返回的结果集
10     for i in range(booksheet.nrows):
11         print(booksheet.row_values(i))

import xlrd

'''
写XLS,XLSX文件
@filename 文件名
@header   列头
@content  内容
'''
def writeExcelFile(filename, header, content):
    # 因为输入都是Unicode字符，这里使用utf-8，免得来回转换
    workbook = xlwt.Workbook(encoding='utf-8')
    booksheet = workbook.add_sheet('Sheet 1', cell_overwrite_ok=True)

    # 写列头
    row = 0
    for col in range(len(header)):
        booksheet.write(row, col, header[col])

    # 写内容
    for lines in content:
        row += 1
        for col in range(len(lines)):
            booksheet.write(row, col, lines[col])

    # 保存文件
    workbook.save(filename)

import xlwt