LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

WRTIE IN EXCEL FILE WHILE I AM RECEIVING DATA FROM OTHER PC

hello,

 

i am receinving information from other pc that is connected by tcp,  can i write the information i am receiving in a excel sheet while i am receiving?

 

 

 

thanks!!!

0 Kudos
Message 1 of 6
(2,689 Views)

Check out the Producer/Consumer architecture

 

Open LabVIEW. Choose New and  VI->From template->Frameworks->Design Patterns->Producer/Consumer Design Pattern

Regards,
Even
_________________________________
Certified LabVIEW Associate Developer

Automated Test Developer
Topro AS
Norway
0 Kudos
Message 2 of 6
(2,688 Views)

thanks even, i know that this is the best way to work, but i don't know how to create and wirte while i am receiving...queues are good for work in this, writting in excel while i am reading....

but to create a excel file?

0 Kudos
Message 3 of 6
(2,685 Views)

Yes as you said you have to use the queues for holding the data and writing the data to the excel file. Do you need the Excel file with the same MS Excel formatting or just a file that you can view through Excel application. Because when you want to create an Excel file then you have to use the Report Generation toolkit or else you have to use the Active X. Using Report generation toolkit for writing data will take time so in between when you do during the data acquisition it is not desirable.

-----

The best solution is the one you find it by yourself
0 Kudos
Message 4 of 6
(2,680 Views)

see what i have done...

 

this is a litte example but, what i want is to change the line of excel every number i read, how can i do it, please see my examp`le is very easy!!

 

 

thanks!

0 Kudos
Message 5 of 6
(2,660 Views)

A quicker solution would be to write to a 1D array and use the Write to Spreadsheet File.vi instead of writing to Excel each time.  You can write to memory faster than updating a file.  Depending on your frequency, perhaps you don't need to worry about it.  You don't nee the RGT for this.  But, the attachment will show you how to do it.

-----------------------------------------------------------------------------------------
Reese, (former CLAD, future CLD)

Some people call me the Space Cowboy!
Some call me the gangster of love.
Some people call me MoReese!
...I'm right here baby, right here, right here, right here at home
0 Kudos
Message 6 of 6
(2,652 Views)