Python+selenium Excel Chinese read fill to Web page

Because of my technical level, grinding haw for a long time finally came out, in the finishing time thinking, Maybe I was too concerned about the printed list, list can not display chinese, I thought I was always wrong.

Attach form part

#Coding:utf-8ImportxlrddefOpen_excel (file):Try: Data=Xlrd.open_workbook (file)returnDataexceptException as E:Print(str (e))defExcel_table_byindex (file,colnameindex = 0,by_index=0): Data=open_excel (file) Table=data.sheets () [by_index] nrows=table.nrows#LineColnames =table.row_values (colnameindex)#Column Contentslist=[]     forRowNuminchRange (1, nrows): Row=table.row_values (rownum)ifRow:app= {}             forIinchRange (len (colnames)): s=row[i]
                #if isinstance (s, unicode):                #s = Row[i].encode ("utf-8")                Print "each one", S app[colnames[i]]=s List.append (app)PrintRowPrintListreturnListlistdata=excel_table_byindex ("E:\py\\alwaystry\sign_up.xlsx", 0)

Added at the beginning  , it is already in the Utf-8 format, so can handle chinese.

Print  " each"

Row prints out is [u ' \u4e8c\u6bdba ',...

The list print is [{u ' nickname ': u ' \u4e8c\u6bdba ' ..., all rows of Data.
I only saw the original Unicode encoding that he could not print chinese, in fact, the list can not be Displayed. It's still too tender to Come.

In the long quest, I know the STR and Unicode

(i look at the URL that feels good http://wklken.me/posts/2013/08/31/python-extra-coding-intro.html)

anyway, Yes.

Str-decode (' STR encoded format '), Unicode

Unicode-encode (' you want to format ') str

To view the encoding format, print chardet.detect (listdata[i][' nickname ') to determine the character encoding format of course or import Chardet

He sometimes reported valueerror:expected a bytes object, not a Unicode object wrong, and that would know what encoding format he Was.

still, the direct printing format: print type (listdata[i][' realname ')) printout <type ' Unicode ', which means that someone else is already unicode, Then you just have to delete the Chardet.detect ().

UTF-8 is one of the ways Unicode is Implemented/utf8 is an encoding of the Unicode character set. ( When I took notes, I thought the two words were quite understandable.)

if, very careless, you went to the same situation as I did, early to the encode, is commented out of the two Sentences.

Tip unicodedecodeerror: ' UTF8 ' codec can ' t decode byte 0xe4 in position 0:unexpected end of data and so on, may wish to try Decode. If the Drop-down box matches the situation, you can first decode again encode try, the following line of code Last.

The overall approximate code is as follows

#Enter URLAddress = Raw_input ('Enter location:')ifLen (address) < 1:    Print "Error"URL=Address#put your configuration fileProfile_dir = R"C:\Users\Administrator\AppData\Roaming\Mozilla\Firefox\Profiles\5cmfbcqp.default" profile=Webdriver. Firefoxprofile (profile_dir) Driver=Webdriver. Firefox (profile)#Open ExceldefOpen_excel ():Try: Data=Xlrd.open_workbook (file)returnDataexceptException as E:Print(str (e))defExcel_table_byindex (file,colnameindex = 0,by_index=0): Data=open_excel (file) Table=data.sheets () [by_index] nrows=table.nrows#LineColnames =table.row_values (colnameindex)#Column Contentslist=[]     forRowNuminchRange (1, nrows): Row=table.row_values (rownum)ifRow:app= {}             forIinchRange (len (colnames)):s =row[i]ifisinstance (s, unicode): s= Row[i].encode ("Utf-8")                Printsapp[colnames[i]] =s List.append (app)Print(list)returnList#You can also use the if else to determine whether there is a CSSdefjudgewithcss (css):Try: Driver.find_element_by_css_selector (css)except:        returnFalsereturnTruelistdata=excel_table_byindex ("E:\sign_up.xlsx", 0)if(len (listdata) <0):assert0,u"Data Exceptions" forIinchrange (0, len (listdata)): driver.get (url)#nickname, This is an input    ifJUDGEWITHCSS ("#nickname") ==True:nickname= driver.find_element_by_id ("Nickname") nickname.clear ()PrintChardet.detect (listdata[i]['Nickname']) Nickname.send_keys (listdata[i]['Nickname'].decode ("Utf-8"))    #Blood type, This is a select    ifJUDGEWITHCSS ("#blood") ==True:blood= driver.find_element_by_id ("Blood")        #The following 3 types can also be judged by the format        #print isinstance (listdata[i][' blood '), unicode)        #print isinstance (listdata[i][' blood '), str)        #print type (listdata[i][' blood ')        PrintChardet.detect (listdata[i]['Blood']) Select (blood). select_by_value (listdata[i]['Blood'].decode ("windows-1252"). Encode ("windows-1252"))

Python+selenium Excel Chinese read fill to Web page