Python Read Excel File

Now most of the data are stored in Excel or directly to the database, as just self-learning python small Bailai said how to read the file or a bit more ignorant, now Python read the Excel file to do some sorting:

#Coding=utf-8#cmd to install the XLRD librarypip Install xlrdImportxlrd#file path, use/not \File_path = R'c:/users/mingli.zhao/desktop/seven days. xlsx'#Chinese transcoding#File_path = File_path.decode (' utf-8 ')#Get Datadata =Xlrd.open_workbook (File_path)#Get SheetTable = Data.sheet_by_name ('Sheet1')#get total number of rowsnrows =table.nrows#get total number of columnsNcols =Table.ncols#gets the value of the first rowTable.row_values (1)#get the numeric value of the first columnTable.col_values (1)#gets the value of the first column cell in the second rowCell_value = Table.cell (1,0). Value

Python Read Excel File