openpyxl 操作excel_大数据苦行僧—yisurvey123的博客-CSDN博客

网站介绍:import openpyxl# 创建excel wb = openpyxl.Workbook() sheet = wb.active excel_head = ['表头','/内容'] sheet.append(excel_head) wb.save('info.xlsx')# 加载已有的excel company_wb = openpyxl.load_workbook('./Company.xlsx')# 获取某个sheet 进行操作 company_sheet = compa