Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

python²Ù×÷excel


¼ÈȻѡÔñÁËÔ¶·½£¬¾Í±ØÐëÈÕÒ¹¼æ³Ì http://wrsuifeng.javaeye.com
Python´úÂë
# Filename: excel.py   
import os,sys,time   
import win32com.client   
import traceback   
  
excel = win32com.client.Dispatch("Excel.Application")   
filename = "D:\\test.xls"  
  
try:   
    d1 = excel.Workbooks.Add()   
    sheet = d1.Sheets(1)   
       
    for i in xrange(1,10):   
        for j in xrange(1,10):   
            sheet.Cells(i,j).Value = str(i*j)   
    d1.SaveAs(filename)   
except Exception, e:   
    print traceback.print_exc()   
    print e   
       
excel.Quit()  


Ïà¹ØÎĵµ£º

python¶¯Ì¬µ¼ÈëÄ£¿é¡¢¼ì²éÄ£¿éÊÇ·ñ°²×°

²Î¿¼Á´½Ó£ºhttp://www.woodpecker.org.cn/diveintopython/functional_programming/dynamic_import.html
Ò» ¶¯Ì¬µ¼ÈëÄ£¿é
PythonµÄimport²»ÄܽÓÊܱäÁ¿£¬ËùÒÔÓ¦¸ÃÓà __import__º¯ÊýÀ´¶¯Ì¬µ¼Èë¡£
ÈçϵĴúÂëÎÞ·¨Õý³£µ¼ÈëÄ£¿é
modules = ['OpenSSL', 'Crypto', 'MySQLdb', 'sqlite3', 'zope.interface', 'pyasn1', 'twisted ......

pythonÖÐimport×Ô¼ºÐ´µÄÄ£¿é

Ö»ÐèÒªÔÚÎļþÖÐimportÓëÄãдµÄÎļþµÄÎļþÃûÒ»ÖµÄÄ£¿éÃû¼´¿É£¬Õâʱpython»áΪÄã´´½¨Ò»¸öpycÎļþµÄ¡£
¼´£¬Èç¹ûÄãÒѾ­Ð´ÁËÒ»¸öÃûΪssss.pyµÄÎļþ£¬¶øÏÖÔÚÄãÐèÒªÔÚÃûΪaaaa.pyµÄÎļþÖÐʹÓÃssss.pyÖж¨ÒåµÄ·½·¨£¬ÄÇôÄãÖ»ÐèÒªÔÚaaaa.pyÖмÓÈëimport ssss£¬È»ºóÄã¾Í¿ÉÒÔÔÚaaaa.pyÖÐʹÓÃssss.pyÖеķ½·¨£¨µ±È»·½·¨Ç°ÐèÒª¼ÓÄ£¿éÃû ......

Pythonѧϰ±Ê¼Ç Ä£¿é£»ÎļþÓëÎı¾´¦Àí

1.PythonÖÐʱ¼äº¯ÊýÓм¸ÖÖ²»Í¬µÄ±íʾ·½·¨¡£Ò»ÖÖÊÇ»ùÓÚÊý×ֵıíʾ·½·¨£¬ÁíÍâÒ»ÖÖÊÇÓÃһϵÁÐÖµÀ´±íʾ£¬µÚÈýÖÖÊÇÓÃASCIIÂë×Ö·û´®µÄ¿É¶ÁÐÎʽÀ´±íʾµÄÔª×é¡£ time()º¯Êý·µ»ØµÄÊÇ´Óijһʱ¼äµãËãÆðµÄÃëÊý£¬¸ÃÊýÖµÊÇÒ»¸ö¸¡µãÊý¡£¸ù¾Ý²Ù×÷ϵͳµÄ²»Í¬£¬Õâ¸öʱ¼äµãÒ²²»Í¬¡£Í¨¹ýÇólocaltime(0)µÄÖµ¿ÉÒÔÕÒµ½ÏµÍ³µÄ¸Ãʱ¼äµã¡£ localtime ......

PDF×Ô¶¯¸ÄÃûµÄPython³ÌÐò


ÏÂÔØµÄPDFÎĵµÖÐÓеÄÃüÃûºÜÂÒ£¬¾ÍÏëÆðÁË×Ô¼ºÐ´¸ö³ÌÐò£¬È»ºó¶ÁÈ¡PDFµÄtitleÊôxing£¬¸ù¾ÝÕâ¸öÊôxing£¬¸ü¸Ä´ÎÎĵµµÄÃû×Ö£¡ÒÔÏÂÊÇ´úÂ룺
ÐèÒªµ½£ºhttp://pybrary.net/pyPdf/ÉÏÃæÏÂÔØ¶ÔӦƽ̨µÄPDFµÄ¿âÎļþ£¬È»ºó°²×°£¬µ¼Èë¡£
#encoding:utf-8
import os
import operator
from pyPdf import PdfFileWriter, PdfFileReader ......

ʹÓÃPython´¦ÀíExcel±í¸ñ

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±È½Ï·½±ã£¬¸÷ÖÖ·½·¨Ê¹ÓÃÆ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ