Python Openpyxl Excel打开操作 zipfile 错误解决：zipfile.BadZipFile: File is not a zip file

解决办法：不要使用xlwt模块创建表格，使用Openpyxl创建表格即可解决

方法如下：

from openpyxl import load_workbook, Workbook
import os

class A(object):

     def __init__(self):
        self.name = 'A_test.xlsx'
        self.logical_processing()

     def create_excel(self):
        # 创建excel
        wb = Workbook()
        wb.save(self.name)


     def write_excel(self):
        # 将字典写入excel
        wb = load_workbook(self.name)
        ws = wb['Sheet']
        ws.cell(1, 1, 'value')
        wb.save(self.name)
        wb.close()


     def logical_processing(self):
        # 逻辑判断
        if os.path.exists(self.name):
            # 不存在excel
            # 创建excel
            self.write_excel()
        else:
            # 存在excel
            # 直接进行写入操作
            self.create_excel()
            self.write_excel()

if __name__ == '__main__':
    A()