The xlwings library is a powerful Python library that allows you to interact with Excel from Python. Apply if you want to learn xlwings or know how to use xlwings library.

I want to put python functions in excell cells. Whatever the function returns is whatever excell should display on that cell.

For example I put myFunction() in cell A1.Excel call that function from my python script and return whatever value the function returns without closing and reopen.
Whenever that excel file open it also runs that python script

Only nessescary is to have it work with any function and allow you to call python function from excel cell, so you can show it working with a random hello world function or something and that’s would be the job. No need to do anything else.

Posted On: August 11, 2024 07:25 UTC
Category: Scripting & Automation
Skills:Python

Country: Canada

click to apply