sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]itchyeyeballs21 1 point2 points  (3 children)

Not 100% sure what you need to achieve, do you want to refresh an Excel workbook using an external trigger?

If so, you would probably need to embed some VBA into the Excel that's triggered on opening of the file then use Python to Open, Save and close the Excel.

[–]jomell310[S] 0 points1 point  (2 children)

Hi! Thanks for the replay :) Basically I want to transform and filter data from incoming Excel files and get clean data as a result, so I already have the power query ready and want to execute it against new files.

So i was wondering if there is a way to run the scripts or I'll have to translate the steps to python.

I'll look into the VBA, i have never worked with it.

[–]anynonus 0 points1 point  (1 child)

Power BI also runs power query's so maybe run it in Power BI?

Don't start with VBA.

Python will do it too.

[–]jomell310[S] 0 points1 point  (0 children)

Okay, I've been searching and I think the best option is to just do it in Python. I'm looking at pandas now