writing to specific excel cells

[IBAHKA]

Hello,
Is it possible to write to an EXISTING file to one specified cell? I have tried using write to xl.vi as an example, but this rewites the entire file and I lose my old data.
I would greately appreciate any advice!
Thank-you,
Ivanka

[Evan]

Ibahka,

Take a look at the modified example. I show how to open an existing File and sheet. From your post I am not sure if you got that far or not.

Anyways you can then use Set Cell Value.vi SubVI to set the value of an 1 cell in the file and worksheet you just opened.

The example does that in a loop, thus re-writes all the data. However if you only want to set 1 cell, take the VI out of the loop, and use it independantly.

See how I changed the 0,0 cell after all the data is set.

[Roy_F]

Don't forget to use the Example Finder (Help >> Find Examples...) when you need help figuring out how to do something. Evan modified the example that ships with LabVIEW (by the same name) to help you out. There are a couple of other Excel examples you might be interested in.

Good luck,
Roy

[IBAHKA]

Thanks Roy,
I had looked at some of those examples (Write table to XL.vi) and was still confused.

Ivanka