摘要：需要用到openpyxl这跟模块安装easy_install openpyxl使用方法from openpyxl.workbook import Workbookfrom openpyxl.writer.excel import ExcelWriterfrom openpyxl.cell import get_column_letterfrom openpyxl.style import Color, Fillfrom openpyxl.cell import Cell#新建一个workbookwb = Workbook()#第一个sheet是wsws = wb.worksheets[0]#设 阅读全文