How to add time information to the first column of spreadsheet file?

[科学男孩]

hi all.

how to add time information to the first column of spreadsheet file?illustrated in the figure below。

[RavensFan · Accepted solution]

You need to take the time data and convert it to double.  But Excel data is based on days since 1/1/1900 while LabVIEW data is based on seconds since 1/1/1904.

Take a look at this thread for an example I posted on how to make the conversion.

One other possibility is to convert your numeric data to a string, and build on an array of time that is also a string version of the timestamp.  Then write your 2-D string array to the Write to Spreadsheet file.