How to open Excel Application from Python?

Question

I'm trying to open an Excel file from Python. The code is:

import win32com.client
excelApp = win32com.client.Dispatch('Excel.Application')
book = excelApp.Open(os. getcwd() + '\Output ' + get_date() + '.csv')

but I'm getting this error: "AttributeError: Excel.Application.Open". Any idea how to fix it? Thanks!

why just not use pandas pandas.pydata.org/pandas-docs/stable/reference/api/… ? — GiovaniSalazar
– GiovaniSalazar, Commented Dec 24, 2019 at 20:07
@GiovaniSalazar I'm not trying to read it into pandas or python. I'm trying to open the Microsoft Excel application itself. — Chadee Fouad
– Chadee Fouad, Commented Dec 24, 2019 at 20:13
try this: book = excelApp.Workbooks.Open(os. getcwd() + '\Output ' + get_date() + '.csv') — Poe Dator
– Poe Dator, Commented Dec 24, 2019 at 20:21
@RuslanS. Perfect!...that worked but the Excel app was hidden so I had to use excelApp.Visible = True to see it. Thanks! :-) — Chadee Fouad
– Chadee Fouad, Commented Dec 24, 2019 at 20:28

Chadee Fouad · Accepted Answer · 2019-12-30 02:07:34Z

2

This code worked as per @RuslnS. 's recommendation:

import os
import win32com.client
excelApp = win32com.client.Dispatch('Excel.Application')
excelApp.Workbooks.Open(os.getcwd() + '\Groups.csv')
excelApp.Visible = True

This too works as per Jack Taylor's recommendation:

import subprocess
subprocess.Popen(["C:\\Program Files\\Microsoft Office\\Root\\Office16\\EXCEL.EXE", "/t", 'D:\\test.xlsx'])

edited Dec 30, 2019 at 2:07

answered Dec 24, 2019 at 20:30

Chadee Fouad

3,0192 gold badges30 silver badges34 bronze badges

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

Comments

Jack Taylor · Accepted Answer · 2019-12-24 20:44:19Z

1

According to the Microsoft Office docs, all Office programs support a /t command-line switch to open a specific file. You can use this from Python's subprocess module to open a specific file in Excel.

import subprocess

subprocess.Popen(["excel.exe", "/t", "C:\\Path\\to\\my\\spreadsheet.xlsx"])

answered Dec 24, 2019 at 20:44

Jack Taylor

6,28725 silver badges40 bronze badges

3 Comments

Chadee Fouad Over a year ago

Thanks. I've tried subprocess.Popen(["excel.exe", "/t", 'D:\\test.xlsx']) it but I'm getting [WinError 2] The system cannot find the file specified even though I'm sure hat the file exists. Did you manage to get it working?

Jack Taylor Over a year ago

You might need to specify the full path to excel.exe, depending on how your PATH environment variable is set up.

Chadee Fouad Over a year ago

Yup..that worked, thanks! :-) subprocess.Popen(["C:\\Program Files\\Microsoft Office\\Root\\Office16\\EXCEL.EXE", "/t", 'D:\\test.xlsx'])

Collectives™ on Stack Overflow

How to open Excel Application from Python?

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related