代碼

import xlrdimport os from prettytable import PrettyTableimport pandas#創(chuàng)建一個Excel表類class Excel(object): def __init__(self, path): self.path = path //路徑要加上文件名 #讀取Excel內全部數據 參數sname是sheet頁名字 def read_all_data(self, sname): workbook = xlrd.open_workbook(self.path) content = workbook.sheet_by_name(sname) # ord_list=[] ord_list = PrettyTable() for rownum in range(content.nrows): ord_list.add_row(content.row_values(rownum)) # ord_list.append(content.row_values(rownum)) #返回的類型是一個list return ord_listif __name__ == '__main__': path = input('-->>>Enter your path: ')xl = pandas.ExcelFile(path)sheetsname = xl.sheet_namesprint('all your excel sheetsname: ' + str(sheetsname))# print(sheetsname)sheetname = input('-->>>Enter your excel sheet name: ')path1 = Excel(path)alldata = path1.read_all_data(sname=sheetname)# alldata = PrettyTable(alldata)print(alldata)

演示

加了prettytable美化顯示

以上就是python在CMD界面讀取excel所有數據的示例的詳細內容，更多關于python讀取excel數據的資料請關注好吧啦網其它相關文章！