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

Python Êý×ÖÓë×Ö·û´®Á¬½ÓÎÊÌâ

¶¨ÒåÏÂÃæÕâÑùÒ»¸öº¯Êý£¬½«excel±í¸ñÖÐÁ½¸öµ¥Ôª¸ñµÄÄÚÈÝÁ¬³ÉÒ»¸ö×Ö·û´®£¬µ«ÊÇÈç¹ûǰһ¸öµ¥Ôª¸ñµÄÄÚÈÝÊÇÊý×Ö£¬±ÈÈçÊÇ¡°1¡±£¬ºóÒ»¸öµ¥Ôª¸ñµÄÊÂ×Ö·û´®£¬¾Í»á±¨´íunsupported operand type(s) for +=: 'float' and 'unicode'¡£def GetSection(index):
    section = sheet.cell_value(index,6)
    section += sheet.cell_value(index,8)
    return section
Èç¹ûÔÚ ¡°+=¡± ²Ù×÷Ç°Ãæ¼ÓÒ»¾ä str(section)
Óֻᱨ´íascii' codec can't encode character u'\u5168' in position 0: ordinal not in range(128)

ÇëÎÊÈçºÎ½â¾ö
ÀûÓÃunicode À´Ç¿ÖÆ×ª³É×Ö·û´®ÊÔÊÔ

section += unicode(sheet.cell_value(index,8))

ËäÈ»PythonÊǶ¯Ì¬ÓïÑÔ£¬µ«PythonÖеĶÔÏóÊÇÇ¿ÀàÐ͵ģ¬int Óë strÐ͵ĶÔÏóµ±È»²»ÄÜÌí¼Ó¡£



return ('%s%d' %(sheet.cell_value(index,6),sheet.cell_value(index,8)))
Õâ¸ö¿ÉÒÔ²»

Õâ¸öÓ¦¸Ã¿ÉÒÔ°É¡£²»¹ý£¬Èç¹û±àÂë²»¶ÔµÄ»°£¬»¹ÊÇ»á³öÏÖÂÒÂëµÄ¡£

ѧϰ....

³ÌÐòÖбàÂëҪͳһŶ

²»È»ÒÔºóºÜÂé·³µÄ

ÕâÊǸö±àÂëÎÊÌ⣬EXCELÀï×Ö·û´®¶¼ÊÇUNICODE£¬Êý×Ö¾ÍÊÇÊýÖµÀàÐÍ£¬Á½¸ö±äÁ¿Ïà¼Ó֮ǰ£¬½«ÊýÖµÀàÐÍÇ¿ÖÆ×ª»»ÎªUNICODEÀàÐͼ´¿É£¬¿´ÏÂÏà¹ØµÄ×ÊÁϾÍÐÐÁË

def InsertCode5(cursor,code,address,section):
    t = (code,address,section,)
    cursor.execute('insert into TBL_CODE_5 values (?,?,?)', t)

½â決ÁË£¬謝謝´ó¼ÒÖ§³Ö


Ïà¹ØÎÊ´ð£º

IIS 7 python 2.6 cgi ÎļþÉÏ´«ÎÊÌâ

ÎÒÿ´ÎÉÏ´«µÄÎļþ¶Áµ½µÄÊý¾Ý¶¼²»ÕýÈ·¡£2M µÄͼƬ¶ÁµÃ10¶àK ¡£¡£ÄÄλ´óÏÀ¿ÉÒÔ°ï°ïÎÒ°¡¡£
#!D:\ProgrammerTools\python26\python.exe
#encoding=utf-8
import cgitb
import os
cgitb.enable()
import cgi,urllib ......

pythonÔõôprint 'hello world'

´ó¼ÒºÃ£¬ÎÒÊÇÒ»¸öÐÂÊÖ£¬¸Õ¿ªÊ¼Ñ§python£¬µ«ÊǸտªÊ¼µÄhelloworld¶¼Ã»·¨´òÓ¡£¬ÈÃÎÒºÜÎÞÄΡ£
ÎÒµÄpython°²×°Â·¾¶Îªf:\python31¡£ÔÚpathÖÐÒ²ÉèÖöÔÁË£¬ÔÚwindowsÏÂÔËÐÐÊÇÕâÑùÏÔʾµÄ£¬Ï£Íû¸÷λǰ±²Ö¸µãһϡ£Ð»Ð»
Pyth ......

¶®pythonµÄjava¸ßÊÖÇë½Ì - Java / Java SE

ÇëÎʸßÊÖ£¬pythonÀïµÄpopenÀàËÆjavaÀïµÄÄĸöÀà»òÕß·½·¨ÄØ£¿£¿ÁíÍâjython¿ª·¢java¸ÃÈçºÎʹÓÃjythonÄØ£¿£¿
1.¿ÉÄܺÍjavaÀïµÄRuntime.getRuntime().exec£¨"ϵͳÃüÁî"£©; Æô¶¯½ø³Ì
2.eclipseÏÂÔØjython ²å¼ ......

¾«ÐÄËѼ¯µÄѧϰpythonµÄ7±¾Êé

ѧϰpythonµÄ7±¾Êé
°üÀ¨6±¾chm£¬Ò»±¾pdf×ÊÁÏ
¶ÔѧϰpythonÓкܴóµÄ°ïÖú 
http://download.csdn.net/source/619791
¾«ÐÄËѼ¯£¬²»Òª»ý·Ö£¬ÄóöÀ´·ÖÏí
лл¥Ö÷£¬ÐÁ¿àÁË~



lz ×îºÃ°ÑÊéÃûºÍ¼òµ¥½éÉܼÓÉ ......

python list for Ñ­»·ÎÊÌâ

Python code:

p=[1,2,3,4,5,6]
while True:
for i in p:
if i==4:
p=[]
f=[9,8,7]
p.extend(f)
break
print i£¬',',
p. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ