Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄһЩ²Ù×÷

# coding=gb2312
# ÓÃÖÐÎÄ×¢ÊÍǰÎñ±Ø¼ÓÉϵÚÒ»ÐÐ
# ÇóÄ£ÔËËã·û£¬ºÍCÓïÑÔÒ»Ñù
print 10%9
# ÕûÊýÏà³ýÈÔÈ»ÊÇÕûÊý
print 5/2
# 2ºó¼ÓÉÏ.¾Í±ä³É¸¡µãÊýÁË
print 5/2.
# **±íʾÇóÃÝÔËËã
print 7**4
# º¯ÊýÓÃʱҪ¼ÓÉÏmodule.function
import math
print math.floor(19.8)
# º¯ÊýÃûÒ²¿ÉÒÔ³ÉΪ±äÁ¿
func = math.floor
......

Python GTK+ ¿ª·¢Îĵµ

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 ......

python¶Áд¶þ½øÖÆÎļþ

³õѧpython£¬ÏÖÔÚÒª¶ÁÒ»¸ö¶þ½øÖÆÎļþ£¬²éÕÒdocÖ»·¢ÏÖfileÌṩÁËÒ»¸öreadºÍwriteº¯Êý£¬¶øÇÒ¶ÁдµÄ¶¼ÊÇ×Ö·û´®£¬Èç¹ûÖ»ÊǶÁдcharµÈÒ»¸ö×ֽڵϹÐУ¬ÒªÏë¶ÁдÈçint,doubleµÈ¶à×Ö½ÚÊý¾Ý¾Í²»·½±ãÁË¡£ÔÚÍøÉϲ鵽һƪÌù×Ó£¬Ê¹ÓÃstructÄ£¿éÀïÃæµÄpackºÍunpackº¯Êý½øÐжÁд¡£ÏÂÃæ¾Í×Ô¼ºÐ´´úÂëÑé֤һϡ£
>>> from struct ......

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ºÅ