python ²Ù×÷ms office Éú³É±¨¸æÏà¹Ø×ܽá
¹Ø¼ü×Ö: python com ±¨¸æ
http://appofis.javaeye.com/blog/417446
python ²Ù×÷ms office Éú³É±¨¸æÏà¹Ø×ܽá
I. ÏîÄ¿ÖÐÐèÒªÉú³ÉwordºÍexcel±¨¸æ£¬Í¨³£ÓÐÁ½ÖÖ·½·¨£º»ùÓÚ×Ö·û´®Æ´½ÓÒÔ¼°COMµ÷Óá£
1) ×Ö·û´®Æ´½ÓÉú³ÉofficeÎĵµµÄÔÀí£º officeÎĵµ±¾Éí¿ÉÒÔÌåÏÖΪxmlÎļþ¸ñʽ£¬ÓÈÆäÊÇMS Excel
2003£¬ÎÒÃÇ¿ÉÒÔ×Ô¼º½«Ò»¸öexcelÁí´æÎªxml¸ñʽ£¬ÓÃÎı¾±à¼Æ÷´ò¿ªËü——ºÜÈÝÒ׿´¶®¡£
Òò´ËÖ»Òª³ÌÐòÖа´ÕÕ¸ñʽÊä³öÕâÑùµÄxmlÎļþ£¬ÔÙ±£´æ³ÉofficeÎĵµ¼´¿É¡£Éú³É´óÁ¿¸ñʽ»¯×Ö·û´®ÓÐÒ»¸ö·Ç³£ÖØÒªµÄ¹¤¾ß¾ÍÊÇÄ£°åÒýÇæ
£¨±ÈÈçjsp¾ÍÊÇÕâÑùµÄ¶«Î÷£©£¬ÔÚÉú³ÉofficeÎĵµÊ±£¬javaÓïÑÔ³£ÓõÄÄ£°åÒýÇæ¾ÍÊÇvelocity£¬pythonÖÐÓкÍvelocity·Ç³£ÀàËÆµÄAirspeed£¬
»¹ÓÐһЩµÚÈý·½µÄCheetah£¬MakoµÈÄ£°åÒýÇæÏîÄ¿¡£ 2) COMµ÷ÓÃ
×Ö·û´®Æ´½ÓµÄºÃ´¦ÊÇËٶȿ죬µ«È±µã¾ÍÊDZØÐëÊÇÎĵµµÄÎı¾¸ñʽ±ØÐë¼òµ¥Ò×¶®£¬Óи´Ôӵĸñʽ¾ÍÎÞÄÜΪÁ¦ÁË£¬ÓÈÆäÊǶÔMS OfficeÕâ¸öËÆºõ²¢Ã»ÓÐÍêÈ«
¿ª·Å¸ñʽµÄ°ì¹«Èí¼þ¸üÂé·³¡£¶øCOMµ÷Óü¸ºõ¿ÉÒÔ×öÈκÎÊÂÇ飬ֻҪÈ˹¤²Ù×÷Office¿ÉÒÔÍê³ÉµÄ£¬Ëü¶¼¿ÉÒÔ×ö¡£ÌåÏÖÔÚÎÒÃÇÕâÀï¾ÍÊǶ¯Ì¬Éú³Éͼ£¬
µ÷Õû±í¸ñ¾ÓÖУ¬±íÍ·ÑÕÉ«µÈ£¬ÍùÍùÒ»¸öµ÷ÓþÍÍê³ÉÁË£¨µ«ËüÃÇÉú³ÉµÄÎĵµ¸ñʽÈÃÈË¿´µÃ½¹Í·Àö¡£JavaÖнøÐÐCOMµ÷ÓõĺÃÏñ¾ÍÊÇjacobÁË¡£
PythonÖÐʹÓÃwin32com¡£ÎÒ¾õµÃPythonÖеÄÕâ¸ö×é¼þ¸üºÃÓÃЩ£¬µÃÒæÓÚ¶¯Ì¬ÓïÑÔµÄÓÅÊÆ£¬ËüµÄ±äÁ¿ÀàÐͶ¼ÊǶ¯Ì¬¸³ÓèµÄ£¬
Òò´Ë¿ÉÒÔд³öµÄCOMµ÷ÓôúÂëºÍexcelºêÂ¼ÖÆµÄVB´úÂëºÜÏàËÆ£¬ºÜ¶àʱºòÄùýÀ´Ö±½ÓÓþÍÐС£¶øjavaµÄCOMµ÷ÓôúÂëµ½´¦ÊÇDispatch¡£
II.
ʹÓùýÒ»¸ö½Ðsnakelets(Éßòþ»¹ÊÇÓÐÔ¨Ô´µÄ)µÄµÚÈý·½Ä£°åÒýÇæ¡£Í¨³£ËûµÄºó׺ÃûÊÇy¡£yÎļþÖÐÓÃ<%%>À¨ÆðÀ´µÄÊÇpython´úÂ룬
ͨ¹ýÄÚÖ÷½·¨out.writeÊä³ö×Ö·û´®ºÍÉÏÏÂÎĵįÕͨ×Ö·û´®£¨literal text£©Æ´½Ó£¨¿´ÆðÀ´ºÍjspµÄÏë·¨ºÜÏàËÆ£©¡£
ÓɸÃyÎļþÉú³ÉµÄÒ»¸öÆÕͨµÄÎı¾Îļþ¾ÍÊÇÒ»¸ö·ûºÏexcel¸ñʽµÄxmlÎļþ£¬ÀïÍ·ÓÐÒ»¸öexcel±í¸ñ¡£
ÕâÑùÎÒÃǾÍÉú³ÉÒ»¸öexcel sheetµÄ³ûÐΣ¬¶à¸öyÎļþÉú³ÉµÄ´ú±íexcel
sheetµÄ×Ö·û´®ÔÙÆ´ÆðÀ´¾Í¿ÉÒÔ¹¹³ÉÒ»¸öÍêÕûµÄexcelÎļþ¡£È»ºó½øÐÐCOMµ÷Ó㬸øÕâ¸öÎļþ¼ÓÉÏÊ×Ò³£¬Êʵ±µ÷Õû³¬Á´½Ó——excel±¨¸æ¾ÍÕâôÉú³ÉÁË¡£
Word±¨¸æÒª¸´ÔÓÐí¶à£¬ÓÉÓÚexcel±í¸ñ±£´æµÄxmlÎļþ¸üÈÝÒ׿´¶®£¬¶øwordÖеÄͼ£¬Õ½ڵȽṹºÜ¸´ÔÓ£¬
ÔÚÉú³ÉwordÖбí¸ñµÄʱºò½èÖúÇ°ÃæÌáµ½µÄyÎļþÏÈÉú³Éexcel±í¸ñ£¨ÓÐÊÂʹÓøñí¸ñÔÙµ÷ÓÃCOM½Ó¿ÚÉú³ÉÍ
Ïà¹ØÎĵµ£º
def MergeSort(mylist, low, mid, high):
i = low
j = mid + 1
tmp = []
while i <= mid and j <= high:
if mylist[i] <= mylist[j]:
tmp.append(mylist[i])
i = i + 1
else:
tmp.append(mylist[j])
j = j + 1
......
ÎҵĻ·¾³ÊÇ£ºLinux version 2.4.21-4.EL
(bhcompile@daffy.perf.redhat.com) (gcc version 3.2.3 20030502 (Red Hat
Linux 3.2.3-20)) #1 Fri Oct 3 18:13:58 EDT 2003 + Python2.6.4
±¾ÎĽáºÏÎÒ°²×°Ê±ºòµÄÎÊÌ⣬×Ü½á¶ø³É
Óû§Ä¿Â¼Èç/home/liuguanyu/ , ±£Ö¤Óû§ÓÐrootȨÏÞ
1£¬¿´¿´ÓÐûÓа²×°
&nbs ......
1.PythonÖÐʱ¼äº¯ÊýÓм¸ÖÖ²»Í¬µÄ±íʾ·½·¨¡£Ò»ÖÖÊÇ»ùÓÚÊý×ֵıíʾ·½·¨£¬ÁíÍâÒ»ÖÖÊÇÓÃһϵÁÐÖµÀ´±íʾ£¬µÚÈýÖÖÊÇÓÃASCIIÂë×Ö·û´®µÄ¿É¶ÁÐÎʽÀ´±íʾµÄÔª×é¡£ time()º¯Êý·µ»ØµÄÊÇ´Óijһʱ¼äµãËãÆðµÄÃëÊý£¬¸ÃÊýÖµÊÇÒ»¸ö¸¡µãÊý¡£¸ù¾Ý²Ù×÷ϵͳµÄ²»Í¬£¬Õâ¸öʱ¼äµãÒ²²»Í¬¡£Í¨¹ýÇólocaltime(0)µÄÖµ¿ÉÒÔÕÒµ½ÏµÍ³µÄ¸Ãʱ¼äµã¡£ localtime ......