キャンセル
次の結果を表示 
次の代わりに検索 
もしかして: 

Importing data from Excel.

解決済み
解決策を見る

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 件の賞賛
メッセージ1/3
1,289件の閲覧回数
解決策
トピック作成者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 件の賞賛
メッセージ2/3
1,275件の閲覧回数
解決策
トピック作成者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 件の賞賛
メッセージ3/3
1,262件の閲覧回数