yanjs11的博客

原创 openpyxl使用

一、用openpyxl包操作Excel文件1.1 引用包import openpyxl1.2 读取当前已存在的excelfrom openpyxl import load_workbookwb = load_workbook(filename)# filename “.xlsx”格式1.3 读取未存在的excelfrom openpyxl.workbook import Workbookwb = Workbook() # 创建excelwb.save(filename)