[IronPython] Reading from a open excel document

[Jeff Hardy]

On Wed, Mar 16, 2011 at 8:49 AM, Nåjde Henrik <henrik.najde at volvo.com> wrote:
> 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

Perhaps a silly question, but is that even possible? I'm pretty sure
Excel locks a workbook when it is open, or maybe that's just the
behavior on file shares. (The number of times I've had to unlock
workbooks because someone opened it off a shared drive and then went
for lunch...)

There might be a parameter you can pass when opening the workbook, but
I don't know the Excel object model that well anymore, sorry.

- Jeff