python 读取excel表格数据

废话不多说，直接开始干活！

安装相应库

pip install xlrd

需要数据

直接上代码

# coding=utf-8 from tkinter import filedialog import tkinter.messagebox import xlrd from tkinter.ttk import Label from tkinter import * import urllib3
urllib3.disable_warnings() def main(): def selectExcelfile(): sfname = filedialog.askopenfilename(title='选择Excel文件', filetypes=[('Excel', '*.xlsx'), ('All Files', '*')]) print(sfname) doProcess(sfname) text1.insert(INSERT, sfname) def doProcess(sfname=None): fname = sfname
        bk = xlrd.open_workbook(fname) shxrange = range(bk.nsheets) sh = bk.sheet_by_name("Sheet1") da = sh.nrows
        ncols = sh.ncols # for ii in range(0,ncols): #     # print(ii) # #     # rows = sh.row_values(1)[ii] #     # print(int(rows)) #     if ii == 0: rows = sh.row_values(0) # print(rows) for ii in range(0, ncols): for i in range(1,da): rowss = sh.row_values(i) # print(rowss[0]) if rowss[0]!='': print('名称:',rows[ii],"商品id:",'%s'%(int(rowss[ii]))) tkinter.messagebox.showinfo('提示', '处理Excel文件的添加成功。') # 初始化 root = Tk() # 设置窗体标题 root.title('Excel 数据上传') # 设置窗口大小和位置 root.geometry('500x300+570+200') label1 = Label(root, text='请选择文件:') text1 = Entry(root, bg='white', width=45) button1 = Button(root, text='浏览', width=8, command=selectExcelfile) label1.pack() text1.pack() button1.pack() label1.place(x=30, y=30) text1.place(x=100, y=30) button1.place(x=390, y=26) root.mainloop() if __name__ == "__main__": main() 

效果图

需要特别注意读取excel数据行，列根据需求而定！

本文地址：https://blog.csdn.net/weixin_37254196/article/details/108233100