LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

read xls

Highlighted
Ravens Fan, you are right. I found in the example code seccion a VI which exactly does this convertion. It's this one http://zone.ni.com/devzone/cda/epd/p/id/1631  fyi.
0 Kudos
Message 21 of 24
(625 Views)
Highlighted

Thanks for the link.  I hadn't seen that one before.  I had never thought that Excel was based on January 0, 1900.  That is an odd concept.  Exactly when is that?

 

Other things you should know.  Excel date of 60 is February 29, 1900, even though that date didn't exist.

You will need to do a time zone conversion between Excel and LabVIEW.  LabVIEW bases all dates on GMT.  So if you use a date/time, and you are in another timezone, it may not look right to you.

 

I was recently answering a similar question in another thread and posted some code there.

0 Kudos
Message 22 of 24
(613 Views)
Highlighted

Thans for all the info. Everything you tell is quite interesting. I don't know much about Excel and I am a LabView beginner,...so the more I learn, the better.

 

I can not tell you too much about this VI, because as I said I picked it from the examples area, I put it in my VI and it works. I also have to say that I was using the subVI just to take the date, so don't have any to do the conversion between Excel and LabVIEW (thanks god!! :-))

 

I will take a look at the other thread.

0 Kudos
Message 23 of 24
(600 Views)
Highlighted

thnks .....

0 Kudos
Message 24 of 24
(118 Views)