python：xlrd 读取 Excel文件，显示在 tkinterTable 表格中

pip install xlrd

xlrd-1.2.0-py2.py3-none-any.whl (103 kB)

摘要: Library for developers to extract data from Microsoft Excel (tm) spreadsheet files

pip install tkinterTable

tkintertable-1.3.3.tar.gz (58 kB)

摘要: Extendable table class for Tkinter

源代码链接：https://github.com/dmnfarrell/tkintertable
教程链接：https://github.com/dmnfarrell/tkintertable/wiki/Usage

编写 tk_table_xlsx.py 如下

# -*- coding: utf-8 -*-
""" xlrd 读取 Excel文件，显示在 tkinterTable 表格中"""
import os
import sys
import datetime
import tkinter as tk
from tkinter import filedialog
import xlrd
from tkintertable import TableCanvas, TableModelroot = tk.Tk()
filetypes = [('Excel file','.xlsx')]
file1 = filedialog.askopenfilename(initialdir=".", filetypes=filetypes)
if file1 == '':print('usage: python tk_table_xlsx.py ')sys.exit(1)if not os.path.exists(file1):print(f'Error: {file1} not found.')sys.exit(2)book = xlrd.open_workbook(file1)
sheet = book.sheets()[0] # 取Sheet1
# 通过名称获取
#sheet = book.sheet_by_name(sheet_name)
nrows = sheet.nrows  # 获取sheet中的有效行数
if nrows > 10000:print(f" 行数: {nrows} > 10000 !")nrows = 10000
ncols = sheet.ncols  # 获取sheet中的有效列数
if ncols > 26:print(f" 列数: {ncols} > 26 !")ncols = 26data = {}
cols = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
#单元类型cell_type: 0.empty, 1.string, 2.number, 3.date, 4.boolean, 5.error, 6.blank
for i in range(0, nrows):rows = {}for j in range(0, ncols):v = sheet.cell_value(i,j)t = sheet.cell_type(i,j)if t ==0:rows[cols[j]] = ''elif t ==1:rows[cols[j]] = velif t ==2:if v%1 ==0:rows[cols[j]] = "%d" % velse:rows[cols[j]] = "%.4f" % velif t ==3:date_tuple = xlrd.xldate_as_tuple(v, book.datemode)date_v = datetime.date(*date_tuple[:3])rows[cols[j]] = date_v.strftime('%Y-%m-%d')else:rows[cols[j]] = str(v)data[str(i+1)] = rows
#print(data)#root = tk.Tk()
root.title(file1)
root.geometry("800x600+200+100")
frame = tk.Frame(root)
frame.pack(fill=tk.BOTH, expand=1)print(f"nrows:{nrows} ncols:{ncols}")
model = TableModel(rows=nrows, columns=ncols)
table = TableCanvas(frame, model=model, data=data)
table.show()root.mainloop()

运行 python tk_table_xlsx.py test1.xlsx

参考：python实现读取excel表格详解方法

参考：使用tkintertable控件建立tkinter的表格