send date/time to excel

[PGRAY10]

Hello,

I am trying to send the date and time to an excel sheet in another row. How do I do that? I have a screen shot of what I have done.

[Taki1999]

First off, you're writing to a delimited text file, not an Excel sheet. If you want to write to an Excel sheet, look at ActiveX and some of the other forum postings on Excel.

If you're sticking with delimited text, insertion is not an easy option. You probably do better assembling your array in LabVIEW and then performing a single Write to Spreadsheet call when your array is arranged the way you want it.

[Dennis_Knutson]

All that you need to do is convert the numeric to a string and build a string array. Then you set the Write to Spreadsheet File function to the string type.

[Bob_Schor]

Please learn about Snippets (open LabVIEW, go to Edit Menu, notice "Create VI Snippet from Selection") which lets you create an "Executable Image of LabVIEW code" that you can paste into your post directly.

BS

[PGRAY10]

Im having trouble writing the date and time to array. How do you convert the date string into a numeric?

[Dennis_Knutson]

That makes no sense after being told to convert the numeric to a string.

[PGRAY10]

I have my wireless node connected to a build array. I want to connect Get Date/Time String to the build array. The error I am getting says "You have connected two terminals of different types. They type of the source is string.  The type of the sink is single [32-bit real (~ 6 bit precision)" I figure if I convert this string to a numeric, then it will be able to connecto to build array. The build array is outputting to Write to Spreadsheet File.

[RTSLVU]

Do it like this, do not just write the LabVIEW time string to Excel in a string array. You will be sorry sometime down the road when you find you can not format  the time column in your data file.

You may have to adjust the conversion for your time zone.

Don't be confused by the results (a strange looking number) that is what an unformatted time stamp looks like.

You can use Excel to format the column into any Excel time or date format.

[RTSLVU]

Here's the VI and another one that adds in writing to a file.

[Dennis_Knutson]

PGRSYAY,

I won't disagree that writing a date/time during will not write a true Excel timestamp but you really need to understand some fundamentals. You cannot mix data types in an array so either write two numerous or two strings. The Write to Spreadsheet can be configured for either with a simple right click or using the selector beneath the function. Make sure Context Help is always turned on.