You might want to try <div><span class="Apple-style-span" style="font-family: Arial; "><span>Parameter1</span> = worksheet.Range["<span>A1</span>"].Value</span></div><div><font class="Apple-style-span" face="Arial"><br>
</font></div><div><font class="Apple-style-span" face="Arial">or</font></div><div><font class="Apple-style-span" face="Arial"><br></font></div><div><font class="Apple-style-span" face="Arial"><span>Parameter1</span> = worksheet.Range["<span>A1</span>"].Text</font></div>
<div><font class="Apple-style-span" face="Arial"><br></font><br><div class="gmail_quote">On Wed, Mar 16, 2011 at 9:49 AM, Nċjde Henrik <span dir="ltr"><<a href="mailto:henrik.najde@volvo.com">henrik.najde@volvo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<div><font size="2" face="Arial"><span>Hello!</span></font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font face="Arial"><font size="2">I am trying to transfer prameters from an
excel sheet to ANSYS Workbench (a FEA software)<span>,
the code is run as a macro in ANSYS workbench.</span></font></font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">I have adapted a code that is opening an already
existing document and successfully transfers parameters from it<span>, so I know that what i want to do can be
done.</span></font></div>
<div><font size="2" face="Arial"><span></span></font><font size="2" face="Arial"><span>The problem is that I cant
access a already open document and read from it, using instructions from <a href="http://www.ironpython.info/index.php/Interacting_with_Excel" target="_blank">http://www.ironpython.info/index.php/Interacting_with_Excel</a> </span></font></div>
<div><font size="2" face="Arial"><span>For error-seraching
I have created a new code looking like this:</span></font></div>
<div><font size="2" face="Arial"><span></span></font><font size="2" face="Arial"><span></span></font><font size="2" face="Arial"><span></span></font> </div>
<div><font size="2" face="Arial"><span>- - - - - - - - -
<span>- - - - - - - - - </span></span></font></div>
<div><font size="2" face="Arial"><span><span>#Part 1</span></span></font></div>
<div><font size="2" face="Arial"><span>import
clr<br>clr.AddReference("Microsoft.Office.Interop.Excel")</span></font></div>
<div><span><font size="2" face="Arial"></font></span> </div>
<div><span><font size="2" face="Arial">from
System.Runtime.InteropServices import Marshal<br>Excel =
Marshal.GetActiveObject("Excel.Application")</font></span></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial"><span>#Part
2</span></font></div>
<div><font face="Arial"><font size="2">workbook = Excel.ActiveWorkbook<span> #gives no
error</span><br>worksheet<span> </span>=<span> </span>workbook.ActiveSheet<span> #errror</span></font></font></div>
<div><font face="Arial"><font size="2"><span></span></font></font> </div>
<div><font face="Arial"><font size="2">worksheet = Excel.ActiveSheet<span> #no
error</span><br></font></font></div><font face="Arial"><font size="2"></font></font>
<div><font face="Arial"><font size="2"><span>Parameter1</span> = worksheet.Range["<span>A1</span>"]<span> #
error</span></font></font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font face="Arial"><font size="2"><span>- - - - -
- - - - </span><span>- - - - - - - - -
</span></font></font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial"><span>The problem is that
when trying to access a excel "workbook" with the command
"worksheet=workbook.ActiveSheet<span>" as descriped in
the above link I get an error message. </span></span></font></div>
<div><font size="2" face="Arial"><span><span></span></span></font> </div>
<div><font size="2" face="Arial"><span><span>If i instead chose to use "worksheet =
Excel.ActiveSheet<span>" I get no error message, but
when I continue </span></span></span></font><font size="2" face="Arial"><span><span><span>to access a cell on the active sheet, the script still
fails.</span></span></span></font></div>
<div><font size="2" face="Arial"><span><span><span>I am trying to read the
cell using </span></span></span></font><font size="2" face="Arial"><span><span><span>"Parameter1 = worksheet.Range["A3"]<span>"</span></span></span></span></font></div>
<div><font size="2" face="Arial"><span><span><span><span></span></span></span></span></font><font size="2" face="Arial"><span><span><span></span></span></span></font> </div>
<div><font size="2" face="Arial"><span>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.</span></font></div>
<div><font size="2" face="Arial"><span></span></font> </div>
<div><font size="2" face="Arial"><span>Does anyone know the
correct way to access an open workbook and read from the active
sheet?</span></font></div>
<div><font size="2" face="Arial"><span></span></font> </div><font color="#888888">
<div><font size="2" face="Arial"><span></span></font> </div>
<div><font size="2" face="Arial"><span>/Henrik</span></font></div></font></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.ironpython.com">Users@lists.ironpython.com</a><br>
<a href="http://lists.ironpython.com/listinfo.cgi/users-ironpython.com" target="_blank">http://lists.ironpython.com/listinfo.cgi/users-ironpython.com</a><br>
<br></blockquote></div><br></div>