Check this link on how it is done in powershell http://www.microsoft.com/technet/scriptcenter/resources/qanda/jan09/hey0112.mspx. I wonder if Worksheet is actually an array or it's some other data structure.
On Tue, Mar 24, 2009 at 2:05 PM, Dody Gunawinata <[email protected]>wrote: > 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 <[email protected]> wrote: > >> It appears that the default Workbook.Add always includes 3 Worksheets. >> >> 2009/3/24 Dody Gunawinata <[email protected]> >> >> Does workbook automatically generates default worksheets when you create >>> them? It looks like an array out of bound problem. >>> >>> 2009/3/24 Utini <[email protected]> >>> >>>> 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 >>>> [email protected] >>>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com >>>> >>>> >>> >>> >>> -- >>> nomadlife.org >>> >>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com >>> >>> >> > > > -- > nomadlife.org > > -- nomadlife.org
_______________________________________________ Users mailing list [email protected] http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
