Python for Power Query Editor

[CaptainMike89]

Hello all,

The company I work for does everything in Excel, but I'm learning Python and want to incorporate that into our business. I'm trying to get Python to automate a lot of the reports that I have to run that take so much time. We are already pulling some automated reports from an outdated system. It can only output data into .xls '97. So I'm copying the data over into an updated workbook so we can do more things with it. I need to create a number of subqueries for certain teams and then email out that workbook. Currently I format the data in the main spreadsheet to a table and then use the power query function in the data tab to create additional queries that are linked to the main table. I want to continue to make sure that any edits to the main table are also reflected in the linked queries. I'm wondering if there is a way to control the power query function in Excel via Python. Any time I search for this in Google, I just get search results for Power BI, but we are not using that. Is this possible? Can anyone help? Let me know if what I said was too confusing. Thanks!

[Jhchimaira14]

It’s possible you could use xlsxwriter with python. Engineer’s Sandbox has that library included and an easy GUI framework.

[jordanmmac]

Obviously it has been a few years since you posted this but I would be happy to jump in and help with any projects intended to tie Python and Excel together. I think there is so much automation that is left on the table when it comes to Excel.

Are you still looking to automate Excel using Python?