python鎵归噺淇敼excel鏃╀笂绐佺劧鎺ュ埌灏忓濮愮殑姹傚姪锛屽浣曚娇鐢ㄧ▼搴忔壒閲忓垹闄xcel涓殑鍥剧墖锛屼綔涓轰竴涓墠绔嫍锛屽績璺冲姞閫燂紝鍚庢墍鏈夛紝杩欎笉鏄垜鐨勪笓闀裤€傚皬濮愬璇磒ython搴旇鍙互鍚э紝璧剁揣google涓€涓嬪惂銆傚涔爌ython浠庡叆闂ㄥ埌鏀惧純宸茬粡2骞村浜嗐€傛垜寰堝揩鍒椾簡涓€涓棶棰樻竻鍗曪紝闂娓呭崟鍜屽悗鏉ユ壘鍒扮殑瑙ｅ喅鍔炴硶銆傚崟涓猠xcel鏂囦欢**Read#浣跨敤xlrd璇诲彇excel鏂囦欢'/'+name)**Geteachworksheet#鑾峰彇褰撳墠鏂囦欢鐨勫伐浣滆〃(sheet)listsheetList=wb.sheets()...forsheetinsheetList:...**淇敼worksheet#淇敼worksheet鎴戠敤鐨勬槸xlutils锛屼笉杩囦綘涔熷彲浠ョ敤xlwt锛?鎴戞病鐢紝鍘熷洜锛氭暟鎹笂鐢╠emo锛宒emo灏辩敤杩欎釜锛岃櫧鐒禿emo涓嶈閫氳繃fromxlutils.copyimportcopy...wb=open_workbook(path+'/'+name)...#澶嶅埗鍘熸枃浠讹紝鍥犱负鍘熸枃浠跺彧鑳借鍙栵紝涓嶈兘鍐欏叆鏁版嵁锛屾墍浠ラ渶瑕佸鍒跺緱鍒颁竴涓彲浠ュ啓鍏ユ暟鎹殑鏂囦欢newwb=copy(wb)...forrowinsheet.get_rows():#閬嶅巻姣忎竴琛岋紝褰撶8鍒楃殑鍊煎皬浜?2鏃讹紝灏嗗€兼敼涓?ifrow[0].value<12:newsheet.write(index,0,0)...**灏唀xcel鏂囦欢淇濆瓨鍦╪ewwb.save('./data/'+name)鏂囦欢涓?*鑾峰彇鏂囦欢鍒楄〃importosos.listdir(path)濂戒簡锛屽嚱鏁板涓嬶細鎵€鏈変唬鐮佸涓嬶細#-*-coding:utf-8-*-fromxlrdimportopen_workbookfromxlutils.copyimportcopyimportosdefeditExl(path,name):ifos.path.exists('/data'):os.removedirs("/data")#鏀惧湪鎷彿涓鍙栨枃浠剁殑缁濆璺緞锛岀浉瀵硅矾寰勪篃鍙互#os.getcwd()杩斿洖褰撳墠.py鏂囦欢鎵€鍦ㄧ殑缁濆璺緞#print(os.getcwd(),'lujing')wb=open_workbook(path+'/'+name)#璇诲彇鏂囦欢鐨勭涓€涓猻heet#sheet=wb.sheet_by_index(0)#鑾峰彇sheet鐨勮鏁?s=sheet.nrows#鑾峰彇褰撳墠鏂囦欢鐨勫伐浣滆〃锛坰heet锛夊垪琛╯heetList=wb.sheets()#print('sheetList',sheetList)#澶嶅埗鍘熸枃浠讹紝鍥犱负鍘熸枃浠跺彧鑳借涓嶈兘鍐欐暟鎹紝鎵€浠opy寰楀埌涓€涓彲浠ュ啓鏁版嵁鐨勬枃浠秐ewwb=copy(wb)sheetIndex=0forsheetinsheetList:#鑾峰彇鍙啓鏂囦欢鐨勭涓€绉嶅舰寮弉ewsheet=newwb.get_sheet(sheetIndex)#print(newsheet,newsheet.get_rows())index=0try:forrowinsheet.get_rows():#閬嶅巻姣忎竴琛岋紝褰?columns褰撳€煎皬浜?2鏃讹紝灏嗗€兼敼涓?#print(row)#print(row[0].value,'000000000000000')ifrow[0].value<12:#print('here',index)newsheet.write(index,0,0)#print('afterhere')index=index+1except:print("aaa")sheetIndex=sheetIndex+1mkdir('./data')newwb.save('./data/'+name)defmkdir(path):folder=os.path.exists(path)濡傛灉涓嶆槸鏂囦欢澶癸細os.makedirs(path)print('---foldermk---')else:print('---folderexists---')defgetFileList(path):returnos.listdir(path)defeditAll():originPath='./origin'fileList=getFileList(originPath)#print(fileList)forfileIteminfileList:editExl(originPath,fileItem)editAll()缂洪櫡锛氬彧鑳芥槸鍗曞厓鏍肩殑鍐呭淇敼鍚庯紝鏃犳硶璇诲彇鍥剧墖銆備慨鏀瑰悗锛岃〃鏍间腑鐨勫浘鐗囦涪澶变簡锛屼笉杩囧樊涓嶅婊¤冻浜嗗皬濮愬鐨勯渶姹傘€傛湁鏃堕棿鎴戜細璁╁皬寮熻繃鏉ヤ紭鍖栦竴涓嬨€傛搷浣滄柟娉曞皢闇€瑕佷慨鏀圭殑鏂囦欢鏀惧叆origin鏂囦欢澶广€傚鏋滀笉鐢ㄦ墜鍔ㄥ垱寤哄畨瑁卲ython锛岀湅杩囨垜鏂囩珷鐨勫簲璇ラ兘鏄ぇ浣簡锛屽氨涓嶇敤璐翠簡銆備篃鍙互鐪嬫垜鐨刾ython瀛︿範涓撴爮鍏朵粬鏂囩珷鍙彁鍒颁簡涓€鐐癸紝濡傛灉鏄痺indows锛屽畨瑁呭畬鎴愬悗锛屽鏋滃湪cmd涓嬭繍琛宲ython鎻愮ずpython涓嶆槸鍐呴儴鍛戒护XXXXXXX锛岀劧鍚庢壘鍒皃ython鐨勫畨瑁呯洰褰曞拰灏嗗叾娣诲姞鍒扮幆澧冨彉閲忎腑锛堜互鍙妏ip鐨勭洰褰曪級涓句釜渚嬪瓙鍚с€侾ython瀹夎鐩綍锛欴:\software\Python27pip瀹夎鐩綍锛欴:\software\Python27\Scripts鐐瑰嚮纭畾->閲嶅惎cmd->cdexcel_opt.py鎵€鍦ㄦ枃浠跺す鐪熷疄杩囩▼铏界劧鏂囩珷鏄繖鏍峰啓鐨勶紝浣嗘槸瀹為檯鐨勭紪绋嬭繃绋嬫槸杩欐牱鐨勩€傝鍙杄xcel鏂囦欢锛屼慨鏀圭涓€涓伐浣滆〃鏁版嵁锛屼繚瀛榚xcel鏂囦欢锛岃鍙栨枃浠跺す涓嬫墍鏈塭xcel鏂囦欢锛岄亶鍘嗘瘡涓猠xcel涓嬬殑姣忎釜宸ヤ綔琛紝淇敼锛屽暟鍡︾殑鏃堕棿銆傛暣涓繃绋嬪疄闄呬笂骞朵笉闇€瑕佸緢澶氭椂闂达紝鑳藉瀹炵幇鍩烘湰鐨勫姛鑳斤紝鍜屾垜浠庡叆闂ㄥ埌鏀惧純鏈夌潃蹇呯劧鐨勮仈绯伙紝铏界劧鎴戝綋鏃跺苟娌℃湁杩涢棬銆傛劅瑙夊瀛︾偣涓滆タ杩樻槸鏈夌敤鐨勶紝璇翠笉瀹氬摢澶╂湁鐢ㄣ€傘€愭墜鍔煒€銆戜笉鐭ラ亾鑳戒笉鑳芥弧瓒冲皬濮愬浠殑闇€姹傦紝涓嶈繃浠婂ぉ瀹炲湪鏄病鏃堕棿浼樺寲锛屾瘯绔熻繕鍦ㄥ伐浣滃拰鍏诲▋涓€傚厛璁板綍涓€涓嬶紝鎴戜細鎶界┖鐮旂┒琛ュ厖涓婇潰鐨勪竴浜涚煡璇嗙偣銆?/p>
