Is there a way to run a python script to in excel to update a cell range?

Question

I have a web scraper script in python that clicks and downloads a csv file from a website.

I would like to:

Pass a parameter from excel to trigger the python script based on user selection
trigger the download/web scraper script from Excel and then populate the cell range concerned based on the downloaded file

Welcome to other solutions other than what I have now.

The question has been asked before: 1. How to call python script on excel vba?, 2. Is there a way to call a Python code in Excel-VBA?, 3. Running a python script from VBA, 4. Call Python Script from VBA. 5. Return result from Python to Vba — Toddleson
– Toddleson, Commented May 19, 2021 at 13:44
FYI it's scraper (and scraping, scraped, scrape) not scrapper — DisappointedByUnaccountableMod
– DisappointedByUnaccountableMod, Commented May 19, 2021 at 14:28

vladislav1618 · Accepted Answer · 2021-05-19 12:43:11Z

1

Maybe your python code should read your excel spreadsheet and act upon the changes. Might want to check https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html. A more straightforward solution might exist, thou.

answered May 19, 2021 at 12:43

vladislav1618

262 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1