LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Importing data from Excel.

Solved!
Go to solution

Hi,

 

So I am importing data from an excel file. I get all the data correctly except one cell. There is a cell in excel where a date is stored. The value is 26.01.2023. But in LabVIEW it is coming as 44952. Can anyone explain why this is and how can I correct it? Thank you. 

0 Kudos
Message 1 of 3
(796 Views)
Solution
Accepted by topic author govindsankar

https://forums.ni.com/t5/Example-Code/LabVIEW-Time-to-Excel-Time-Format/ta-p/3503346

 

It's explaining how to convert from LabVIEW to Excel, by reversing the VI you can do Excel to LabVIEW.

0 Kudos
Message 2 of 3
(782 Views)
Solution
Accepted by topic author govindsankar

Check this out

Simple Excel Date/Time to Labview - NI Community

----------------------------------------------------------------------------------------------------------------
Palanivel Thiruvenkadam | பழனிவேல் திருவெங்கடம்
LabVIEW™ Champion |Certified LabVIEW™ Architect |Certified TestStand Developer

Kidlin's Law -If you can write the problem down clearly then the matter is half solved.
-----------------------------------------------------------------------------------------------------------------
0 Kudos
Message 3 of 3
(769 Views)