weixin_48737462的博客

批量提取(Word->Excel)会议通知书关键信息源代码：from docx import Documentfrom openpyxl import Workbookimport globpath = r'E:\0616\untitled\wxhs\Batch processing\会议通知'workbook = Workbook()sheet = workbook.activeheader = ['序号','时间','地点','参加人员','内容']sheet.append(h

python办公自动化之Excel的读写(xlrd、xlwt)Excel读取数据——xlrd1.导包pip install xlrdimport xlrd2.打开一个工作簿xlsx = xlrd.open_workbook('XXX.xls')3.打开某张工作表通过sheet名sheet = xlsx.sheet_by_name('XXX')通过sheet索引下标查找sheet = xlsx.sheet_by_index(0)#下标从0开始4.获取单元格数据p