pyqt5：pandas 读取 Excel文件或 .etx 电子表格文件，并显示

原创

已于 2023-10-11 21:12:02 修改 · 1.7k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#pandas #pyqt5 #excel

于 2023-10-10 21:40:16 首次发布

pip install pandas ;

pip install pyqt5;
pip install pyqt5-tools;

编写 pyqt5_read_etx.py 如下

# -*- coding: utf-8 -*-
""" pandas 读取 Excel文件或 .etx 电子表格文件，显示在 QTableWidget 中 """
import os
import sys
import numpy as np
import pandas as pd
from PyQt5.QtWidgets import QApplication, QMainWindow, QFileDialog, QMessageBox
from PyQt5.QtWidgets import QTableWidget, QTableWidgetItem
from PyQt5.uic import loadUi

class EtxReader(QMainWindow):

    def __init__(self):
        super(EtxReader, self).__init__()
        loadUi("readEtx.ui", self)  # Load the UI file
        self.file_path = ""  # To store the file path
        self.df = pd.DataFrame()  # To store the etx data
        self.browse_btn.clicked.connect(self.browse_file)
        self.read_btn.clicked.connect(self.read_etx)

    def browse_file(self):
        """ Open a