ni.com is currently experiencing unexpected issues.

Some services may be unavailable at this time.

取消
显示结果 
搜索替代 
您的意思是: 

Exporting data to excel with time stamp

We have written an express VI code recording voltage. The code works, and the data is recorded, but the data is transferred to an excel file without the time stamp. In the excel file we have the data down column A, but there is no time at which any of the data was recorded. Is there a way we can get the time recorded in excel also? Thanks for the help.

 

 

0 项奖励
1 条消息(共 6 条)
4,322 次查看

You will need to convert the time stamp into a string.

PaulG.
Retired
2 条消息(共 6 条)
4,317 次查看

Where do I attach the string of the time stamp so it gets logged with the data? Thanks

0 项奖励
3 条消息(共 6 条)
4,306 次查看

I maybe wrong but I believe that the timestamp data associated with the data that is logged will be in the TDMS file as properties of those channels.  Are you sure the time data isn't logged as a property?

0 项奖励
4 条消息(共 6 条)
4,185 次查看

That would have been my assumption too hoovah. But another thing is, do you want the same time stamp for each of the samples or for the beginning of each of the samples? The timestamp outside of the loop is only going to produce one time, that is the one recording when the VI is started.

0 项奖励
5 条消息(共 6 条)
4,170 次查看
No PC at the moment but I think their would be the start time of each task/channel and a dt between samples. Just like the waveform data.
0 项奖励
6 条消息(共 6 条)
4,153 次查看