Python data export to excel

Hi,

I’m currently working on a large valuation model using Workspace and Excel. The issue I’m facing is that Excel is struggling to handle the volume of information, causing it to lag frequently. After doing some research, I realized that switching to Python could help solve this problem.

I would like to know if it’s possible to link Python with Excel. Specifically, I want to export the results from Python into a particular worksheet of the Excel workbook, placing the data in specific cells within an Excel table (See the picture below for my table sample). This way, the database sheet in my Excel file wouldn’t be as heavy, as all the formulas and calculations would be done in Python, with only the resulting numbers appearing in the database sheet.

Any help or guidance on how to set this up would be greatly appreciated!

*See the picture below.

Thanks.

Mathieu

For you to follow up @Punal Bhavsar