python 操作Excel表格

创建Excel表格

import xlwt
import os


def create_excel(filepath, sheetname):
    # 创建excel文件
    workbook = xlwt.Workbook()

    sheet = workbook.add_sheet(sheetname)

    caption_list = ['姓名', '简介', '公司']

    for caption in caption_list:
        sheet.write(0, caption_list.index(caption), caption)

    workbook.save(filepath)


if __name__ == '__main__':
    filepath = os.path.dirname(os.path.abspath(__file__)) + "/file_py/shanghai_intro.xls"
    sheetname = "上海市简介"
    create_excel(filepath, sheetname)

写入Excel表格

import xlrd
from xlutils.copy import copy
import os


class WriteToExcel():
    def __init__(self, filepath, sheetname):
        self.filepath = filepath
        rb = xlrd.open_workbook(self.filepath)

        # sheets = rb.sheet_names()
        worksheet = rb.sheet_by_name(sheetname)

        rows_old = worksheet.nrows
        self.wb = copy(rb)

        self.ws = self.wb.get_sheet(0)
        self.nums_row = rows_old
        print(self.nums_row)

    def write_to_excel(self, line, value):
        self.ws.write(self.nums_row, line, value)
        self.wb.save(self.filepath)


if __name__ == '__main__':
    filepath = os.path.dirname(os.path.abspath(__file__)) + '/file_py/shanghai_intro.xls'
    sheetname = "上海市简介"
    w = WriteToExcel(filepath, sheetname)