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()
Ïà¹ØÎĵµ£º
#!/usr/bin/env python
#coding=utf-8
def buildConnectionString(params):
return ":".join(["%s=%s" %(k, v) for k, v in params.items()])
if __name__ == "__main__":
myParams = {"server":"mpilgrim", \
&nbs ......
# 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
......
дÁ˸öͼƬ֩ÖëÈËÍæÍæ£¬×¥Á˼¸¸öÍøÒ³ÊÔÊÔ£¬¸Ð¾õ²»²»´í¡£ºËÐĵĴúÂë¿ÉÄÜ20ÐÐÒ²²»µ½£¬¼ò½àÃ÷ÁË£¬ÎûÎû¡£·Ï»°ÉÙ˵£¬´ä»¨£¬ÉÏ´úÂë~~
#coding=utf-8
import os
import sys
import re
import urllib
URL_REG = re.compile(r'(http://[^/\\]+)', re.I)
IMG_REG = re.compile(r'<img[^>]*?src=([ ......
¹ýÁ¿µÄ²ÎÊý
ÔÚÔËÐÐʱ֪µÀÒ»¸öº¯ÊýÓÐʲô²ÎÊý£¬Í¨³£ÊDz»¿ÉÄܵġ£ÁíÒ»¸öÇé¿öÊÇÒ»¸öº¯ÊýÄܲÙ×÷ºÜ¶à¶ÔÏ󡣸üÓÐÉõÕߣ¬µ÷ÓÃ×ÔÉíµÄº¯Êý±ä³ÉÒ»ÖÖapiÌṩ¸ø¿ÉÓõÄÓ¦Óá£
¶ÔÓÚÕâЩÇé¿ö£¬pythonÌṩÁËÁ½ÖÖÌØ±ðµÄ·½·¨À´¶¨Ò庯ÊýµÄ²ÎÊý£¬ÔÊÐíº¯Êý½ÓÊܹýÁ¿µÄ²ÎÊý£¬²»ÓÃÏÔʽÉùÃ÷²ÎÊý¡£ÕâЩ“¶îÍ┵IJÎÊýÏÂÒ»²½ÔÙ½âÊÍ¡£
×¢Òâa ......
Python Import»úÖÆ±¸Íü(ת)
×î½üÔÚ¿´¡¶PythonÔ´ÂëÆÊÎö¡·£¬¶ÔPythonÄÚ²¿ÔËÐлúÖÆ±ÈÒÔǰÁ˽âµÄ¸üÉîÈëÁË£¬¸Ð¾õ×Ô¼ºÓлú»áÒ²¿ÉÒÔ×ö¸öСÐ͵Ķ¯Ì¬½Å±¾ÓïÑÔÁË£¬ºÇºÇ£¬µ±È»
ÊÇ´µÅ£ÁË¡£Ä¿µÄµ±È»²»ÊÇ´´ÔìÒ»¸ö¶¯Ì¬ÓïÑÔ£¬Ä¿µÄÖ»ÓÐÒ»¸ö£º¸üºÃµÄʹÓÃPython¡£¿´µ½Ä£¿éµ¼ÈëÄÇ¿éµÄʱºò£¬ÖÕÓÚ¶ÔÄ£¿éµ¼Èë»úÖÆ±È½ÏÁ˽âÁË£¬ÒÔ·ÀÍ ......