pythonexcelword

‘壹’ 锅囨湡蹇呴’鎺屾彙镄勭紪绋嫔姙鍏搴

娌℃湁杩欎簺python缂栫▼锷炲叕搴撴嬁浠涔埚﹀ソ镊锷ㄥ寲!

Python Excel镊锷ㄥ寲搴

1.xl wings搴

鐗圭偣锛歺l wings鏄寮婧愪笖鍏嶈垂镄勶纴 棰勮呬简Anaconda鍜

Win Python锛 鍙鍦╓indows鍜宫acos涓婅繍琛屻

2.open pyx l搴

鐗圭偣锛歰pen pyx l鏄涓涓鐢ㄤ簬璇诲彇/缂栧啓Excel 2010

xls x/xls m/xl tx/xl tm鏂囦欢镄凯ython搴撱

3.xl rd搴

鐗圭偣锛氩湪python涓锛 xi rd搴撴槸涓涓寰埚父鐢ㄧ殑璇诲彇excel鏂囦欢镄

搴掳纴 鍏跺筫xcel鏂囦欢镄勮诲彇鍙浠ュ疄鐜版瘆杈幂簿缁嗙殑鎺у埗銆

4.xl wt搴

鐗圭偣锛氱被姣斾簬xi rd镄剅eader锛 闾ｄ箞xl wt灏辩浉瀵箇riter锛 钥屼笖寰

绾姝ｇ殑涓镣瑰氨鏄瀹冨彧鑳藉笶xcel杩涜屽啓镎崭綔銆

5.xl utils搴

鐗圭偣锛歺l utils(excel utilities) 鏄涓涓鎻愪緵浜呜稿氭搷浣滀慨鏀筫xcel

鏂囦欢鏂规硶镄勫簱銆倄l utils搴扑篃浠呬粎鏄阃氲繃澶嶅埗涓涓鍓链杩涜

镎崭綔钖庝缭瀛树竴涓鏂版枃浠讹纴 xl utils搴揿氨镀忔槸xi rd搴揿拰xl wt搴扑箣

闂寸殑涓搴фˉ姊侊纴 锲犳わ纴 xl utils搴撴槸渚濊禆浜巟i rd鍜寈l wt涓や釜搴撶殑銆

6.xls x writer搴

鐗圭偣锛歺ls x writer鏄鐢ㄤ簬鍒涘缓Excel XLS X鏂囦欢镄凯ython妯″潡锛 鍙鐢

浜庡皢鏂囨湰銆佹暟瀛椼佸叕寮忓拰瓒呴摼鎺ュ啓鍏Excel 2007+XLS X鏂囦欢涓镄

澶氢釜宸ヤ綔琛ㄣ

7.pandas搴

鐗圭偣锛歱andas鏄锘轰簬NumPy镄勪竴绉嶅伐鍏凤纴 璇ュ伐鍏锋槸涓轰简瑙ｅ喅鏁

鎹鍒嗘瀽浠诲姟钥屽垱寤虹殑銆

8.Mar mir搴

鐗圭偣锛歁ar mir閲囩敤Python鏁版嵁缁撴瀯骞跺皢鍏惰浆鎹涓虹数瀛愯〃镙笺傚畠鏄

绫诲浐阅囦笂镄刹l wt鍜宷 oogle鐢靛瓙琛ㄦ牸銆傜洰镙囨槸浣跨敤链灏戠殑閰岖疆杞

𨱒剧敓鎴愬氱岖被鍨嬬殑链夌敤琛ㄦ枃浠躲

Python Word镊锷ㄥ寲搴

1.python-doc x搴

鐗圭偣锛歱ython-doc x鏄涓涓鐢ㄤ簬鍒涘缓鍜屾洿鏂癕icrosoft

Word(doc x) 鏂囦欢镄凯ython搴揿揩阃熷紑濮嬨佸勭悊鏂囨。銆傚勭悊鏂囨湰銆

浣跨敤鎴闱銆佷娇鐢ㄩ〉鐪夊拰椤佃剼銆丄PI锘虹鐞嗐佽В镙峰纺銆佷娇鐢ㄦ牱寮忕悊

瑙ｅ浘鐗囧拰鍏朵粬褰㈢姸

2.t extract搴

鐗圭偣锛氩畠钖屾椂鍏奸【"doc"鍜"doc x"锛 浣嗗畨瑁呰繃绋嬮渶瑕佷竴浜涗緷璧栥

浣犲彲浠ユ壒閲忕殑鐢╬ython鐢熸垚word鏂囦欢锛 鎺ㄨ崘浣跨敤doc x锛 涓嶉渶瑕侊骏

浼氩お澶氥

Python PPT镊锷ㄥ寲搴

1.python-pp tx搴

鐗圭偣锛歱ython-pp tx鏄涓涓鐢ㄤ簬鍒涘缓鍜屾洿鏂癙owerPoint

(pp tx) 鏂囦欢镄凯ython搴撱傚吀鍨嬬敤阃旀槸浠庢暟鎹搴揿唴瀹圭敓鎴愯嚜瀹氢箟

PowerPoint婕旂ず鏂囩匡纴 鍙阃氲繃鍗曞嚮Web搴旂敤绋嫔簭涓镄勯摼鎺ヤ笅杞

Python闾浠惰嚜锷ㄥ寲搴

1.Dian go Celery SES搴

鐗圭偣锛氲繖涓鍖呮彁渚涗简涓涓狤mail Backend𨱒ュ埄鐢╠jango-

celery鍙戦佺数瀛愰偖浠躲傛偍鍙浠ュ皢Email Backend鎻掑叆鎭ㄧ殑椤圭洰涓

锛岃屾棤闇瀵逛唬镰佽繘琛屼换浣曚慨鏀广

2.Envelopes搴

鐗圭偣锛欵nvelopes鏄疨ython镄勭数瀛愰偖浠跺拰smtp lib妯″潡镄勫寘瑁呭櫒銆

瀹冩棬鍦ㄤ娇鍦≒ython涓澶勭悊澶栧彂鐢靛瓙闾浠跺彉寰楃亩鍗曡屾湁瓒ｃ

3.Flanker搴

鐗圭偣锛氱敱mail qun寮婧愮殑Flanker-emailaddress and

MIME parsing for Python鏄涓涓瑙ｆ瀽楂樻晥銆佸归敊鐜囦笉阌欑殑

python绗涓夋柟镓╁𪾢搴撱

4.im box搴

鐗圭偣锛氱敤浜庤诲彇IMAP闾绠卞苟灏嗙数瀛愰偖浠跺唴瀹硅浆鎹涓烘満鍣ㄥ彲璇

鏁版嵁镄凯ython搴

5.inbox.py搴

鐗圭偣锛氲繖鏄鎭ㄨ佽繃镄勬渶绠鍗旷殑SMTP链嶅姟鍣ㄣ傚畠鏄寮傛ョ殑銆备竴涓瀹

渚嬫疮绉掑簲璇ュ勭悊涓鍗冨氩皝鐢靛瓙闾浠

Python ODF镊锷ㄥ寲搴

1.Relato rio搴

鐗圭偣锛歊elato rio鏄涓涓妯℃澘搴掳纴 瀹冩彁渚涗简涓绉嶈交𨱒捐緭鍑哄氱嶆枃浠

(odt銆乷ds銆乸ng銆乻vg绛) 镄勬柟娉曘傞氲繃涓哄畠浠鍒涘缓鎻掍欢鍙浠ヨ交

𨱒炬坊锷犲规洿澶氭枃浠剁被鍨嬬殑鏀鎸併

Python PDF镊锷ㄥ寲搴

1.Py PDF 2搴

鐗圭偣锛歅y PDF 2鏄涓涓绾疨ython PDF搴掳纴 鑳藉熸媶鍒嗐佸悎骞躲佽佸壀

鍜岃浆鎹PDF鏂囦欢镄勯〉闱銆傚畠杩桦彲浠ュ悜PDF鏂囦欢娣诲姞镊瀹氢箟鏁版嵁銆

镆ョ湅阃夐”鍜屽瘑镰併

2.ReportLab搴

鐗圭偣锛歊eportLab鏄涔呯粡钥冮獙銆佽秴寮哄ぇ镄勫紑婧愬紩镎庯纴 鐢ㄤ簬鍒涘缓澶

𨱒傜殑銆佹暟鎹椹卞姩镄凯DF鏂囨。鍜岃嚜瀹氢箟鐭㈤噺锲惧舰銆傚畠鏄鍏嶈垂镄勚佸紑

婧愮殑锛 骞朵笖鏄鐢≒ython缂栧啓镄勚

3.PDF miner搴

鐗圭偣锛歅DF Miner鏄涓娆剧敤浜嶱DF鏂囨。镄勬枃链鎻愬彇宸ュ叿銆

Python寰淇¤嚜锷ㄥ寲搴

1.Python wxp y搴

鐗圭偣锛氩井淇℃満鍣ㄤ汉/鍙鑳芥槸链浼橀泤镄勫井淇′釜浜哄彿API锛 wxp y鍦╥t chat

镄勫熀纭涓婏纴阃氲繃澶ч噺鎺ュ彛浼桦寲鎻愬崌浜嗘ā鍧楃殑鏄撶敤镐э纴骞惰繘琛屼赴瀵

镄勫姛鑳芥墿灞曘

Python鏂囦欢澶勭悊镊锷ㄥ寲搴

1.os搴

鐗圭偣锛氭湰妯″潡鎻愪緵浜嗕竴绉崭娇鐢ㄤ笌镎崭綔绯荤粺鐩稿叧镄勫姛鑳戒究鎹峰纺阃斿缎

Python缁煎悎锷熻兘镊锷ㄥ寲搴

1.win32com搴

鐗圭偣锛归in32com妯″潡涓昏佷负Python鎻愪緵璋幂敤windows搴曞眰缁勪欢

瀵箇ord銆丒xcel銆丳PT绛夎繘琛屾搷浣灭殑锷熻兘锛 鍙鑳藉湪Windows鐜澧

涓嬩娇鐢锛 骞朵笖闇瑕佸畨瑁卭ffice鐩稿叧杞浠舵墠琛(WPS涔熻) 銆

2.u noconv搴

鐗圭偣锛氭槸涓涓锻戒护琛屽伐鍏凤纴 鍙浠ュ皢Libre Office鍙浠ュ煎叆镄勪换浣曟枃

妗ｆ牸寮忚浆鎹涓篖ibre Office鍙浠ュ煎嚭镄勪换浣曟枃妗ｆ牸寮忋傚畠鍒╃敤

Libre Office镄刄NO缁戝畾杩涜屾枃妗ｇ殑闱炰氦浜掑纺杞鎹锛 涔熸敮鎸

OpenOffice.

‘贰’ Python随机抽取excel数据，并输出到txt或者word上

写了一个，可以参考：