LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how to generate excel report daily using write to spread sheet

Solved!
Go to solution

hi

Thank you so much.

I use this code as you suggested.

0 Kudos
Message 11 of 16
(1,494 Views)

Hi Partha,

 

your version gives different result compared with the string approach…

 

You know the problems when trying to compare float numbers?

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 12 of 16
(1,489 Views)

Hi partha,

i tried the same but results were not as expected.

We are using delays,so we may be missing  milliseconds so we will not get the Boolean desired result.

0 Kudos
Message 13 of 16
(1,487 Views)

@GerdW wrote:

Hi Partha,

 

You know the problems when trying to compare float numbers?


Hi Gerd,

 

I'm well aware of the comparison of float numbers. But here my guess was when the two time-stamps (the constant we wire & the output from the function when it becomes 12:00::00.000 AM), are the same (up to ms), shouldn't the Equal? give the True?! Smiley Surprised

 

Or, the output from the time-stamp primitive would be converted to Float internally before comparison? Smiley Indifferent

- Partha ( CLD until Oct 2027 🙂 )
0 Kudos
Message 14 of 16
(1,483 Views)

My suggestion was based on my past experience in an avionics test system project wherein we used to get a lot of raw data from Lauterbach through CAN buffering, in which when the CNA card could not buffer out (read) all the data as against the high speed of Lauterbach, it'd send out empty/junk data against LabVIEW's default time epoch time-stamp (05.30.00 AM, 01-Jan-1904). Then, I wrote a comparison & remove VI based on this kind of time-stamp comparison, and it was working just fine.

- Partha ( CLD until Oct 2027 🙂 )
0 Kudos
Message 15 of 16
(1,481 Views)

@sridhar..reddy wrote:

 

We are using delays,so we may be missing  milliseconds so we will not get the Boolean desired result.


 

Try this! 🙂

 Print Report @ 12 AM Everyday.png

- Partha ( CLD until Oct 2027 🙂 )
0 Kudos
Message 16 of 16
(1,465 Views)