Python's Excel operations

#coding: utf-8__author__ = ' similarface ' Import xlrdbook=xlrd.open_workbook ('/users/similarface/downloads/ 0808-10 x et/0808-10 et.xlsx ') #遍历所有的sheetsfor sheet in Book.sheets ():    print (sheet.name)    #print Sheetbook = Xlrd.open_workbook ('/users/similarface/downloads/0808-10 et/0808-10 x et.xlsx ') #获取指定的sheetsheet = Book.sheet_by_ Name (' Sheet1 ') #获取sheet的行数print sheet.nrows# traverse all line numbers for the sheet for I in range (sheet.nrows):    print i# traverse all rows of sheet for I in Range (sheet.nrows):    print sheet.row_values (i) #遍历所以的行, for I in Range (sheet.nrows):    row=sheet.row_values (i)    #遍历行的所有列的值 for    cell in row:        print cell

　　

Python's Excel operations