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."""
 
Ïà¹ØÎĵµ£º
#!/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 ......
ÎҵĻ·¾³ÊÇ£ºLinux version 2.4.21-4.EL
(bhcompile@daffy.perf.redhat.com) (gcc version 3.2.3 20030502 (Red Hat
Linux 3.2.3-20)) #1 Fri Oct 3 18:13:58 EDT 2003 + Python2.6.4
±¾ÎĽáºÏÎÒ°²×°Ê±ºòµÄÎÊÌ⣬×Ü½á¶ø³É
Óû§Ä¿Â¼Èç/home/liuguanyu/ , ±£Ö¤Óû§ÓÐrootȨÏÞ
1£¬¿´¿´ÓÐûÓа²×°
&nbs ......
1.ÁбíµÄµÝ¹é---ÓÃÓÚÊä³öÁбí×Ö·û´®ÖеÄÿ¸öÔªËØ >>> def printList(L):
#Èç¹ûΪ¿Õ£¬Ôòʲô¶¼²»×ö
if not L:
return
#Èç¹ûÊÇÁ´±í£¬Ôò¶ÔµÚÒ»¸öÔªËØµ÷ÓÃprintListº¯Êý
& ......
дÁ˸öͼƬ֩ÖëÈËÍæÍæ£¬×¥Á˼¸¸öÍøÒ³ÊÔÊÔ£¬¸Ð¾õ²»²»´í¡£ºËÐĵĴúÂë¿ÉÄÜ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=([ ......
Python Import»úÖÆ±¸Íü(ת)
×î½üÔÚ¿´¡¶PythonÔ´ÂëÆÊÎö¡·£¬¶ÔPythonÄÚ²¿ÔËÐлúÖÆ±ÈÒÔǰÁ˽âµÄ¸üÉîÈëÁË£¬¸Ð¾õ×Ô¼ºÓлú»áÒ²¿ÉÒÔ×ö¸öСÐ͵Ķ¯Ì¬½Å±¾ÓïÑÔÁË£¬ºÇºÇ£¬µ±È»
ÊÇ´µÅ£ÁË¡£Ä¿µÄµ±È»²»ÊÇ´´ÔìÒ»¸ö¶¯Ì¬ÓïÑÔ£¬Ä¿µÄÖ»ÓÐÒ»¸ö£º¸üºÃµÄʹÓÃPython¡£¿´µ½Ä£¿éµ¼ÈëÄÇ¿éµÄʱºò£¬ÖÕÓÚ¶ÔÄ£¿éµ¼Èë»úÖÆ±È½ÏÁ˽âÁË£¬ÒÔ·ÀÍ ......