ModuleimportimportopenpyxlreadExcelfileopenExcelfileworkbook=openpyxl.load_workbook("test.xlsx")outputsheetname#输出工作簿中的所有sheet名称print(workbook.sheetnames)#遍历所有sheet并输出它们的名称forsheetinworkbook:print(sheet.title)创建表单newSheet=workbook.create_sheet("newSheetName")获取表单对象#根据表单名称获取表单sheet3sheet3=workbook.get_sheet_by_name("Sheet3")sheet4=workbook["newSheetName"]#getCurrentlyactiveformworksheet=workbook.active获取当前表单数据的行数和列数#获取当前表单数据的行数row_count=worksheet.max_row#获取当前表单数据的列数当前表单数据row_count=worksheet.max_column获取单元格对象selectcell=worksheet["A1"]selectcell=worksheet.cell(row=1,column=2)#行列号从1开始输出单元格信息行和单元格所在列print(selectcell.row,selectcell.column)单元格的坐标print(selectcell.coordinate)cellvalueprint(selectcell.value)获取列对象selectcol=worksheet["C"]获取列对象中的某个单元格selectcell=selectcol["2"]获取连续列组成的对象selectcols=worksheet["B:C"]获取所有列组成的对象allcol=worksheet.cols获取行对象selectrow=worksheet["2"]获取行对象中的某个单元格selectcell=selectcol["C"]获取由多个连续行组成的row对象对象selectcols=worksheet["1:4"]得到所有行组成的对象allrow=worksheet.rows获取由一定范围内的单元格组成的对象cell_range=worksheet["A1:C3"]遍历一定范围内的单元格forrow_rangeincell_range:#linefirstandcolumnforcellinrow_range:print(cell.value)Letterrepresentationandnumberconversionfromopenpyxl.utilsimportget_column_letter,column_index_from_stringprint(get_column_letter(2)))#2=>Bprint(column_index_from_string("C"))#C=>3编辑Excel文件创建工作簿对象workbook=openpyxl.Workbook()创建表单workbook.create_sheet(index=1,title="第二张")删除表单workbook.remove_sheet(workbook.get_sheet_by_name("Sheet3"))获取当前活动表单sheet=workbook.active修改表单名称sheet.title="设置sheet名称"修改单元格值sheet["A1"]="NewValue"批量写入数据方法一importopenpyxlfromopenpyxl.utilsimportget_column_letter,column_index_from_stringworkbook=openpyxl.Workbook()ws1=workbook.create_sheet("第一页")forrowinrange(40):ws1.append(range(17))方法二importopenpyxlfromopenpyxl.utilsimportget_column_letter,column_index_from_stringworkbook=openpyxl.Workbook()ws2=workbook.create_sheet("secondpage")rows=[[“编号”，“批次1”,"Batch2"],[2,40,30],[3,50,25],[4,30,30],[5,60,10]]forrowinrows:ws2.append(row)方法三importopenpyxlfromopenpyxl.utilsimportget_column_letter,column_index_from_stringworkbook=openpyxl.Workbook()ws3=workbook.create_sheet("thirdpage")forrowinrange(5,30):forcolinrange(15,24):ws3.cell(column=col,row=row,value=123)修改后保存到文件workbook.save("created.xlsx")如果你想学习更多编程和开发，和我一起成长进步，请关注我的公众号“松果仓库”，分享宅&程序员的各种资源，谢谢！！！
