how can I record date and time directly into excel file using toolkit

[Sam0909]

I want to record date and time along with data into an excel file using report generation toolkit.
I connected 2D array data, and it can recorded.
How can I do the same thing with date and time along with the data

[Jeremy_L]

Hi Sam,

Since you are sending your data into Excel, you should be running into a point where your data is transformed into a 2d array of strings to pass into the table. Before you get to this, you can get an array of your time and date strings and insert these as columns into the 2d array. Then pass that new 2d array (2 columns larger) into your excel report. You should be able to now see the timestamps, data, and then data represented as columns. This way, each timestamp lines up with each date, which in turn should line up with each row of data acquistion.

Jeremy L.
National Instruments

[Nproach]

Hello, I'm having a similar issue. I'm trying to get my product to continuously record date and time throughout an expiriment. I already have most of the spread sheet set up but when I attempt to add in the date and time values the form array vi says that the information is wired to an improper terminal. I dont understand what I'm doing wrong but I would really appreciate help. Thank You!

[MoReese]

You can use the Excel Easy Title.vi to write the time/date to a column header.

[JÞB]

And don't forget to vote for this idea.  Excel and LabVIEW keep dates and times in different formats.  The conversion is attached in the link