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