Attachment is superior in gui, for python program
I am writing a python (3) program that will only work on windows. The program must have a GUI that contains part of its window of the embedded excel workbook (not just its data). Is there a way to do this using wxPython / PyQt / other?
If not, I found a way to do it in C # , so I thought about writing a GUI in C # and connecting it to python using COM. Can I use IronPython to make the connection easier? What are the pros and cons of using a COM version using IronPython?
thanks in advance
source to share
One way would be to enable the web browser (QWebView) in the gui and then point it to Excel Services. The main problem here, and there are quite a few, is that you still have to use something like xlwt to manage the data. Unless you have a complicated book (with macros, etc.), it might be easier to just do something like this with xlwt and xlrd:
value_1 = str(sheet.cell_value(sel,4)) self.lineEdit.setText(value_1)
You can use labels to add column and row names, line values, and sheet values. With a little ctrl + v action (or perhaps "foo for me"), it doesn't take as long as you might think.
source to share