Python com between python and excel

Question

I'm trying to learn some python and I wanted for python to interact with excel using the win32 module. I found a basic example online on wiki here.

It won't work however. This is the error I get.

Traceback (most recent call last):
  File "C:/Users/Greg/Desktop/python programming/excel2.py", line 8, in <module>
    sheet.Range("A2").Value = str(Application.SIFilter(None, c.siObjectFilter))
NameError: name 'Application' is not defined

My question is what does that line DO EXACTLY and why am I getting an error?

sheet.Range("A2").Value = str(Application.SIFilter(None, c.siObjectFilter))

import win32com.client
from win32com.client import constants as c

excel = win32com.client.Dispatch("Excel.Application")
book = excel.Workbooks.Add()
sheet = book.Worksheets(1)
sheet.Range("A1").Value = "Hello World!"
sheet.Range("A2").Value = str(Application.SIFilter(None, c.siObjectFilter))
book.SaveAs("c:\simple_example.xls")

sheet = None
book = None
excel.Quit()
excel = None

Thanks sorry if I'm super noob....

Are you running it from the command line or from inside Softimage? The Application object only exists when you do the latter. — kindall
– kindall, Commented Apr 15, 2012 at 18:14

Dan Garant · Accepted Answer · 2012-04-15 18:43:31Z

3

The code you linked to looks like it's pulled straight off of this blog. From the sound of it, you're not trying to integrate with Softimage. You'll want to just take that line out.

Also, if you're working with Excel 2007 or later, you want to write to an xlsx file, because that's what Excel.Application is going to create for you.

Here's the same sample code modified with these changes.

import win32com.client

excel = win32com.client.Dispatch("Excel.Application")
book = excel.Workbooks.Add()
sheet = book.Worksheets(1)
sheet.Range("A1").Value = "Hello World!"
book.SaveAs("c:\simple_example.xlsx") # or .xls depending on version

sheet = None
book = None
excel.Quit()
excel = None

answered Apr 15, 2012 at 18:43

Dan Garant

7335 silver badges12 bronze badges

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

Comments

user850498 · Accepted Answer · 2012-04-15 18:44:31Z

0

In this line :

sheet.Range("A2").Value = str(Application.SIFilter(None, c.siObjectFilter))

you are trying to to turn Application.SIFilter(None, c.siObjectFilter) in to a string. You did not define the object called Application. I did not run the code, but I think it might work if you write excel.SIFilter(None, c.siObjectFilter). If you are just trying to learn, write something else, and you will get an excel file.

answered Apr 15, 2012 at 18:44

user850498

7271 gold badge9 silver badges22 bronze badges

Collectives™ on Stack Overflow

Python com between python and excel

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related