Saving array elents and time stamp in Excel sheet

[silver]

Dear Friends,

My code is so far working, but I have the following task to accomplish.

I am converting hexadecimals to Decimals (x,yz) values and plot them. The sampling rate(0,1 = 10 values per second) and the offset of the chart are given through the property node of the Chart.

I also convert the time stamp to Excel format ( e.g 36000,5 = 36000 days after the date 01.01.1900 and after the comma is the time 0,5 = 12:00:00 AM)

So now , I want to save the values in an Excel sheet with its time stamp.

How can I solve this problem?

pls see my code to get my points.

[LAVA 1.0 Content]

The reference time for LabVIEW is 12:00 a.m., Friday, January 1, 1904, Universal Time. So you have 1462 day offset.

For excel you have the correct reference time but don't forget that it's not in UTC format.

Eric

[TobyD]

QUOTE(silver @ Dec 12 2007, 09:40 PM)

Dear Friends,

My code is so far working, but I have the following task to accomplish.

I am converting hexadecimals to Decimals (x,yz) values and plot them. The sampling rate(0,1 = 10 values per second) and the offset of the chart are given through the property node of the Chart.

I also convert the time stamp to Excel format ( e.g 36000,5 = 36000 days after the date 01.01.1900 and after the comma is the time 0,5 = 12:00:00 AM)

So now , I want to save the values in an Excel sheet with its time stamp.

How can I solve this problem?

pls see my code to get my points.

You're almost there. You can use the Write to Spreadsheet File.vi in the File I/O pallete to write your data to a .csv file. Check the help file and examples to see how this vi works.