python²Ù×÷excelÐÔÄÜÎÊÌâÇóÖú
http://bbs.chinaunix.net/thread-1586782-1-1.html
ÎÒ¸Õ¸ÕÓÃpythonдÁËÒ»¶Î²Ù×÷excelµÄ½Å±¾£¬Ä¿µÄÊǰÑÒ»¸öexcelÎļþ°´ÕÕijһÁÐÖеÄ×ֶβð·Ö³É¶à¸öÎļþ£¬ÀýÈç°´ÕÕ³ÇÊлòÕßÊ¡·ÝµÈ£¬µ«ÊÇ·¢ÏÖ´¦ÀíÒ»¸ö1700ÐеÄÎļþ²ð·Ö³É40¶à¸öÎļþʱҪÔËÐÐ30·ÖÖÓ×óÓÒ£¬ÐÔÄÜÌ«Âý£¬Çë¸ßÊÖ°ïæ¿´¿´Ôõô²ÅÄÜÓÅ»¯ÐÔÄÜ£¬Ð»Ð»¡£
ÐÂÊÖдµÄ½Å±¾£¬Çë²»Òª¼ûЦ£¬ÈçÏ£º
'''
Created on 2009-9-25
@author: vidon
'''
#_*_ coding:UTF-8 _*_
import os, sys, time
import win32com.client
xls=win32com.client.Dispatch("Excel.Application")
xls.Visible=False
source_path = input('ÇëÊäÈëÒª²Ù×÷µÄÎļþÃû·¾¶ÓëÃû³Æ£¨ÀýÈ磺D:\ABC\BOOK.XLS£©£º').replace('\r','')
target_path = input('ÇëÊäÈë´æ·ÅÊý¾Ý´¦Àí½á¹ûµÄĿ¼£¨ÀýÈ磺D:\BACK\)£º').replace('\r','')
x=int(input("ÇëÊäÈë±íÍ·µÄÐÐÊý£º").replace('\r',''))
y=int(input("ÇëÊäÈë×÷Ϊ²ð·ÖÊý¾ÝµÄÒÀ¾ÝËùÔÚÁеĺÅÂ룺").replace('\r',''))
if not os.path.exists(target_path):
os.mkdir(target_path)
print("ÒѾ´´½¨Ö¸¶¨µÄĿ¼£¬×¼±¸´´½¨Îļþ£¬ÇëÉԵȷ·····")
else:
print("×¼±¸´´½¨Îļþ£¬ÇëÉԵȷ·····")
#¶ÁÈ¡ÔʼÎļþ
book=xls.Workbooks.Open(source_path)
sheet=book.ActiveSheet
length = sheet.UsedRange.Rows.Count
y_length = sheet.UsedRange.Columns.Count
keyArray = []
for i in range((x+1),length):
keyArray.append(sheet.Cells(i,y).Value)
#¸ù¾ÝÖ¸¶¨µÄÁÐÖеÄ×ֶδ´½¨ÐÂÎļþ
ll = len(keyArray)
for j in range(1,ll):
filename = target_path + str(keyArray[j]) + ".xls"
if os.path.exists (filename):
continue
else :
sheet.Range(sheet.Cells(1,1),sheet.Cells(x,y_length)).select
sheet.Range(sheet.Cells(1,1),sheet.Cells(x,y_length)).copy
newbook = xls.Workbooks.Add()
&nb
Ïà¹ØÎĵµ£º
#ʹÓÃÀà
class CPerson:
#Àà±äÁ¿ºÃ±ÈC++Öеľ²Ì¬³ÉÔ±±äÁ¿
population = 0
def SayHi(self):
print('Hello World')
def HowMany(self):
if CPerson.population == 1:
print('I am the only person here.')
else:
print(('We have %d perso ......
1.PythonÖÐʱ¼äº¯ÊýÓм¸ÖÖ²»Í¬µÄ±íʾ·½·¨¡£Ò»ÖÖÊÇ»ùÓÚÊý×ֵıíʾ·½·¨£¬ÁíÍâÒ»ÖÖÊÇÓÃһϵÁÐÖµÀ´±íʾ£¬µÚÈýÖÖÊÇÓÃASCIIÂë×Ö·û´®µÄ¿É¶ÁÐÎʽÀ´±íʾµÄÔª×é¡£ time()º¯Êý·µ»ØµÄÊÇ´Óijһʱ¼äµãËãÆðµÄÃëÊý£¬¸ÃÊýÖµÊÇÒ»¸ö¸¡µãÊý¡£¸ù¾Ý²Ù×÷ϵͳµÄ²»Í¬£¬Õâ¸öʱ¼äµãÒ²²»Í¬¡£Í¨¹ýÇólocaltime(0)µÄÖµ¿ÉÒÔÕÒµ½ÏµÍ³µÄ¸Ãʱ¼äµã¡£ localtime ......
³õѧpython£¬ÏÖÔÚÒª¶ÁÒ»¸ö¶þ½øÖÆÎļþ£¬²éÕÒdocÖ»·¢ÏÖfileÌṩÁËÒ»¸öreadºÍwriteº¯Êý£¬¶øÇÒ¶ÁдµÄ¶¼ÊÇ×Ö·û´®£¬Èç¹ûÖ»ÊǶÁдcharµÈÒ»¸ö×ֽڵϹÐУ¬ÒªÏë¶ÁдÈçint,doubleµÈ¶à×Ö½ÚÊý¾Ý¾Í²»·½±ãÁË¡£ÔÚÍøÉϲ鵽һƪÌù×Ó£¬Ê¹ÓÃstructÄ£¿éÀïÃæµÄpackºÍunpackº¯Êý½øÐжÁд¡£ÏÂÃæ¾Í×Ô¼ºÐ´´úÂëÑé֤һϡ£
>>> from struct ......
¹ýÁ¿µÄ²ÎÊý
ÔÚÔËÐÐʱ֪µÀÒ»¸öº¯ÊýÓÐʲô²ÎÊý£¬Í¨³£ÊDz»¿ÉÄܵġ£ÁíÒ»¸öÇé¿öÊÇÒ»¸öº¯ÊýÄܲÙ×÷ºÜ¶à¶ÔÏ󡣸üÓÐÉõÕߣ¬µ÷ÓÃ×ÔÉíµÄº¯Êý±ä³ÉÒ»ÖÖapiÌṩ¸ø¿ÉÓõÄÓ¦Óá£
¶ÔÓÚÕâЩÇé¿ö£¬pythonÌṩÁËÁ½ÖÖÌØ±ðµÄ·½·¨À´¶¨Ò庯ÊýµÄ²ÎÊý£¬ÔÊÐíº¯Êý½ÓÊܹýÁ¿µÄ²ÎÊý£¬²»ÓÃÏÔʽÉùÃ÷²ÎÊý¡£ÕâЩ“¶îÍ┵IJÎÊýÏÂÒ»²½ÔÙ½âÊÍ¡£
×¢Òâa ......
Python Import»úÖÆ±¸Íü(ת)
×î½üÔÚ¿´¡¶PythonÔ´ÂëÆÊÎö¡·£¬¶ÔPythonÄÚ²¿ÔËÐлúÖÆ±ÈÒÔǰÁ˽âµÄ¸üÉîÈëÁË£¬¸Ð¾õ×Ô¼ºÓлú»áÒ²¿ÉÒÔ×ö¸öСÐ͵Ķ¯Ì¬½Å±¾ÓïÑÔÁË£¬ºÇºÇ£¬µ±È»
ÊÇ´µÅ£ÁË¡£Ä¿µÄµ±È»²»ÊÇ´´ÔìÒ»¸ö¶¯Ì¬ÓïÑÔ£¬Ä¿µÄÖ»ÓÐÒ»¸ö£º¸üºÃµÄʹÓÃPython¡£¿´µ½Ä£¿éµ¼ÈëÄÇ¿éµÄʱºò£¬ÖÕÓÚ¶ÔÄ£¿éµ¼Èë»úÖÆ±È½ÏÁ˽âÁË£¬ÒÔ·ÀÍ ......