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

ʹÓÃ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±È½Ï·½±ã£¬¸÷ÖÖ·½·¨Ê¹ÓÃÆðÀ´Ò²Í¦·½±ã£º
bk = xlrd.open_workbook('your.xls')
sh = bk.sheets()[-1]
ÉÏÃæÁ½¾ä¾Í¿ÉÒÔ´ò¿ªExcel±í¸ñÖеÄÒ»¸ösheet£¬sheetsµÃµ½µÄÊÇÒ»¸ölist£¬´æ·ÅËùÓеÄsheet¡£
sh.nrowsÊǸÃsheetÖеÄÐÐÊý£¬ÖªµÀÕâ¸öºó¾Í¿ÉÒÔʹÓÃforÑ­»·À´¶ÁËùÓеĵ¥Ôª¸ñÁË£º
sh.row(i)[3]Õâ¸ö¾Í´ú±íµÚiÐеĵÚ4ÁС£
ÔÙ¿´¿´pyExcelerator£¬Õâ¸öÓÃÆðÀ´Óеã±ðŤ£º
sheets = parse_xls('result.xls')
ÏÈ´ò¿ªÒ»¸ö±í¸ñ£¬sheetsÊÇÒ»¸ölist£¬°üº¬ÁËËùÓбí¸ñµÄÄÚÈÝ£¬Ã¿Ò»Ïî¾ÍÊÇÒ»¸ösheet£¬¶øÃ¿¸ösheetÊǶþÔªtuple£¬µÚÒ»¸öÊǸÃsheetµÄÃû×Ö£¬µÚ¶þ¸öÊÇÒ»¸ödict£¬dictµÄkeyÊÇÒ»¸ö¶þÔª×飬±íʾµ¥Ôª¸ñµÄ×ø±ê£¬Èç(0,0)£¬µÚÒ»ÐеÚÒ»ÁС£
´ÓÉÏÃæµÄ·ÖÎöÖпÉÒԵóöÒª·ÃÎÊExcelÖеÚÒ»¸ösheetµÄµÚÒ»ÐеÚÒ»ÁÐÔªËØÐèÒª£º
sheets[0][1][(0,0)]
pyExceleratorÒ²²»Äܵõ½ÐÐÁÐÊý¡£
дÎļþÒ²±È½Ï¼òµ¥£º
wb = Workbook()
ws = wb.add_sheet('result')
ws.write(0,0,“hello”)
wb.save('result.xls')
¾Í²»½âÊÍÁË:-)
дÎļþʱÐèҪעÒâÖ±½ÓдUnicodeÄÚÈݽøÈ¥£¬¶ø²»ÒªÐ´±àÂë¹ýµÄÄÚÈÝ¡£
±¾ÎÄÀ´Ô´ÓÚ¿É¿ÉÐܵÄÎÑ http://cocobear.info/blog , Ô­ÎĵØÖ·£º http://cocobear.info/blog/2009/01/16/use-python-deal-with-excel/


Ïà¹ØÎĵµ£º

pythonµÄһЩ²Ù×÷

# coding=gb2312
# ÓÃÖÐÎÄ×¢ÊÍǰÎñ±Ø¼ÓÉϵÚÒ»ÐÐ
# ÇóÄ£ÔËËã·û£¬ºÍCÓïÑÔÒ»Ñù
print 10%9
# ÕûÊýÏà³ýÈÔÈ»ÊÇÕûÊý
print 5/2
# 2ºó¼ÓÉÏ.¾Í±ä³É¸¡µãÊýÁË
print 5/2.
# **±íʾÇóÃÝÔËËã
print 7**4
# º¯ÊýÓÃʱҪ¼ÓÉÏmodule.function
import math
print math.floor(19.8)
# º¯ÊýÃûÒ²¿ÉÒÔ³ÉΪ±äÁ¿
func = math.floor
......

Python GTK+ ¿ª·¢Îĵµ

1. Building an Application with PyGTK and Glade
2. Creating a GUI using PyGTK and Glade
3. A Beginner's Guide to Using pyGTK and Glade
4. Is there a walkthrough on getting PyGTK2 and libglade2 to work on win32 ......

ÓÃPythonдµÄͼƬ֩ÖëÈË


    Ð´Á˸öͼƬ֩ÖëÈËÍæÍæ£¬×¥Á˼¸¸öÍøÒ³ÊÔÊÔ£¬¸Ð¾õ²»²»´í¡£ºËÐĵĴúÂë¿ÉÄÜ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¶Áд¶þ½øÖÆÎļþ

³õѧpython£¬ÏÖÔÚÒª¶ÁÒ»¸ö¶þ½øÖÆÎļþ£¬²éÕÒdocÖ»·¢ÏÖfileÌṩÁËÒ»¸öreadºÍwriteº¯Êý£¬¶øÇÒ¶ÁдµÄ¶¼ÊÇ×Ö·û´®£¬Èç¹ûÖ»ÊǶÁдcharµÈÒ»¸ö×ֽڵϹÐУ¬ÒªÏë¶ÁдÈçint,doubleµÈ¶à×Ö½ÚÊý¾Ý¾Í²»·½±ãÁË¡£ÔÚÍøÉϲ鵽һƪÌù×Ó£¬Ê¹ÓÃstructÄ£¿éÀïÃæµÄpackºÍunpackº¯Êý½øÐжÁд¡£ÏÂÃæ¾Í×Ô¼ºÐ´´úÂëÑé֤һϡ£
>>> from struct ......

Python Import»úÖÆ±¸Íü(ת)

Python Import»úÖÆ±¸Íü(ת)
   ×î½üÔÚ¿´¡¶PythonÔ´ÂëÆÊÎö¡·£¬¶ÔPythonÄÚ²¿ÔËÐлúÖÆ±ÈÒÔǰÁ˽âµÄ¸üÉîÈëÁË£¬¸Ð¾õ×Ô¼ºÓлú»áÒ²¿ÉÒÔ×ö¸öСÐ͵Ķ¯Ì¬½Å±¾ÓïÑÔÁË£¬ºÇºÇ£¬µ±È»
ÊÇ´µÅ£ÁË¡£Ä¿µÄµ±È»²»ÊÇ´´ÔìÒ»¸ö¶¯Ì¬ÓïÑÔ£¬Ä¿µÄÖ»ÓÐÒ»¸ö£º¸üºÃµÄʹÓÃPython¡£¿´µ½Ä£¿éµ¼ÈëÄÇ¿éµÄʱºò£¬ÖÕÓÚ¶ÔÄ£¿éµ¼Èë»úÖÆ±È½ÏÁ˽âÁË£¬ÒÔ·ÀÍ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ