Hello Utini,
Instead of wsheet = wbook.Worksheets[1] try this wsheet = wbook.Worksheets.Item[1]. It should work like that. Good luck, António Piteira ------------------- 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 <http://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
