write the data from com port to excel sheet through labview

[samtha]

Hi there,

Please help me with stroing the data that is coming from com port to excel sheet, using example i am able to write values to excel sheet but when i run the vi the excel sheet keeps on opening and closing repetitively i dont know why this is happening and also i need to plot the data in the excel sheet please help me here i am attaching my vi.just chek it out.......

[Mark_Yedinak]

That is the normal behavior. What I would recommend you do is to buffer the data and write it out in larger chunks. This will minimize the number of times Excel opens and closes as well as improve performance. Alternatively you could write the data to a CSV file (comma or tab delimited) and simply read this data via Excel.

If you haven't already considered it you may also want to put the file logging in a parallel task. File writes can take time and therefore impact your performance. However you minimize this impact if you use a separate task to perform the writes. Just be careful how you pass data to the second task. Queues or notifiers are the prefered methods. Avoid using local or global variables.