Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Àý×Ó

Çé¾°Ò»£º
ÔÚÎļþ¼ÐÀïÓÐÁùÊ®¶à¸öRM¸ñʽµÄÊÓÆµÎļþ£¬ÎÒÏÖÔÚÐèÒª°ÑËüÃǵÄÎļþÃû¶¼ÌáÈ¡³öÀ´£¬²¢È¥µôÎļþµÄÀ©Õ¹Ãû£¬ÒÔ±ã·Åµ½ÐèÒªµÄÍøÒ³Àï¡£
Ó¦¸ÃÓÐʲôÈí¼þ¿ÉÒÔÍê³ÉÕâ¸ö¼òµ¥µÄÒªÇ󣬿ÉÊÇһʱ¼äµ½ÄÄÀïÈ¥ÕÒÕâ ÑùÒ»¸ö·ûºÏÒªÇóµÄÈí¼þÄØ£¿×ܲ»ÄÜÊÖ¹¤Íê³É°Ñ¡£ÔÚLinuxÉÏÓÃÇ¿´óµÄshell½Å±¾Ó¦¸ÃÒ²¿ÉÒÔÍê³É£¬¿ÉÊÇʹÓÃWindowsµÄÅóÓÑÄØ£¿Æä ......

python¶¯Ì¬µ¼ÈëÄ£¿é¡¢¼ì²éÄ£¿éÊÇ·ñ°²×°

²Î¿¼Á´½Ó£ºhttp://www.woodpecker.org.cn/diveintopython/functional_programming/dynamic_import.html
Ò» ¶¯Ì¬µ¼ÈëÄ£¿é
PythonµÄimport²»ÄܽÓÊܱäÁ¿£¬ËùÒÔÓ¦¸ÃÓà __import__º¯ÊýÀ´¶¯Ì¬µ¼Èë¡£
ÈçϵĴúÂëÎÞ·¨Õý³£µ¼ÈëÄ£¿é
modules = ['OpenSSL', 'Crypto', 'MySQLdb', 'sqlite3', 'zope.interface', 'pyasn1', 'twisted ......

Pythonѧϰ±Ê¼Ç ¸ß¼¶Ö÷Ìâ

1.ÁбíµÄµÝ¹é---ÓÃÓÚÊä³öÁбí×Ö·û´®ÖеÄÿ¸öÔªËØ >>> def printList(L):
    #Èç¹ûΪ¿Õ£¬Ôòʲô¶¼²»×ö
    if not L:
        return
    #Èç¹ûÊÇÁ´±í£¬Ôò¶ÔµÚÒ»¸öÔªËØµ÷ÓÃprintListº¯Êý
 & ......

ʹÓÃPython´¦ÀíExcel±í¸ñ

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±È½Ï·½±ã£¬¸÷ÖÖ·½·¨Ê¹ÓÃÆ ......

python²Ù×÷excel


¼ÈȻѡÔñÁËÔ¶·½£¬¾Í±ØÐëÈÕÒ¹¼æ³Ì http://wrsuifeng.javaeye.com
Python´úÂë
# Filename: excel.py   
import os,sys,time   
import win32com.client   
import traceback   
  
excel = win32com.client.Dispatch(" ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ