09-22-2011 03:52 AM
Hi
i am trying to write date and time to excel sheet i got this example from https://decibel.ni.com/content/docs/DOC-2108. but when i tried to write it on excel it is just showing the numbers but not exact date and time what i want.
some body have idea whats wrong in my VI(see attached file)?
thanks
09-22-2011 04:07 AM
Qazi,
There is nothing wrong with your VI.
After you use your VI and copy this to an excel cell, you have to format it to date/time.
Right click the cell, select Format Cells, and select Date or Time.
Regards
09-22-2011 04:29 AM
Thanks for the reply. but is it possible that i could set the format from labview rather then going to excel every time
and changing the format every time when report generated?
qazi..
09-22-2011 06:47 AM
Hi Qazi,
I wrote a VI for you to make things simpler. It opens an excel file and sets the format of the active cell to date/time. Does this help?
09-22-2011 07:59 AM
You might want to swap up to this Version. There are a few things that LVtime2Exceltime.vi does not handle correctly (like Zone, DST and the Leapyear Bug in excel) you may want to vote for this Idea
09-26-2011 02:16 AM
Hi thanks for the replies but when i tried 'Set_Cell_format.vi* it hangs labview all the time. is there any other solution?
i tried Time to XL.vi as well but it seems not working not time display at all?
any other idea?
09-26-2011 02:24 AM
That's odd. I ran the VI before I sent it to you. Which LabVIEW are you using?
09-26-2011 02:25 AM
its LABVIEW 2010
09-26-2011 02:27 AM
I will check it on 2010 and get back to you.
09-26-2011 02:28 AM
thanks in addition i have win 7 64 bit