python Excel ±à³Ì
1)Excel hyperlink:
xlsApp = win32com.client.Dispatch('Excel.Application')
cell = xls.App.ActiveSheet.Cells(1,1)
cell.Hyperlink.Add(cell,'http://xxx')
2)Excel row/column count:
sht = xlsApp.ActiveSheet
sht.Columns.Areas.Count
sht.Rows.Areas.Count
*************************
£Û1£ÝʹÓÃPyExcelerator¶ÁдEXCELÎļþ(Platform: Win,Unix-like)
Óŵ㣺¼òµ¥Ò×Óà ȱµã£º²»¿É¸Ä±äÒÑ´æÔÚµÄEXCELÎļþ¡£
PyExceleratorÊÇÒ»¸ö¿ªÔ´µÄMS ExcelÎļþ´¦Àípython°ü¡£ËüÖ÷ÒªÊÇÓÃÀ´Ð´ Excel Îļþ.URL: http://sourceforge.net/projects/pyexcelerator/
ÎÒûÓÐÕÒµ½¹ØÓÚPyExceleratorµÄÎĵµ¡£Ö»ÊÇ¿´µ½ÁËlimodouµÄһƪ½éÉÜ¡£
http://blog.donews.com/limodou/archive/2005/07/09/460033.aspx
Õâ¸ö°üʹÓÃÆðÀ´»¹ÊDZȽϼòµ¥µÄ£º£©¡£´øÁ˺ܶàСÀý×Ó£¬¿ÉÒÔ²ÎÕÕ¡£
Àýmini.py.
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½
#!/usr/bin/env python
# -*- coding: windows-1251 -*-
# Copyright (C) 2005 Kiseliov Roman
__rev_id__ = """$Id: mini.py,v 1.3 2005/03/27 12:47:06 rvk Exp $"""
"µ¼ÈëÄ£¿é
from pyExcelerator import *
"Éú³ÉÒ»¸ö¹¤×÷±¡
w = Workbook()
"¼ÓÈëÒ»¸öSheet
ws = w.add_sheet('Hey, Dude')
"±£´æ
w.save('mini.xls')
£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½£½
[2]ʹÓÃCOM½Ó¿Ú£¬Ö±½Ó²Ù×÷EXCEL(Ö»ÄÜÔÚWinÉÏ)
Óŵ㣺¿ÉÒÔÂú×ã¾ø´óÊýÒªÇó¡£È±µã£ºÓÐЩÂé·³¡£:-)
Õâ·½ÃæµÄÀý×Ӻܶ࣬GOOGLE ¿´°É:-). ÎĵµÒ²¿ÉÒԲο´OFFICE×Ô´øµÄVBA EXCEL °ïÖúÎļþ(VBAXL.CHM)¡£ÕâÀïÃæ½²ÊöÁËEXCEL VBAµÄ±à³Ì¸ÅÄ
²»´íµÄ½Ì³Ì£¡ÁíÍ⣬¡¶Python Programming on Win32¡·ÊéÖÐÒ²ÓкÜÏêϸµÄ½éÉÜ¡£Õâ±¾ÊéÖиø³öÁËÒ»¸öÀàÀ´²Ù×÷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."""
 
Ïà¹ØÎĵµ£º
ÏÈ˵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 ......
def MergeSort(mylist, low, mid, high):
i = low
j = mid + 1
tmp = []
while i <= mid and j <= high:
if mylist[i] <= mylist[j]:
tmp.append(mylist[i])
i = i + 1
else:
tmp.append(mylist[j])
j = j + 1
......
1.PythonÖÐʱ¼äº¯ÊýÓм¸ÖÖ²»Í¬µÄ±íʾ·½·¨¡£Ò»ÖÖÊÇ»ùÓÚÊý×ֵıíʾ·½·¨£¬ÁíÍâÒ»ÖÖÊÇÓÃһϵÁÐÖµÀ´±íʾ£¬µÚÈýÖÖÊÇÓÃASCIIÂë×Ö·û´®µÄ¿É¶ÁÐÎʽÀ´±íʾµÄÔª×é¡£ time()º¯Êý·µ»ØµÄÊÇ´Óijһʱ¼äµãËãÆðµÄÃëÊý£¬¸ÃÊýÖµÊÇÒ»¸ö¸¡µãÊý¡£¸ù¾Ý²Ù×÷ϵͳµÄ²»Í¬£¬Õâ¸öʱ¼äµãÒ²²»Í¬¡£Í¨¹ýÇólocaltime(0)µÄÖµ¿ÉÒÔÕÒµ½ÏµÍ³µÄ¸Ãʱ¼äµã¡£ localtime ......
Python Import»úÖƱ¸Íü(ת)
×î½üÔÚ¿´¡¶PythonÔ´ÂëÆÊÎö¡·£¬¶ÔPythonÄÚ²¿ÔËÐлúÖƱÈÒÔÇ°Á˽âµÄ¸üÉîÈëÁË£¬¸Ð¾õ×Ô¼ºÓлú»áÒ²¿ÉÒÔ×ö¸öСÐ͵Ķ¯Ì¬½Å±¾ÓïÑÔÁË£¬ºÇºÇ£¬µ±È»
ÊÇ´µÅ£ÁË¡£Ä¿µÄµ±È»²»ÊÇ´´ÔìÒ»¸ö¶¯Ì¬ÓïÑÔ£¬Ä¿µÄÖ»ÓÐÒ»¸ö£º¸üºÃµÄʹÓÃPython¡£¿´µ½Ä£¿éµ¼ÈëÄÇ¿éµÄʱºò£¬ÖÕÓÚ¶ÔÄ£¿éµ¼Èë»úÖƱȽÏÁ˽âÁË£¬ÒÔ·ÀÍ ......
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±È½Ï·½±ã£¬¸÷ÖÖ·½·¨Ê¹ÓÃÆ ......