transfer data from labview to excel with the program running

[chamriamin]

Hello Everyone,

I m  asking just asking a question that if it's possible to transfer data from excel to labview while the program is running, because sometimes i lost all data when the data reaches some points and the issue that the data transfer is after that the program stops.

Thank you, Regards,

[GerdW]

Hi cham,

title: transfer data from labview to excel

message: transfer data from excel to labview

Yes, both is possible.

because sometimes i lost all data when the data reaches some points

Why? When? Which points?

  the issue that the data transfer is after that the program stops.

??? Data transfer after the program stops???

[Bob_Schor]

Many of us have routines that run, open an Excel (.xlsx) Workbook, read and write values to specific Worksheets, then save the (modified or newly-created) Workbook, exit Excel, and then exit the Program.  It is easy enough to "decouple" opening and closing Excel with opening and closing the LabVIEW Program (with the caveat that you want LabVIEW to "Start First, Finish Last" (as you need it running to open and close Excel).

It is not clear from your post what you want to do.  It would help if you could write a few sentences that say something like this:

1. Start Program.
2. Open existing (or create new) Excel File C:\Data\Test.xlsx.
3. [Describe something you want to do with the file, i.e. "Read Data" or "Write Data"].
4. Save Excel File and close Excel.
5. Exit Program.

Once you clearly explain what you want to do, it would be helpful if you also show us how you are trying to do this.  The only reasonable way to accomplish this is to attach the LabVIEW code (meaning all the .vi and .ctl files that you are using -- if more than 3, compress the Folder holding them all and attach the resulting .ZIP file) and let us examine it.  We can then offer specific and meaningful help.

Bob Schor

[chamriamin]

what i really want to do is that i want to transfer each data to excel while the program is still running 

thank you very much,

Regards,

[GerdW]

Hi cham,

i want to transfer each data to excel while the program is still running 

Ok, that's fine. And what is your problem?

Btw. to transfer data when the program is NOT running will be hard (next to impossible)…

To repeat Bob:

What have you tried so far? Where are you stuck? Do you want to attach your VI? Have you studied the example VIs coming with LabVIEW? Do you have access to the RGT (Report Generation Toolkit)?

[chamriamin]

what i tried was to link to the output export data to excel that problem is that for each data the program open a new excel window if i had 100 data i will have 100 excel's window so i don't know how i can for each data ouput to put it in excel while the program is running.

thanks

[GerdW]

Hi cham,

To repeat:

What have you tried so far? Where are you stuck? Do you want to attach your VI? Have you studied the example VIs coming with LabVIEW? Do you have access to the RGT (Report Generation Toolkit)?

[chamriamin]

i m stuck with the facts that i have alot of data and sometimes the plots dispear and at the end i have no data in excel, no because my VIs is very big, i have study some examples, and no i don't have acces to RGT

[GerdW]

Hi cham,

when you have a problem in YOUR VI and you want help with YOUR VI then you need to attach YOUR VI…

i don't have acces to RGT

Which LabVIEW version (and license type) do you use?

How do you transfer data right now?

Did you look for "Excel ActiveX" in the forum to find similar questions and study their solutions?

[chamriamin]

okey i will attach the vi maybe you can help me with the other issues that i have, and there is a picture shows what kind of data i want to transfer.

Thank you

Cham,