Question

我试图学习一些on子,我想用 win子与使用双赢模块的前哨进行互动。我在Wiki

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”)。数值=(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

如果I m超声望......,则会 Thanks。

Answer 1

http://www.softimageblog.com/archives/11“rel=“nofollow”>this blog 。从声音看,你不想与 Softimage 。你们只想走这条路。

另外,如果你在2007年或以后与Excel公司合作,你希望写到<条码>xlsx<>/code>文档中,因为<条码>外壳.Application将供你使用。

这里还有经过这些修改的相同的样本代码。

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

Answer 2

就此:

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

您正在尝试改写<代码>。 SIFilter(None, c.siObjectFilter) in to a string. 您没有界定“<代码>Application>。我没有操作该守则,但我认为,如果你写到<条码>excel.SIFilter(None, c.siObjectFilter)

友情链接