Selon "Weffers, H.T.G." <[EMAIL PROTECTED]>: > 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. >
check the csharp sample here: http://www.thecodeproject.com/csharp/csharp_excel.asp it should be fairly straightforward to translate that to python directly, like import CLR.Excel workbookPath = "c:/SomeWorkBook.xls" excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false); > 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 > > > > -- ----------------------------------------------------------------- Stanislas Pinte e-mail: [EMAIL PROTECTED] ERTMS Solutions http://www.ertmssolutions.com Rue de l'Autonomie, 1 Tel: + 322 - 522.06.63 1070 Bruxelles Fax: + 322 - 522.09.30 ----------------------------------------------------------------- _______________________________________________ users mailing list [email protected] http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
