Creating a GUI with PyQt5 to interact with an Excel file, trouble loading sheets names and subject list into...
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.
python excel user-interface combobox pyqt
edited Nov 20 '18 at 18:06
eyllanesc
78.9k103256
asked Nov 20 '18 at 5:42
Anna ApplegateAnna Applegate
43
add a comment |
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.
python excel user-interface combobox pyqt
edited Nov 20 '18 at 18:06
eyllanesc
78.9k103256
asked Nov 20 '18 at 5:42
Anna ApplegateAnna Applegate
43
what is sheetsBox insheetsBox.move(50, 75)?In addition to that I have corrected a typo, is there an error in your original code?
– eyllanesc
Nov 20 '18 at 18:02
add a comment |
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.
python excel user-interface combobox pyqt
edited Nov 20 '18 at 18:06
eyllanesc
78.9k103256
asked Nov 20 '18 at 5:42
Anna ApplegateAnna Applegate
43
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.
python excel user-interface combobox pyqt
python excel user-interface combobox pyqt
edited Nov 20 '18 at 18:06
eyllanesc
78.9k103256
asked Nov 20 '18 at 5:42
Anna ApplegateAnna Applegate
43
edited Nov 20 '18 at 18:06
eyllanesc
78.9k103256
asked Nov 20 '18 at 5:42
Anna ApplegateAnna Applegate
43
edited Nov 20 '18 at 18:06
eyllanesc
78.9k103256
edited Nov 20 '18 at 18:06
eyllanesc
78.9k103256
edited Nov 20 '18 at 18:06
eyllanesc
78.9k103256
78.9k103256
asked Nov 20 '18 at 5:42
Anna ApplegateAnna Applegate
43
asked Nov 20 '18 at 5:42
Anna ApplegateAnna Applegate
43
asked Nov 20 '18 at 5:42
Anna ApplegateAnna Applegate
43
43
what is sheetsBox insheetsBox.move(50, 75)?In addition to that I have corrected a typo, is there an error in your original code?
– eyllanesc
Nov 20 '18 at 18:02
add a comment |
what is sheetsBox insheetsBox.move(50, 75)?In addition to that I have corrected a typo, is there an error in your original code?
– eyllanesc
Nov 20 '18 at 18:02
what is sheetsBox in
sheetsBox.move(50, 75)?In addition to that I have corrected a typo, is there an error in your original code?– eyllanesc
Nov 20 '18 at 18:02
what is sheetsBox in
sheetsBox.move(50, 75)?In addition to that I have corrected a typo, is there an error in your original code?– eyllanesc
Nov 20 '18 at 18:02
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53386896%2fcreating-a-gui-with-pyqt5-to-interact-with-an-excel-file-trouble-loading-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53386896%2fcreating-a-gui-with-pyqt5-to-interact-with-an-excel-file-trouble-loading-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
what is sheetsBox in
sheetsBox.move(50, 75)?In addition to that I have corrected a typo, is there an error in your original code?– eyllanesc
Nov 20 '18 at 18:02