liehen2046的专栏

code# coding=utf-8import openpyxlfrom openpyxl import load_workbookfrom openpyxl.styles import Font, colorsdef write(file_name, sheet_name, title, rows): wb = openpyxl.Workbook() sheet = wb.create_sheet(index=0, title=sheet_name) sheet.

引入<!--poi对excel2007以上版本的支持--> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <ver...

# coding=utf-8import loggingimport xlrd # 读模块import xlwt # 写模块logging.basicConfig(level=logging.INFO, format='%(asctime)s - %(name)s - %(levelname)s - %(message)s')logger = logging.getLogger(__name__)def read_excel(excel_path, sheet_index=None,