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

[alan4]

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!!!

[EvenDeejay]

Check out the Producer/Consumer architecture

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

[alan4]

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?

[P@Anand]

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.

[alan4]

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!

[MoReese]

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.