Start Excel inside Power BI using Python

[dageci]

Hello,

now that Power BI supports Python can something like this be done:

Start Excel inside Power BI using Python?

Something like this:

import win32com.client as win32

excel = win32.Dispatch("Excel.Application")
excel.Visible = True
wb = excel.Workbooks.Add()

[v-danhe-msft]

Hi @dageci,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft]

Hi @dageci,

Based on my test, the Python connector will import the DataFrame variables defined in your script.

If you want to import excel files, you can use panda's read_excel function:

dateset=pd.read_excel('File.xlsx', sheetname='Sheet1')

Regards,

Danile He