Hello! I am trying to transfer prameters from an excel sheet to ANSYS Workbench (a FEA software), the code is run as a macro in ANSYS workbench.
I have adapted a code that is opening an already existing document and successfully transfers parameters from it, so I know that what i want to do can be done. The problem is that I cant access a already open document and read from it, using instructions from http://www.ironpython.info/index.php/Interacting_with_Excel For error-seraching I have created a new code looking like this: - - - - - - - - - - - - - - - - - - #Part 1 import clr clr.AddReference("Microsoft.Office.Interop.Excel") from System.Runtime.InteropServices import Marshal Excel = Marshal.GetActiveObject("Excel.Application") #Part 2 workbook = Excel.ActiveWorkbook #gives no error worksheet = workbook.ActiveSheet #errror worksheet = Excel.ActiveSheet #no error Parameter1 = worksheet.Range["A1"] # error - - - - - - - - - - - - - - - - - - The problem is that when trying to access a excel "workbook" with the command "worksheet=workbook.ActiveSheet" as descriped in the above link I get an error message. If i instead chose to use "worksheet = Excel.ActiveSheet" I get no error message, but when I continue to access a cell on the active sheet, the script still fails. I am trying to read the cell using "Parameter1 = worksheet.Range["A3"]" It seems to me that the script fails at the point where I try to select the workbook or the worksheet, but I have really no clue. Does anyone know the correct way to access an open workbook and read from the active sheet? /Henrik
_______________________________________________ Users mailing list Users@lists.ironpython.com http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
