Need to Import Excel into Lookout 6.

[WaterWorks]

I need to take RiverLevel data which comes to me in an Excel spreadsheet and import it into Lookout so that the data can be trended.

Eg.       LocalTime        RiverLevel

        5/12/2006 7:00          2.75

        5/12/2006 8:00          2.50

        5/12/2006 9:00          2.25

        5/12/2006 10:00        2.00

        5/12/2006 11:00        2.25

        5/12/2006 12:00        2.50

        5/12/2006 13:00        2.75

        5/12/2006 14:00        3.00

        5/12/2006 15:00        3.25

        5/12/2006 16:00        2.50

        5/12/2006 17:00        3.75

        5/12/2006 18:00        4.00      

Thanks
WaterWorks

[Ryan.S]

See this example: http://venus.ni.com/stage/utf8/niepd_web_display.DISPLAY_EPD4?p_answer=&p_guid=B45EACE3DA8B56A4E0340...

[WaterWorks]

I can't access the link you posted.

[Ryan.S]

http://sine.ni.com/apps/utf8/niepd_web_display.display_epd4?p_guid=B45EACE3DA8B56A4E034080020E74861

[WaterWorks]

Thanks for the link. 

Not quite what I need but I am looking at it.

I did find another example using the logger object into hypertrend. 

Which is alot closer to what I need but I have not been able to get it working yet because of the looptimers. 

I was hoping for a simpler solution that would read the data directly from the spreadsheet into

Citadel and then be able use Hypertrend.

[Ryan.S]

I find this example. It works fine.
The time in xls is 2000, so you may not see the data on the hypertrend at first. You need to change the date on hypertrend.
I don't think there is an object that can log an xls file into database directly.