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 simulati

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 s

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 ca

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

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 the