[IronPython] IronPython Excel 2007 Interop on Vista - problem

[Dody Gunawinata]

Did you get the same error if you change the last code to
wbook.Worksheets[1].Name = "second worksheet"

On Tue, Mar 24, 2009 at 2:00 PM, Utini <utinimail at gmail.com> wrote:

> It appears that the default Workbook.Add always includes 3 Worksheets.
>
> 2009/3/24 Dody Gunawinata <empirebuilder at gmail.com>
>
>  Does workbook automatically generates default worksheets when you create
>> them? It looks like an array out of bound problem.
>>
>> 2009/3/24 Utini <utinimail at gmail.com>
>>
>>>   Hi all,
>>>
>>> I'm attempting to automate Excel 2007 using IronPython 2.0.1. I've
>>> followed a couple of examples (which I gather were written against Excel
>>> 2003), but they don't work for me.
>>>
>>> Here's my code:
>>>
>>> import clr
>>> clr.AddReference('Microsoft.Office.Interop.Excel')
>>> import Microsoft.Office.Interop.Excel as Excel
>>> xlApp = Excel.ApplicationClass()
>>> xlApp.Visible = True
>>> wbook = xlApp.Workbooks.Add()
>>> wsheet = wbook.Worksheets[1] # produces an error
>>>
>>> The error I get is:
>>>
>>> Error while invoking _Default.
>>>    at Microsoft.Scripting.Com.ComRuntimeHelpers.CheckThrowException(Int32
>>> hresul
>>> t, ExcepInfo& excepInfo, UInt32 argErr, String message)
>>>    at _stub_$27##25(Closure , CallSite , DispCallable )
>>>    at Microsoft.Scripting.Actions.MatchCaller.Call1[T0,TRet](Func`3
>>> target, Call
>>> Site site, Object[] args)
>>>    at Microsoft.Scripting.Actions.CallSite`1.UpdateAndExecute(Object[]
>>> args)
>>>    at
>>> Microsoft.Scripting.Actions.UpdateDelegates.Update1[T,T0,TRet](CallSite si
>>> te, T0 arg0)
>>>    at _stub_$26##24(Closure , CallSite , ComObject , Int32 )
>>>    at Microsoft.Scripting.Actions.MatchCaller.Call2[T0,T1,TRet](Func`4
>>> target, C
>>> allSite site, Object[] args)
>>>    at Microsoft.Scripting.Actions.CallSite`1.UpdateAndExecute(Object[]
>>> args)
>>>    at
>>> Microsoft.Scripting.Actions.UpdateDelegates.Update2[T,T0,T1,TRet](CallSite
>>>  site, T0 arg0, T1 arg1)
>>>    at _stub_$25##23(Closure , CallSite , Object , Int32 )
>>>    at Microsoft.Scripting.Actions.MatchCaller.Call2[T0,T1,TRet](Func`4
>>> target, C
>>> allSite site, Object[] args)
>>>    at Microsoft.Scripting.Actions.CallSite`1.UpdateAndExecute(Object[]
>>> args)
>>>    at
>>> Microsoft.Scripting.Actions.UpdateDelegates.Update2[T,T0,T1,TRet](CallSite
>>>  site, T0 arg0, T1 arg1)
>>>    at S$2.Initialize(Scope $scope, LanguageContext $language)
>>>    at
>>> Microsoft.Scripting.Runtime.OptimizedScriptCode.InvokeTarget(LambdaExpress
>>> ion code, Scope scope)
>>>    at Microsoft.Scripting.ScriptCode.Run(Scope scope)
>>>    at IronPython.Hosting.PythonCommandLine.RunFileWorker(String fileName)
>>>    at IronPython.Hosting.PythonCommandLine.RunFile(String fileName)
>>> StandardError: Error while invoking _Default.
>>>
>>> Can anyone shed any light on this?
>>>
>>> Cheers,
>>>
>>> David.
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.ironpython.com
>>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>>>
>>>
>>
>>
>> --
>> nomadlife.org
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.ironpython.com
>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>>
>>
>


-- 
nomadlife.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ironpython-users/attachments/20090324/49bd3005/attachment.html>