How Can I Write a Timestamp with my Data to a Spreadsheet using LabVIEW?
Primary Software Version: 1.0
Primary Software Fixed Version: N/A
Secondary Software: N/A
I want to include a time stamp as a column along with my data in a spreadsheet file in LabVIEW. How do I do this?
Since a spreadsheet file is a specialized type of text file, you need to first convert your data and time stamp into a string. You can do this in three steps:
After the time stamp and array are in a string array, you can write it to a spreadsheet file. You can see a community example of the code below in the related links section below.
KnowledgeBase 3DSS8NS: How do I create a Millisecond Timestamp in LabVIEW?
KnowledgeBase 1RBDAG5P: Precision Errors Writing and Reading with Write to Spreadsheet File and Read from Spreadsheet File.vi
KnowledgeBase 3PJC3B8: How to Convert a Date/Time String into a Timestamp Constant
NI Community Example: Writing a Timestamp with my Data to a Spreadsheet using LabVIEW
Report Date: 09/07/2007
Last Updated: 04/23/2013
Document ID: 4D6CM9QQ