time to spreadsheet

[Aquaphire]

I managed to write out a program that displays the "date/time" every second... so technically a clock.

However, I would like to write this to a spreadsheet file. so that a text file is created with the following output:

06/22/05 13:39:36
06/22/05 13:39:37
06/22/05 13:39:38
...


thanks.

[Honeywell]

You can try inserting each date/time entry into an array and then use "Write to Excel File.vi" to save it in an Excel file.

[Aquaphire]

Thanks for answer.

Problem is that, I only have labview 6.01, so that function doesnt exist...

And spreadsheet files won't accept strings.
IF i attempt to build an array using the date/time string, it still remains a string and still cannot be saved to spreadsheet...

help! 🙂

[Honeywell]

Take a look at this VI I created few weeks ago.

[Honeywell]

In case you don't have the sub VI.

[Dennis_Knutson]

Write to Spreadsheet can be modified to write strings. Open the VI and look at the block diagram. On the bottom of the screen, there are instructions on how to modify it. I've created a polymorpic VI that will handle either but I can't save it as 6.01 right now. I've got a new pc without 6.1 or 6.0 loaded. If I load either one, I'll post the polymorphic VI but in the meantime, editing the existing one is a simple excersie for a beginner. When you make the modifications, be sure to save it under a new name (i.e. Write Strings to Spreadsheet File) and to a new location - not in the llb with the original or in any of the LabVIEW folders.

[Aquaphire]

thanks guys, ill take a look at it.

[Aquaphire]

Honeywell,

I took a look at your 2 VI's.

I don't understand how your 2D table is relevant to my question... since it doesn't write to a spreadsheet. It only creates a table. (plus its real complex and i'm kinda clueless!)

Also, in the write file + (string) sub VI, I don't really understand how to use it (even with the help...)

I'm sorry to pester you about this, but I'm really really clueless.

thanks a lot!

[Dennis_Knutson]

Here. Try the polymorphic VI called Write Anything to Spreadsheet file that's in the attachment. I still think that the editing of the original VI is a good excersise for you to do.

[Honeywell]

Take a look at this. Not too sure if this is what you're looking for though.