Python for win
Python²Ù×÷Excel·½·¨£º
£¨1£©ÔÚsourceforge.netÉÏÓÐÒ»¸öÀ©Õ¹Ä£¿é½ÐpyXLWriter£¬¿ÉÒÔ·½±ãµÄдExcelÎļþ¡£
£¨2£©ÏÂÔØwin32com°ü×°ÉÏ,Õâ¸ö°ü¿ÉÒÔµ÷ÓÃwindowsµÄcom¼°APIº¯ÊýµÈÕâÀàµÄ¹¦ÄÜ¡£PythonÀûÓÃwin32com²Ù×÷Excel¡£
Àý×Ó£º
#!/usr/bin/env python
# -*- coding: utf-8 -*-
from win32com.client import Dispatch
import win32com.client
class easyExcel:
"""A utility to make it easier to get at Excel. Remembering
to save the data is your problem, as is error handling.
Operates on one workbook at a time."""
def __init__(self, filename=None):
self.xlApp = win32com.client.Dispatch('Excel.Application')
if filename:
self.filename = filename
self.xlBook = self.xlApp.Workbooks.Open(filename)
else:
self.xlBook = self.xlApp.Workbooks.Add()
self.filename = ''
def save(self, newfilename=None):
if newfilename:
self.filename = newfilename
Ïà¹ØÎĵµ£º
pythonÖÐÀàµÄÊôÐÔ
pythonÖеÄÀà½Ðclass object,ÀàµÄʵÀý½Ðinstance object.
Àà Class Objects
ÀàÓµÓÐÁ½ÖÖ²Ù×÷,1.ÀàÊôÐÔ attribute references 2.ʵÀý»¯instantiation
1.ÀàÊôÐÔ¾ÍÏ൱ÓÚרÊôÓÚÒ»¸öÀàµÄ±äÁ¿(¼´Ä³Ð©ÓïÑÔÖеÄÀàµÄ¾²Ì¬¹«¹²±äÁ¿static public),ʹÓ÷½·¨ÊÇ:ÀàÃû³Æ.ÀàÊôÐÔÃû³Æ
2.ʵÀý»¯ÔòÊÇ´´½¨Ò»¸öÀàµÄʵÀýµÄ· ......
×î½üÔÚÑжÁPythonÔ´ÂëÆÊÎöÒ»Ê飬´ËÊéÏ൱²»´í£¬Èç¹û×Ô¼º³å¶¯µÄÈ¥·ÖÎöPythonÔ´Âë¿ÉÄܻᵽ´¦Åö“±Ç”£¬¿´µ½´ËÊéʱÊÇ09Ä꣬ÄÇʱΪÁËÑо¿ÄÚ´æ»úÖƲŷ¢ÏÖÓÐÕâôһ±¾Ê飬µ«Êǹ¤×÷̫棬¸ù±¾Ã»Ê±¼äÈ¥·ÖÎöÔ´Â룬µ½ÁË2010Ä꣬ÕâÊǷdz£ÓÐÉîÖØÒâÒåµÄÒ»Ä꣬ËùÒÔÕâÒ»ÄêÒ»¶¨Òª±È֮ǰ×öµÄ»¹Òª¸¶³ö¸ü¶à£¬ÒªÏë³ÉΪ¼¼Êõ¶¥¼â¾Í±ØÐëÑÐ ......
8.PythonÖÐûÓÐswitchÓï¾ä,¿ÉÒÔÓÃif..elif..elseÓï¾äÍê³ÉͬÑùµÄ¹¤×÷(ijЩ³¡ºÏ,ʹÓÃ×Öµä»á¸ü¼Ó¿ì½Ý)
9.whileÓï¾ä°üº¬Ò»¸öelseµÄ´Ó¾ä.
10.rangeÏòÉÏÑÓÉìµ½µÚ¶þ¸öÊý,¼´Ëü²»°üº¬µÚ¶þ¸öÊý.
11.ʹÓÃglobalÓï¾ä¿ÉÒÔÇå³þµØ±íÃ÷±äÁ¿ÊÇÔÚÍâÃæµÄ¿é¶¨ÒåµÄ. ......
PythonÖ§³Öascii×Ö·û´®£¬unicode×Ö·û´®£¬ÒÔ¼°¸÷ÖÖ×Ö·û¼¯£¬ÄÇôËüÃǵ½µ×¸÷ÊÇʲô¸ÅÄÏ໥֮¼ä´æÔÚºÎÖÖ¹ØϵÄØ£¿
ÔÚPythonÖУ¬ascii×Ö·û´®£¬¼´strÀàÐ͵ÄÖµ£¬¿ÉÄÜÓÃÀ´±íʾÈÎÒâµÄÒ»¿é´æ´¢¿Õ¼ä£¬ÄÇôҲ¾ÍÊÇ˵£¬Õâ¸ö×Ö·û´®ÄÚ²¿¿ÉÒÔÊÇÈκÎÖµ£¬ÀýÈ磺¿É¼û×Ö·û×é³ÉµÄ×Ö·û´®£¬»òÕßÒ»¶Î¶þ½øÖÆÊý¾ÝµÈ¡£unicode×Ö·û´®£¬¼´unicodeÀàÐ굀 ......
1.1. Óï·¨
1.1.1. if
>>> x=int(raw_input("please enter an integer:"))
please enter an integer:-8
>>> if x<0:
... print 'negative'
... elif x==0:
... print 'zero'
... else:
... print 'positive'
...
negative
ÕâÀïÓм¸¸ö֪ʶµãÐèÒªÌáÐÑ£º
1¡£ºÍ ......