Python Forum
How to create an Excel app that runs Python?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to create an Excel app that runs Python?
#1
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 they need to be able to generate this table themselves from Excel, using the Python script I created ("the idea is that they open an excel file that has some type of dashboard and a form that they need to fill in, once they fill it in and press "Go" or "Run" or something like that, these parameters will be sent to the Python script to generate this final pandas DataFrame. Finally this DataFrame needs to be displayed/pasted in the Excel sheet that they initially opened)


The problems:

The company needs to be able to run this model, but the users, apart from me, use Excel and they can't open up a Jupyter notebook or VSC to run the code. They can't even install Python on their machines (or at least that is not ideal)


My Attempts:

I am currently using "xlwings" to run Python within Excel, although it requires that the user has Python and xlwings installed and has added the xlwings "Addin", which is not an ideal solution at all.

I am thinking about using Dash, I don't know if it is what I need since I haven't looked into it that much yet (I have been trying to make it work on xlwings first)

If you have any suggestions on how to do this, I would really appreciate that.

Thank you
Reply
#2
Have you managed to resolve your issue? Just wondering what you ended up doing as I am trying to find a similar approach.
Reply
#3
The open pyxl module allows Python programs to read and edit Excel spreadsheet files. Both LibreOffice Calc and Open Office Calc work with Excel. xlsx file format for spreadsheets, which means that the open pyxl module can also work on spreadsheets from these applications.
Reply
#4
Did you look ALt+F11 combination and open Visual Basic Code... This solve your problem instantly...
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How to do 100 runs simulation based on the current codes? dududada 6 902 Sep-03-2023, 01:43 PM
Last Post: deanhystad
  Create Excel Line Chart Programmatically dee 3 1,143 Dec-30-2022, 08:44 PM
Last Post: dee
  Another program runs bho68 7 1,143 Nov-08-2022, 08:16 PM
Last Post: bho68
  Importing a function from another file runs the old lines also dedesssse 6 2,479 Jul-06-2021, 07:04 PM
Last Post: deanhystad
  Python Matplotlib: Create chart for every 4 columns in Excel file JaneTan 2 2,733 Feb-28-2021, 05:02 AM
Last Post: JaneTan
  how to change the range of read CSV file every time python file runs greenpine 6 4,379 Dec-08-2020, 10:11 PM
Last Post: greenpine
  Create new Excel instead of update certain sheet Pietertl 1 1,960 Sep-17-2020, 07:04 AM
Last Post: Pietertl
  Runs perfect in Python but fails to print last statement when converted to .exe. Help sunil422 3 2,747 Aug-13-2020, 01:22 PM
Last Post: deanhystad
  Python Program Runs in Pycharm but not in Terminal Vbhardwaj2383 2 3,242 Apr-06-2020, 04:41 PM
Last Post: Vbhardwaj2383
  How to execute code WHILE a function runs t4keheart 4 2,594 Jan-27-2020, 01:47 PM
Last Post: t4keheart

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020