pyqt创建excel日期报表html,PyQt：如何对excel文件的QTableView列进行排序（字符串、数字和日期类型）...

现在我计划对excel文件进行同样的排序

这是我的代码：self.Upload = QtGui.QPushButton()

self.Upload.clicked.connect(self.showOpenDialog)

self.Table = QtGui.QPushButton()

self.table.clicked.connect(self.LoadTable)

def showOpenDialog(self):

fileName = QtGui.QFileDialog.getOpenFileName(self, 'Open file', '/home')

if (".xls" or ".xml" or ".xlsx" or ".xlsm") in fileName:

with open(fileName, 'rb') as drate:

self.Datas = pd.read_excel(drate, index_col=0)

self.Loaded_File.clear()

self.Loaded_File.append(fileName)

colll = self.Datas.dtypes.index

col_names = np.array(colll)

def LoadTable(self):

tab_table_view = QtGui.QWidget()

self.Tab.insertTab(0, tab_table_view, self.File_Name)

self.tableView = QtGui.QTableView(tab_table_view)

self.tableView.setGeometry(QtCore.QRect(0, 0, 721, 571))

self.model = QtGui.QStandardItemModel(self)

file_name_temp = self.File_Name

self.tableView.setModel(self.model)

colll = self.Datas.dtypes.index

col_names = np.array(colll)

col_names = np.insert(col_names, 0, self.Datas.index.name)

self.model.setHorizontalHeaderLabels(col_names)

self.tableView.hideRow(0)

self.tableView.setSortingEnabled(True)

if (".xls" or ".xml" or ".xlsx" or ".xlsm") in self.File_Name:

from itertools import chain

ii = 1

book = xlrd.open_workbook(self.File_Name)

sheet = book.sheet_by_index(0)

num_col = len(self.Datas.columns)

num_row = len(self.Datas)

print(num_col,num_row)

self.Matrix = [[0 for x in range(num_col+1)] for y in range(num_row)]

for i in range(num_row):

self.Matrix[i][0]=self.Datas.index.values[i]

for j in range(num_col):

self.Matrix[i][j+1] = self.Datas.iat[i,j]

print(self.Matrix)

for i in range(num_row):

items = []

for j in range(num_col):

field = self.Matrix[i][j]

item = QtGui.QStandardItem(field)

for numtype in (int, float):

try:

data = numtype(field)

break

except (ValueError, OverflowError):

pass

else:

print('Not a number: %r' % field)

data = field

item.setData(data, QtCore.Qt.UserRole)

items.append(item)

self.model.appendRow(items)

输出将是：

^{pr2}$

如果文件中的数据类型是str(最多为“None”)，并且当第一个int或float出现时，它会生成一些重载调用。在

请有人帮帮我。在