PythonÄ£¿éѧϰ urllib
urllibÄ£¿éÌṩµÄÉϲã½Ó¿Ú£¬Ê¹ÎÒÃÇ¿ÉÒÔÏñ¶ÁÈ¡±¾µØÎļþÒ»Ñù¶ÁÈ¡wwwºÍftpÉϵÄÊý¾Ý¡£Ã¿µ±Ê¹ÓÃÕâ¸öÄ£¿éµÄʱºò£¬ÀÏÊÇ»áÏëÆð¹«Ë¾²úÆ·µÄ¿Í»§¶Ë£¬Í¬ÊÂÓÃC++ÏÂÔØWebÉϵÄͼƬ£¬ÄÇÖÖ“Í´¿à”µÄ±íÇé¡£ÎÒÒÔǰ·Òë¹ýlibcurl½Ì³Ì£¬ÕâÊÇÔÚC/C++»·¾³Ï±ȽϷ½±ãʵÓõÄÍøÂç²Ù×÷¿â£¬Ïà±ÈÆðlibcurl£¬PythonµÄurllibÄ£¿éµÄʹÓÃÃż÷ÔòµÍ¶àÁË¡£¿ÉÄÜÓÐЩÈËÓÖ»áÓÃЧÂÊÀ´ÅúÆÀPython£¬ÆäʵÔÚ²Ù×÷ÍøÂ磬»òÕßÔÚ¼¯Èº½»»¥µÄʱºò£¬ ÓïÑÔµÄÖ´ÐÐЧÂʾø²»ÊÇÆ¿¾±¡£ÕâÖÖÇé¿öÏ£¬Ò»¸ö±È½ÏºÃµÄ·½·¨ÊÇ£¬½«pythonǶÈëµ½C/C++ÖУ¬ÈÃPythonÀ´Íê³ÉһЩ²»ÊǺËÐĵÄÂß¼´¦Àí¡£ÓÖ³¶Ô¶ÁË£¬·Ï»°ÉÙ˵£¬¿ªÊ¼urllibÖ®ÂðÉ~~ £¨Ç°¼¸ÌìÎÒÓÃÕâ¸öÄ£¿éдÁ˸öÖ©Ö룬¸ÐÐËȤµÄͬѧ¿ÉÒÔÔÚÒÔǰµÄ²©¿ÍÖÐÕÒµ½´úÂ룩
ÏÈ¿´Ò»¸öÀý×Ó£¬Õâ¸öÀý×Ó°ÑGoogleÊ×Ò³µÄhtmlץȡÏÂÀ´²¢ÏÔʾÔÚ¿ØÖÆÌ¨ÉÏ£º
# ±ð¾ªÑÈ£¬Õû¸ö³ÌÐòȷʵֻÓÃÁËÁ½ÐдúÂë
import urllib
print urllib.urlopen('http://www.google.com').read()
urllib.urlopen(url[, data[, proxies]]) :
´´½¨Ò»¸ö±íʾԶ³ÌurlµÄÀàÎļþ¶ÔÏó£¬È»ºóÏñ±¾µØÎļþÒ»Ñù²Ù×÷Õâ¸öÀàÎļþ¶ÔÏóÀ´»ñȡԶ³ÌÊý¾Ý¡£²ÎÊýurl±íʾԶ³ÌÊý¾ÝµÄ·¾¶£¬Ò»°ãÊÇÍøÖ·£»²ÎÊýdata±íʾÒÔpost·½Ê½Ìá½»µ½urlµÄÊý¾Ý(Íæ¹ýwebµÄÈËÓ¦¸ÃÖªµÀÌá½»Êý¾ÝµÄÁ½ÖÖ·½Ê½£ºpostÓëget¡£Èç¹ûÄã²»Çå³þ£¬Ò²²»±ØÌ«ÔÚÒ⣬һ°ãÇé¿öϺÜÉÙÓõ½Õâ¸ö²ÎÊý)£»²ÎÊýproxiesÓÃÓÚÉèÖôúÀí£¨ÕâÀï²»Ïêϸ½²ÔõôʹÓôúÀí£¬¸ÐÐËȤµÄ¿´¿Í¿ÉÒÔÈ¥·ÔÄPythonÊÖ²áurllibÄ£¿é£©¡£urlopen·µ»Ø Ò»¸öÀàÎļþ¶ÔÏó£¬ËûÌṩÁËÈçÏ·½·¨£º
read()
, readline()
, readlines()
, fileno()
, close()
£ºÕâЩ·½·¨µÄʹÓ÷½Ê½ÓëÎļþ¶ÔÏóÍêȫһÑù;
info()£º·µ»ØÒ»¸öhttplib.HTTPMessage
¶ÔÏ󣬱íʾԶ³Ì·þÎñÆ÷·µ»ØµÄÍ·ÐÅÏ¢£»
getcode()£º·µ»ØHttp״̬Âë¡£Èç¹ûÊÇhttpÇëÇó£¬200±íʾÇëÇó³É¹¦Íê³É;404±íÊ¾ÍøÖ·Î´ÕÒµ½£»
geturl()£º·µ»ØÇëÇóµÄurl£»
ÏÂÃæÀ´À©³äÒ»ÏÂÉÏÃæµÄÀý×Ó£¬¿´¹Ù¿ÉÒÔÔËÐÐÒ»ÏÂÕâ¸öÀý×Ó£¬¼ÓÉî¶ÔurllibµÄÓ¡Ïó£º
google = urllib.urlopen('http://www.google.com')
print 'http header:\n', google.info()
print 'http status:', google.getcode()
print 'url:', google.geturl()
for line in google: # ¾ÍÏñÔÚ²Ù×÷±¾µØÎļþ
print line,
google.close()
Ïà¹ØÎĵµ£º
ÏÂÔØµÄPDFÎĵµÖÐÓеÄÃüÃûºÜÂÒ£¬¾ÍÏëÆðÁË×Ô¼ºÐ´¸ö³ÌÐò£¬È»ºó¶ÁÈ¡PDFµÄtitleÊôxing£¬¸ù¾ÝÕâ¸öÊôxing£¬¸ü¸Ä´ÎÎĵµµÄÃû×Ö£¡ÒÔÏÂÊÇ´úÂ룺
ÐèÒªµ½£ºhttp://pybrary.net/pyPdf/ÉÏÃæÏÂÔØ¶ÔӦƽ̨µÄPDFµÄ¿âÎļþ£¬È»ºó°²×°£¬µ¼Èë¡£
#encoding:utf-8
import os
import operator
from pyPdf import PdfFileWriter, PdfFileReader ......
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±È½Ï·½±ã£¬¸÷ÖÖ·½·¨Ê¹ÓÃÆ ......
¼ÈȻѡÔñÁËÔ¶·½£¬¾Í±ØÐëÈÕÒ¹¼æ³Ì http://wrsuifeng.javaeye.com
Python´úÂë
# Filename: excel.py
import os,sys,time
import win32com.client
import traceback
excel = win32com.client.Dispatch(" ......
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£ÝʹÓÃPyExcelera ......