PythonÓëMicrosoft Office×Ô¶¯»¯²Ù×÷
http://www.cnblogs.com/Jedimaster/archive/2007/02/28/660209.html
¡¡¡¡ÅóÓѵļÒÈË×öÉúÒ⣬ÿÈÕ´Ó¸÷µØ·Öµê´¦ÊÕ¼¯±¨±í£¬È»ºó»ØÈ¥»ã×Ü¡£ÓÉÓÚ²»ÏëÓÃÄÇÖÖ¸´ÔӵĹÜÀíÈí¼þ£¬¾Í½ÐËûдһ¸öС¹¤¾ß¡£ÓÚÊÇËûÕÒµ½ÁËÎÒ£¬ÈÃÎÒÏëÏë°ì·¨¡£
¡¡¡¡PythonÊǸöÁîÈ˾ªÆæµÄ¹¤¾ß£¬¶ø²»½ö½öÊÇÒ»ÖÖÓïÑÔ¡£¶Ô±ÈÀÏÅÆµÄPerl£¬¿´ËÆPython²»ÊÇÄÇôµÄ¾«Í¨ —— ¶Ô±ÈPerl³¬¿ìµÄÎı¾´¦ÀíËٶȺ͹㷺ӦÓÃÓÚCgi³ÌÐòµÄ±àдÀúÊ·£¬ÒÔ¼°Ä¿Ç°´óºì´ó×ϵÄRubyÔÚWeb¿ª·¢ÉϵIJ¡¶¾Ê½ÂûÑÓ£¬¶ø±ÈÆð¾²Ì¬ÓïÑÔ±ÈÈçC\C++£¬ÐéÄâ»úJavaºÍC#À´Ëµ£¬ËÙ¶ÈÓÖ³ÉÁËÎÊÌâ¡£µ«ÊÇPythonµÄʵÁ¦¿É²»ÈÝСÊÓ£¬NASA¶¼ÓÃPython¿É²»ÊÇ´µµÄ£¬¿öÇÒ£¬PythonµÄѧϰÄѶȱÈPerlС¶àÁË£¬¸ÕѧʱÈÃÎÒÕÒµ½ÁËÒÔǰQBASICµÄ¸Ð¾õ¡£
¡¡¡¡
¡¡¡¡´Ë³ÌÐò¾ßÌåÒªÇóÈçÏ£ºÃ¿ÈÕ²úÉú¸±±íÈô¸É£¨È縱±íÎļþ£©¡£³ÌÐòÏȺ˶Ը½±íµÄÈÕÆÚºÍÏúÊ۵㡣Èç¹ûÏúÊ۵㲻ͬÈÕÆÚÏàͬ£¬±ã°Ñ²»Í¬¸±±íµÄÏàͬ²úÆ·ºÅµÄ “ÏúÊÛÊýÁ¿”À¸Ïà¼Ó£¬ÌîÈë×ܱí“ÏúÊÛÊýÁ¿”À¸¡£½«¸±±íµÄ“×ÜÀûÈó”À¸Ïà¼ÓÌîÈë×ܱíµÄ“×ÜÀûÈó”À¸¡£ÆäËû¸±±íÐÅÏ¢¸´ÖƵ½×Ü±í£¨±¸×¢³ýÍâ,ÓÉÓû§×ÔÐд¦Àí£©¡£±íÍ·µÄÑùʽÈçÏ£º
¡¡¡¡°¡¹þ£¬ºÜ¼òµ¥µÄ±íÍ·¡£ÆäÖÐÐèÒª²Ù×÷µÄÊÇ“ÏúÊÛÊýÁ¿”ºÍ“×ÜÀûÈ󔣬Ҳ¾ÍÊǰÑÏàͬʱ¼äµÄ±¨±íÏà¼Ó¡£µ«ÊÇÕâÑùÓиöÑÏÖØÎÊÌ⣡
±ØÐëÒªÇó£¬Ïàͬ±¨±íµÄ²úÆ·Ãû³Æ¡¢»õºÅµÄ˳Ðò²»Äܳö´í£¬¸÷µØÒª¾ø¶Ôͳһ£¬·ñÔòÈ«²¿ÕâÑùÕÕÑù¿½±´¾Í»á³ö´í£¡
¡¡¡¡ÈÃÎÒÃÇ·ÖÎöÒ»ÏÂ˼·£ºÊ±¼äÊǹؼü¡£Ê±¼ä¾ö¶¨ÁËÄÄЩ±¨±íÐèÒª·ÖÃűðÀ࣬Éú³ÉÄÄÒ»ÌìµÄͳ¼Æ×Ü±í¡£Êý¾Ý½á¹¹ÉÏ£¬ÓÃÊ²Ã´ÄØ£¿¼òµ¥µÄlist£¿²»ÐУ¬ÎÒ³¢ÊÔ¹ý¡£Ó¦¸ÃʹÓÃmapÈÝÆ÷£¬°ÑÈÕÆÚ×÷Ϊkey£¬´¢´æµÄValueÊǸöÁÐ±í¡£³ÌÐòÏÈɨÃèËùÓеÄExcelÎļþ»ñÈ¡ÈÕÆÚ£¬È»ºó°ÑÏàͬÈÕÆÚ±¨±íµÄCOMÎĵµ½Ó¿Ú´¢´æÆðÀ´£¬ÊµÏÖÁË·ÖÃűðÀà¡£×îºó±éÀúÕâ¸ömapÈÝÆ÷£¬¼ÆË㣬Éú³ÉÿÈÕµÄͳ¼Æ×Ü±í¡£´úÂëÈçÏ£¬¾¹ý²âÊÔÕý³£¡£
1import os;
2import sys;
3import time;
4import datetime;
5#ÇëÏȰ²×°¶ÔÓ¦×ÅÄã×Ô¼ºµÄPython°æ±¾µÄPythonWin32
6import win32com.client;
7
8
9mapper = {};
10
11app = win32com.client.Dispatch("Excel.Application");
12PipeOut = os.popen("dir *.xls /B");
13FileList = PipeOut.readlines();
14PipeOut = os.popen("cd
Ïà¹ØÎĵµ£º
1. Building an Application with PyGTK and Glade
2. Creating a GUI using PyGTK and Glade
3. A Beginner's Guide to Using pyGTK and Glade
4. Is there a walkthrough on getting PyGTK2 and libglade2 to work on win32 ......
ÔÚWindowsÀï´î½¨PythonµÄGTK+»·¾³»¹ÊDZȽÏÂé·³µÄÓÐÒÔϼ¸¸ö×¢ÒâÊÂÏî
1¡¢PyGTKÍøÕ¾ÉÏϵİü£¬¿ÉÄÜûÓÐGladeÀࣨLib\site-packages\gtk-2.0\gtkĿ¼ÏÂûÓÐglade.pyd£©£¬Èç¹ûûÓÐÕâ¸öÀàÄã¾ÍÎÞ·¨ÔÚ³ÌÐòÀïµ¼ÈëGlade¹¤¾ß´´½¨µÄxml£¬ÊÖд½çÃæ»¹ÊÇͦÂé·³µÄ¡£
2¡¢GTKÍøÕ¾ÉϵÄGTK°ü£¬Ã»ÓаüÀ¨GladeµÄDLLÎļþ£¬»¹ÊÇÎÞ·¨¶ÁÈëGladeµÄxm ......
ÏÂÃæÊǶÔijÎļþ¼Ð϶à¸öÎļþÏÂÖ¸¶¨Îļþ»»Ãû×ÖµÄʵÀý£¨ÎªÁË»»Ãû×Ö£¬ÒòΪÀÁµÃÊÖ¶¯¸Ä£¬ÕÛÌÚÁËÒ»»á¸ã³öÀ´µÄ£©
ÔÀíºÜ¼òµ¥£¬»»ÎļþÃûµÄ»°Ö¸¶¨path¾ÍÐÐ £¬¾ßÌåµÄ×Ô¼º¿´°É£¬½ö¹©²Î¿¼£¡
#-*- coding:utf-8 -*-
import os,sys
#=======================================
##¶Ô¶à¸öÎļþ¼ÐϵÄÎļþ£¨¼Ð£©½øÐд¦Àí
#============ ......
http://cocobear.info/blog/2009/01/16/use-python-deal-with-excel/
ʹÓÃPython´¦ÀíExcel±í¸ñ 2009Äê01ÔÂ16ÈÕ
¸ø°³µÄbossдµÄÒ»¸öС¹¤¾ß£¬Ê¹ÓÃPython¶ÔExcel½øÐÐͳ¼Æ£¬È»ºó°Ñ½áÊøÉú³ÉÒ»¸öеÄExcel±í¸ñ£¬Ê¹Óõ½ÁËxlrdºÍpyExceleratorÁ½¸ö¿â¡£
¼òµ¥µÄ½éÉÜÒ»ÏÂÕâÁ½¸ö¿â£¬ÏÈ˵xlrd£¬Õâ¸ö¿â¶ÁExcel±È½Ï·½±ã£¬¸÷ÖÖ·½·¨Ê¹ÓÃÆ ......
1)Excel hyperlink:
xlsApp = win32com.client.Dispatch('Excel.Application')
cell = xls.App.ActiveSheet.Cells(1,1)
cell.Hyperlink.Add(cell,'http://xxx')
2)Excel row/column count:
sht = xlsApp.ActiveSheet
sht.Columns.Areas.Count
sht.Rows.Areas.Count
*************************
£Û1£ÝʹÓÃPyExcelera ......