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

Wed, 08 Feb 2006 08:18:06 -0800

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 :)

Eric


On 2/8/06, J. de Hooge <[EMAIL PROTECTED]> wrote:

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 lines and add them
# back in one at a time ... or do the commands interactively
 
from win32com.client import Dispatch
 
xlApp = Dispatch("Excel.Application")
xlApp.Visible = 1
xlApp.Workbooks.Add()
xlApp.ActiveSheet.Cells(1,1).Value = 'Python Rules!'
xlApp.ActiveWorkbook.ActiveSheet.Cells
(1,2).Value = 'Python Rules 2!'
xlApp.ActiveWorkbook.Close(SaveChanges=0)

xlApp.Quit()
del xlApp

 
# raw_input("press Enter ...")


 



Kind regards



Jacques de Hooge



[EMAIL PROTECTED]




 



 



-----Oorspronkelijk
bericht-----

Van:
[EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]] Namens Weffers, H.T.G.

Verzonden: Wednesday, February 08,
2006 1:10 PM

Aan: [email protected]

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



 






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) useful answer.









 









Using IronPython (on a Microsoft
Windows XP platform) I want to 









develop an application that takes
data from a specific range of 









cells in a Microsoft Excel Workbook
(file), processes the relevant









data, and then creates a graph
representation using GraphViz.









 









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. 









 









Concrete suggestions for or pointers
to (similar) solutions are









appreciated.









 









Sincerely yours,









 






Harold Weffers






 

_______________________________________________
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

Reply via email to