[IronPython] Question (Novice) on using Microsoft Excel via IronPython

2006-02-08 Thread Weffers, H.T.G.
If the following is a too frequently asked question, then please forgive me.   Being a novice in the use of IronPython and Python I spent a significant amount of time trying to find the answer to the below question in a FAQ list, but until now I did not (yet) find a (pointer to a) usefu

Re: [IronPython] Question (Novice) on using Microsoft Excel viaIronPython

2006-02-08 Thread J. de Hooge
Sorry, I forgot where I found this, but maybe it helps…  # this example starts Excel, creates a new workbook, # puts some text in the first and second cell# closes the workbook without saving the changes# and closes Excel.  This happens really fast, so# you may want to comment out some li

Re: [IronPython] Question (Novice) on using Microsoft Excel viaIronPython

2006-02-08 Thread Eric Larson
Could you also connect to a COM object (or do something similar) and then use IronPython similar to _vbscript_? I am not sure, but this may have been what the original poster wanted. Of course I could be wrong and simply putting my hopes to use IronPython as a macro language on the table :) EricOn

Re: [IronPython] Question (Novice) on using Microsoft Excel via IronPython

2006-02-08 Thread Tim Riley
Check the Ironpython tutorial included with IronPython. There is a section titled "Tutorial 3: IronPython and COM interoperability".Best of luck,Tim RileyOn 2/8/06, Weffers, H.T.G. <[EMAIL PROTECTED]> wrote: If the following is a too frequently asked question, then please forgive me.   Be

Re: [IronPython] Question (Novice) on using Microsoft Excel via IronPython

2006-02-08 Thread Jonathan Jacobs
Weffers, H.T.G. wrote: Being a novice in the use of IronPython and Python I spent a significant amount of time trying to find the answer to the below question in a FAQ list, but until now I did not (yet) find a (pointer to a) useful answer. What I am currently most looking for is a way of acce

Re: [IronPython] Question (Novice) on using Microsoft Excel via IronPython

2006-02-08 Thread J. Merrill
There is very little, if any, advantage in attempting to "exploit .Net capabilities" when the goal of the task is to interact with code that is not based in .Net.  Excel does not have a .Net-based API; it has only a COM-based API.  It is both easier (less code to write, more available documentatio

Re: [IronPython] Question (Novice) on using Microsoft Excel via IronPython

2006-02-08 Thread J. Merrill
Unless you're using an old version of Excel (neither 2003 nor XP), the "use tlbimp to build a .Net assembly for Excel" part of this is both not necessary (MS has done it for you, by building the PIAs I mentioned in my other post) and not a good idea (for lots of reasons, some clear and others qu