Open an existing Excel file created by Report Generation Toolkit

[Commandr]

How would I open an existing Excel file that has been created by the LabVIEW Report Generation Toolkit?

Let me explain my application. I have made a test program to collect data on a device. Each time I run the program I want it to append a new row onto an existing data file. Since the tests I do are sometimes over a period of days, I cannot keep the program open and running continuously. So I have to open an existing file and append the new data to it. In technical terms, what I need is to get the 'report out' reference to the existing Excel data file without losing the data that is already there.

[mikeporter]

For info on accessing Excel do a search in the examples for the word "Excel" you will get an example that shows how to open a spreadsheet and manipulate the data. This should get you started.

Mike...

[Commandr]

I found a couple of examples but they have broken wires coming off of the _Worksheet Invoke Nodes. I don't know why this is. I think the examples were made for an earlier version of either LabView or Office. I have the latest version of the LabView Developer Suite and am using Office 2003. How would I fix this?

Message Edited by Commandr on 07-20-2005 09:07 AM

[Commandr]

Never Mind. I fixed my problem by changing the Range Property Node from 'Value' to 'Value2'. I'm curious as to why I had to do this but it works nonetheless.

[mikeporter]

It was most likely as you said a version problem. Excel is well know for differences between versions.

Mike...

[Sumithra_Nagappan]

Hello sir

          Have you fixed the problem?please share the solution since i too want to save data in the same file during test condition..