废话不多说,直接开始干活!
安装相应库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
# f