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
pythonµÄrandomÄ£¿éÌṩÁ˶à¸öÎ±Ëæ»úÊý·¢ÉúÆ÷£¬Ä¬È϶¼ÊÇÓõ±Ç°Ê±¼ä´ÁÎªËæ»úÊýÖÖ×Ó¡£
ÏÂÃæÊǸÃÄ£¿é¼¸¸ö×î³£Óõĺ¯Êý
random() Return the next random floating point number in the range [0.0, 1.0).
randint(a,b) Return a random integer N such that a <=
N <= b
randrange([star ......
ÎҵĻ·¾³ÊÇ£º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 ......
³õѧpython£¬ÏÖÔÚÒª¶ÁÒ»¸ö¶þ½øÖÆÎļþ£¬²éÕÒdocÖ»·¢ÏÖfileÌṩÁËÒ»¸öreadºÍwriteº¯Êý£¬¶øÇÒ¶ÁдµÄ¶¼ÊÇ×Ö·û´®£¬Èç¹ûÖ»ÊǶÁдcharµÈÒ»¸ö×ֽڵϹÐУ¬ÒªÏë¶ÁдÈçint,doubleµÈ¶à×Ö½ÚÊý¾Ý¾Í²»·½±ãÁË¡£ÔÚÍøÉϲ鵽һƪÌù×Ó£¬Ê¹ÓÃstructÄ£¿éÀïÃæµÄpackºÍunpackº¯Êý½øÐжÁд¡£ÏÂÃæ¾Í×Ô¼ºÐ´´úÂëÑé֤һϡ£
>>> from struct ......
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±È½Ï·½±ã£¬¸÷ÖÖ·½·¨Ê¹ÓÃÆ ......