append characters to an existin excel file

[Victor_M]

Hello guys
I've an excel file where I write an array (single data type)of 6 elements by using "Write to Spreadsheet File.vi" On this file I also need to write a new column with the time and date.At this point everthing it´s ok, but when I´m trying to append this new column(date & time) with "Write character to File.vi" it writes this data not in the rigth column but it does it in the first column of the file. Could it be wrong by problems with the EOF marker??
I attached the excel file.
Thanks in advance

[Cristobal]

Hello,

When I use the Write to Spreadsheet File.vi to append data to an existing Excel file, the data I input doesn't appear in the file.All I get is replace the Excel file by the new data and I loss the old data. This is due because Excel changes tab-delimited format. There is a KB than explains it:

http://digital.ni.com/public.nsf/websearch/D1629D863F0442CC86256A0200558A15?OpenDocument

You could use the Report Generation Toolkit to avoid this Excel formatting. Look at the following KB and you will see that it is possible:

http://digital.ni.com/public.nsf/websearch/EFCE1C25DCE7483E86256CAF00539451?OpenDocument

If you don't have Report Generation Toolkit, try to contact to NI

regards
crisR

[Victor_M]

Hello CrisR

Thank you for answering, but finally I solved the problem.I just had to concatenate this string "TAB constant/data/CR constant" and I used the Write File.vi and everything went fine.
In relation to the link you attached,I have never had the problems you say, but thanks a lot anyway

Bye