append to excel file

[sound nt]

Hi all,

I have got the example in the LV for exporting table to the excel,

The problem i am facing is that i have to append the new data to the same file every time a event occurs.

The vi is attached below.

Thanks in advance .

regards

[Harold_Timmis]

you can use the write to spreadsheet.vi to append data to excel files.

[Gak]

Hi sound nt

I don't have  labview 9 so I can not c your code but what can you do is, when you write data each time,keep one counter for row and one for column.

so when next time you start logging data to excel you can start from where you had placed last element.I hope you this will solve your problem.Or else post your vi in labview 8.5.

Best of luck

[Harold_Timmis]

also you can use activex to append data to excel there are very good examples of this in labview example finder.

[sound nt]

HI HAROLD,

The VI that i have attached is from the Example finder only.

Can you modify the given vi,or the logic.

[Harold_Timmis]

you can write the data to the table and it will append the data to excel..... because your data is numeric you will have to convert your numeric data to a string to do this use the number to decimal string.vi and this will than beable to append your data to excel

[Harold_Timmis]

hope this helps

[sound nt]

Hi,

WHen the file is in open state and you run again then new file is created.

When you close the file then it asks to save it. and then also the next data does not append it.

have you got what i am trying to say?

Regards

[Harold_Timmis]

this may help:

http://forums.ni.com/ni/board/message?board.id=170&message.id=29337&query.id=49507#M29337

[sound nt]

Hi,

Thanks 

It helped with the spreadsheet example for now.

but in future i have to use the activex component, i will try that later.

regards..