Trying to open an excel using a python code

Question

HI am trying to open an excel using python codes on windows (python version is 3.6.10)

I used codes from the link Running an Excel macro via Python?

import win32com.client as wincl

excel_macro = wincl.DispatchEx("Excel.application")
excel_path = os.path.expanduser("Valuation.xlsm")
workbook = excel_macro.Workbooks.Open(Filename = excel_path, ReadOnly =1)

but the excel doesn't open at all, and I don't get any errors either!

if however I run the rest of the code to run the vba macro it does work fine (but the file still doesn't open)

excel_macro.Application.Run("Macro1")
excel_macro.Application.Quit()
del excel_macro

Question is, how do I simply open the excel file using python?

Parfait · Accepted Answer · 2020-05-02 04:07:40Z

0

Simply make the Excel application visible. Without setting this Application.Visible property to True, the application runs in background and be sure not to call Quit. And of course with any API integration, be sure to wrap in try/except:

import win32com.client as wincl

excel_path = os.path.expanduser("Valuation.xlsm")

try:
    excel_app = wincl.DispatchEx("Excel.application")
    workbook = excel_app.Workbooks.Open(Filename = excel_path, ReadOnly =1)

    # RUN PROCESSING
    excel_app.Run("Macro1")

    # LAUNCH EXCEL VISIBLY TO SCREEN
    excel_app.Visible = True

except Exception as e:
    print(e)

finally:
    workbook = None; excel_app = None
    del workbook; del excel_app

edited May 2, 2020 at 4:07

answered Apr 30, 2020 at 19:38

Parfait

108k19 gold badges103 silver badges138 bronze badges

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

1 Comment

user13412850 Over a year ago

perfect! that was helpful.

kavi Raj · Accepted Answer · 2020-04-30 18:13:58Z

0

import os os.system("start EXCEL.EXE dummyfile.xlsx")

answered Apr 30, 2020 at 18:13

kavi Raj

2212 silver badges10 bronze badges

Comments

m_chera · Accepted Answer · 2020-04-30 18:22:53Z

0

Really simple way to open excel file saving the structure is using pandas

import pandas as pd
df = pd.read_excel(excel_path)

answered Apr 30, 2020 at 18:22

m_chera

113 bronze badges

Collectives™ on Stack Overflow

Trying to open an excel using a python code

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related