logging day:hour:min:second into a write to spreadsheet file

[RavensFan]

Use Array to Spreadsheet String (string palette) to convert your numeric data.  Concatenate the date and time also formatted a string to the front of it.  Use Write to Text File to output the data.

[JÞB]

---

Ravens Fan wrote:
Use Array to Spreadsheet String (string palette) to convert your numeric data.  Concatenate the date and time also formatted a string to the front of it.  Use Write to Text File to output the data.

---

Works great! and exacly the way we used to do it.  It makes a real pretty spreadsheet with text.  (can't do a meaningful graph vs text though  )

[nas1]

Thanks for your quick response, although I'm not sure we are looking at the same issue.  Please look at the following vi one more time.  Near the top is a Format Date/Time String that outputs day:hour:min:sec.  I need to input this string into the top element of the array.  How would you go about this.  Thanks for your patience

Nathan Smiley

Labview 7.1

[RavensFan · Accepted solution]

I guess you didn't understand the words I used.

So here is a screen shot of the functions.

[nas1]

Your right, though I did understand what you were saying.  I was trying to understand how you were placing those before the array.  You said "Use Array to Spreadsheet String (string palette) to convert your numeric data" and I was knocking my head against the wall, sceaming I told you I had a string to convert and place into the array.  Not trying to adjust the data coming out of the array.  My Bad!!  I wasn't really screaming, actually I've been very surprised and greatful for the help. The screen shot cleared everything up and I'm hopeful that when I get the instrumentation hooked up it will run.   I may use labview on occasion for stuff like Chemlab(ie data logging) but I'm not a veteran for sure.   Thanks!

[RavensFan]

I'm glad to hear you got it working now.  Pictures always help, but sometimes it takes longer to work up an example compared to trying to describe it.

The write to spreadsheet file VI is good to use when your data fits within some narrow specifications, but as soon as you need to customize things a bit, it will fall apart.  Kind of like Express VI's.  It gets things working quickly, but may not stand up as the problem becomes more complicated.