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
_______________________________________________ Users mailing list [email protected] http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
