Is there a way to load an existing workbook to the current one? like pd.read_excel?
Hi and welcome!
The recommended method is to use Power Query to load the data into the current file, then you can reference the query by name (i.e. without having loaded it to a spreadsheet) or you can load the query to the spreadsheet and then reference the Table.
You can read more details about how to do this on the Microsoft Support site.
Use Power Query to import data for Python in Excel
Please let me know if you are able to get this working. If you need further help, we’ll do our best to get you going.