LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Read a data from excel - report generation

Hello all , 

i have an attached a VI . which Consists of several rows and several columns. Particularly in a 3rd column ( Test time ) is not reading properly in LabVIEW indicator. i was tried in many ways ( extract a column and adding a colon ). what was the reason ?? how to crack this ? 

 

 

Download All
0 Kudos
Message 1 of 9
(1,358 Views)

Hi bhuvanesh,

 

change the column for this "Test Time" column from "time" to "scientific with 5 significant numbers" and you will notice you see the very same numbers as are shown in LabVIEW!

Best regards,
GerdW

using LV2011SP1 + LV2017 (+LV2020 sometimes) on Win10+cRIO
0 Kudos
Message 2 of 9
(1,346 Views)

Hello Gerdw ,

 i cant get you . shall we need to choose the whole column and change properties >?? 

in properties time editing option was not there . i am a beginner in this . plz post a screen shot of that and guide me 

0 Kudos
Message 3 of 9
(1,339 Views)

Hi bhuvanesh,

 

i cant get you .

I wanted to explain the LabVIEW readings: they are infact the very same numbers as in Excel!

 

 shall we need to choose the whole column and change properties >??

Open your Sheet with Excel.

Select the Time column.

Change its format to scientific (with 5 sign. digits).

-> You will see the very same numbers as are shown in LabVIEW:

check.png

 

Best regards,
GerdW

using LV2011SP1 + LV2017 (+LV2020 sometimes) on Win10+cRIO
0 Kudos
Message 4 of 9
(1,331 Views)

Hi gerdw , 

I don't want to change the format in excel sheet . how I read programmatically in LabVIEW correctly. ??

0 Kudos
Message 5 of 9
(1,323 Views)

Hi bhuvanesh,

 

just apply a different formatting to this column - as is done in Excel…

Best regards,
GerdW

using LV2011SP1 + LV2017 (+LV2020 sometimes) on Win10+cRIO
0 Kudos
Message 6 of 9
(1,310 Views)

Hello gerdw ,

different formatting means ?? i need a time as it  like in excel . guide me with screenshot

 

0 Kudos
Message 7 of 9
(1,306 Views)

Hi bhuvanesh,

 

Excel stores time values as fraction of days: "1e-3" equals 0.001d = 86.4s = 1m26.4s.

So all you need to do is to multiply the read time value by 86400 (seconds per day) and format the result using "%H:%M:%S"…

Best regards,
GerdW

using LV2011SP1 + LV2017 (+LV2020 sometimes) on Win10+cRIO
0 Kudos
Message 8 of 9
(1,284 Views)

LabVIEW Date/Time (a.k.a. TimeStamps) are stored according to one algorithm, whereas Excel's "Serial Date" uses a different algorithm.  It can make handling dates and times between the two systems a little tricky.

 

Bob Schor

0 Kudos
Message 9 of 9
(1,262 Views)