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

1 answer

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))


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.



All Articles