How can I connect "Get Date/Time String.vi" to "Write To Spreadsheet File.vi" ?

[Pikaichi]

How can I connect "Get Date/Time String.vi" to "Write To Spreadsheet File.vi" ?  I want to write 05/06/2008 to spreadsheet for example. I tried many conversions in vain. I am using LabVIEW 8.0 now.

[smercurio_fc]

Trying to fit a square into a circle? That VI uses a 1D/2D array of numbers, so why are you trying to feed a date?

I suppose you can do this:


If that actually means anything.


Message Edited by smercurio_fc on 05-06-2008 05:15 PM

[Pikaichi]

I want to store not only data of measurement system, but also date, time, commment, etc to one excel file.

Thank you for your advice. I tried what you propose, but it did not work. I attached the image of the error message.

[MikeS81]

Hi Pikaichi,

right click on the "Write To Spreadsheet File.vi" select, select type -> "string" or "automatic".

Mike

[Pikaichi]

Hi Mike

Thank you for your advice but no function of selecting "string" or "automatic" on LabVIEW 8.0.

I found that no problem connecting two vis on other PC installed LabVIEW 8.2. So I installed LabVIEW 8.2 on my PC, too, and now have no problem connecting these two vis.

Thank you.

[smercurio_fc]

The ability to adapt the Write to Spreadsheet File function was introduced in 8.2. In 8.0 it was a single variant, which was to accept a 2D array of doubles. As with earlier version, this basically required one to create a copy of it and change it to use strings. Since you've updated to 8.2 you don't have to do this.

[Pikaichi]

That proves it. Thank you.