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 documentation) and more efficient (fewer "layers" to go through at execution time) to work with a COM-based API using unmanaged code rather than managed code.

If you were to use non-Iron Python (there is another post that has some code showing some of the incantations needed) you would be at least as close to the goal.

If you have a requirement to use a .Net language to complete the task, IronPython will be as good as anything.  You will need to get hold of (and install) the "primary interop assemblies" (PIAs) for the version of Excel that you're using -- and, if the program is to run on someone else's machine eventually, you'll have to get them (and .Net 2 and IronPython) onto that machine as well.  Holler if you need assistance with that. 

But I suggest you use "ordinary" Python for the task.  Good luck!

At 07:10 AM 2/8/2006, Weffers, H.T.G. wrote (in part)
What I am currently most looking for is a way of accessing the
specific data in the Microsoft Excel file, preferably using the
most recent beta of Microsoft IronPython effectively 'exploiting'
its .Net capabilities.


J. Merrill / Analytical Software Corp
_______________________________________________
users mailing list
[email protected]
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com

Reply via email to