本文主要介绍python3.7openpyxl删除指定列或行。文章通过代码介绍了python3openpyxl的基本操作。代码简单易懂。需要的朋友可以参考python3.7openpyxl删除指定列或行#编码：utf-8importpandasaspdimportopenpyxlxl=pd.read_excel(r"E:\55\CRM业务分析表-10001741-1570416265044.xls")xl.to_excel(r"E:\55\crms.xlsx")wk=openpyxl.load_workbook(r"E:\55\crms.xlsx")#加载已有的excelwk_name=wk.sheetnameswk_sheet=wk[wk_name[0]]wk_sheet.cell(2,2,value='大面积')wk_sheet.cell(2,3,value='社区')wk_sheet.cell(2,4,value='店铺代码')wk_sheet.cell(2,5,value='storename')"""以上都是看代码，不懂的可以看我之前的博文，以下是国外的正文内容exchangeMT4教程http://www.kaifx.cn/mt4.html"""wk_sheet.delete_rows(3,2)#删除从??第一行开始的2行的内容wk_sheet.delete_cols(1,2)#删除从第一列开始的2列内容wk.save(r"E:\55\s.xlsx")知识点扩展：python3的基本操作ofopenpyxl，具体代码如下：coding:utf-8importxlrdimportxlwt#readandwrite2007excelimportopenpyxlimportsysreaddevicesn#defreadSN(path):#wb=openpyxl.load_workbook(path)#sheet=wb.active#dict=[]#foriinrange(2,sheet.max_row+1):#c=sheet["C"+str(i)].value;#d=工作表["D"+str(i)].value;#dict.append(d)##dict.append(d)##print(c,d)#returndict;#pass;#print(readSN("./sim/1.xlsx"))defread07Excel(path,path1):wb=openpyxl.load_workbook(path)sheet=wb.active#print(sheet.max_column)#获取最大列数#print(sheet.max_row)#获取最大行数print(sheet['B1'].value)wb1=openpyxl.load_workbook(path1)sheet1=wb1.activeforiinrange(2,sheet.max_row):iccid=sheet["B"+str(i)].value;len_iccid=len(iccid)iflen_iccid==20:sub_iccid=iccid[16:-1]eliflen_iccid==21:sub_iccid=iccid[17:-1]forxinrange(1,sheet1.max_row):print(sheet1["D"+str(x)].value)ifsub_iccid+"N"==sheet1["D"+str(x)].value:sheet["O"+str(i)].value=sheet1["C"+str(x)].value;wb.save(filename=path)print(str(sheet1["D"+str(x)].value)+""+str(sheet1["C"+str(x)].value)+""+str(iccid))print()pass#写入数据#s=sheet["P"+str(i)].value="dsdaf";#wb.保存（文件名=路径）#p=sheet["P"+str(i)].value;print(sub_iccid)#forrowinsheet.rows:#forcellinrow:#print(cell.value,"\t",end="")#print(cell.column,"\t",end="")#print()#sys.exit()#path="./sim/2.xlsx"#wb=openpyxl.load_workbook(path)##sheet=wb.sheetnames[0]#getname#sheet=wb.active#returnprint(sheet['A1'].value)#getcellA1Valueread07Excel("./sim/2.xlsx","./sim/1.xlsx")#wb=openpyxl.load_workbook('./sim/1.xlsx')#打开excel文件#print(wb.sheetnames)#获取工作簿中的所有工作表名称
