Re: How to create an Excel app that runs Python?

2020-03-28 Thread Paolo G. Cantore
Am 25.03.20 um 15:21 schrieb farayao...@gmail.com: Hello Paolo, Thanks for your reply, indeed now I'm thinking on building a web app, do you have any suggestions for this? I am thinking of using Tkinter, the method that you describe using HTML is also using Javascript? Kind Regards Felipe

Re: How to create an Excel app that runs Python?

2020-03-25 Thread Souvik Dutta
It is better than tkinter and also kivy in some way. It uses pure oops concept so it should be more intuitive and easy to set up. I learnt it in 7 days. Also it has still better community support at p...@riverbankcomputing.com On Wed, Mar 25, 2020, 7:59 PM wrote: > On Tuesday, 24 March 2020

Re: How to create an Excel app that runs Python?

2020-03-25 Thread farayao . ds
On Tuesday, 24 March 2020 16:26:53 UTC, oliver wrote: > Use the win32com library to interact with Excel via COM. Although the > learning curve is a little steeper it's not too bad and works great. I used > this technique to control ARENA with Python through its COM API to run a > whack of

Re: How to create an Excel app that runs Python?

2020-03-25 Thread farayao . ds
On Wednesday, 25 March 2020 12:13:58 UTC, Gisle Vanem wrote: > Grant Edwards wrote: > > > On 2020-03-24, oliver wrote: > > > >> Use the win32com library to interact with Excel via COM. > > > > Huh? I thought that the users have no way of running a local Python > > app. > > Maybe creating a

Re: How to create an Excel app that runs Python?

2020-03-25 Thread farayao . ds
On Tuesday, 24 March 2020 16:12:00 UTC, Souvik Dutta wrote: > You might try pyqt5 if you want to make a custom GUI and also if you have > tha time to do so. > > On Tue, Mar 24, 2020, 4:45 PM wrote: > > > I have the following scenario: > > > > I have created lots of python files that I use to

Re: How to create an Excel app that runs Python?

2020-03-25 Thread farayao . ds
On Tuesday, 24 March 2020 17:38:11 UTC, Paolo G. Cantore wrote: > On Tue, Mar 24, 2020, 4:45 PM wrote: > > > I have the following scenario: > > > > I have created lots of python files that I use to calculate a Cashflow > > model, when I run these files I get a beautiful pandas DataFrame that >

Re: How to create an Excel app that runs Python?

2020-03-25 Thread Gisle Vanem
Grant Edwards wrote: On 2020-03-24, oliver wrote: Use the win32com library to interact with Excel via COM. Huh? I thought that the users have no way of running a local Python app. Maybe creating a self-contained .exe using PyInstaller? For me, this: pyinstaller.exe --noconfirm

Re: How to create an Excel app that runs Python?

2020-03-24 Thread Grant Edwards
On 2020-03-24, oliver wrote: > Use the win32com library to interact with Excel via COM. Huh? I thought that the users have no way of running a local Python app. -- Grant -- https://mail.python.org/mailman/listinfo/python-list

Re: How to create an Excel app that runs Python?

2020-03-24 Thread Paolo G. Cantore
On Tue, Mar 24, 2020, 4:45 PM wrote: I have the following scenario: I have created lots of python files that I use to calculate a Cashflow model, when I run these files I get a beautiful pandas DataFrame that contains my final model. My mission is to show this table to the rest of the

Re: How to create an Excel app that runs Python?

2020-03-24 Thread oliver
Use the win32com library to interact with Excel via COM. Although the learning curve is a little steeper it's not too bad and works great. I used this technique to control ARENA with Python through its COM API to run a whack of simulations (1000-1), then used python to gather the results, and

Re: How to create an Excel app that runs Python?

2020-03-24 Thread Souvik Dutta
You might try pyqt5 if you want to make a custom GUI and also if you have tha time to do so. On Tue, Mar 24, 2020, 4:45 PM wrote: > I have the following scenario: > > I have created lots of python files that I use to calculate a Cashflow > model, when I run these files I get a beautiful pandas

How to create an Excel app that runs Python?

2020-03-24 Thread farayao . ds
I have the following scenario: I have created lots of python files that I use to calculate a Cashflow model, when I run these files I get a beautiful pandas DataFrame that contains my final model. My mission is to show this table to the rest of the company in a friendly format ("Excel") and