Tukukkk

Goal of the app: open an excel file, allow the user to select a sheet, generate a searchable list of subjects, return specific cells from that row

Essentially, the department I work for has excel outputs that they have but don't know how to use, and I'm trying to create a simple app to return the data they need. I'm new to coding, and I've tried a lot of ways recently to build this application. I have settled on using PyQt5 to create the GUI and pandas to read the excel file.

Right now, I'm trying to use comboboxes to allow the user to select the tab and the subject, but I can't get the information from the opened file into the comboboxes.

Currently, the code for my boxes is as follows:

class MainWindow(QMainWindow):

    def __init__(self, parent=None):

        super().__init__()

        self.title = 'NU Forceplate Data'

        self.setWindowIcon(QIcon('image.png'))

        QApplication.setStyle(QStyleFactory.create('Fusion'))

        self.initUI()

        # ...



    def initUI(self):

        # ...

        self.sheetsBox()

        # ...



    def sheetsBox(self):

        self.sheetselectionbox = QComboBox(self)

        sheetsBox.move(50, 75)

        sheetsBox.activated[str].connect(self.sheets) #I still don't understand this



    def sheets(self, text):

        self.sheetselection.setText(text) #or this

    #if I don't pass on this, the kernel doesn't crash but the box won't show up



    def file_open(self): 

      import_excel_name, _ = QFileDialog.getOpenFileName(self, "Please select file:")



      if import_excel_name:

         with pd.ExcelFile(selected_file) as xls:

              sheet_tabnames = xls.sheet_names

              self.sheetselectionbox.clear()

              self.sheetselectionbox.addItems(sheet_tabnames)



    # ...



if __name__ == "__main__":

    app = QApplication(sys.argv)

    mainWin = MainWindow()

    sys.exit( app.exec_() )

I can't figure out what to to put in sheets, so I've passed on its definition.

I'm not sure if this is enough information, happy to provide more if needed. I'm not sure if this is even the best way to do this, so I'm open to any other suggestions.