Table control data update with LED status progress

[suneelkv]

Hi Friends,

I've a requirement for my project....

But i am not clear of how to implement that.

The main.vi will extract the data from an Excel sheet using all excel.llb and show the data in table  control.

At the back end i'll be keep on reading data from the worksheet 1 of the excel sheet.

so my intention is something like this

whenever it reads the 1st row  of data the LED should blink at the first row and it proceed down as per the for loop

And should continue up to the end.

If anybody have worked out with the Table control and Excel sheet VI's please help.

Your help would be appreciated.

Will attach the VI on request.

Cheers,

Suneel.V

[MikeS81]

Hi Suneel,

i think it is not very effective. You can read the data of the entire sheet with one ActiveX function, just define the relevant range.

If you really need it, define the range for every row to read your data row by row and move your LED indicator.

Hope it helps.
Mike

[suneelkv]

Hi Mike,

Thanks for your prompt response.

Attached are the VI's.

The main VI is Excel_Tablecontrol.vi and the sub vi is excel_read.vi

In the main VI select any excel sheet from your PC and it will extract the first sheet data in it.

But in my real project i will be reading line by line.

Could you please make me clear how should i put an indicator whcih would go line by line.

[suneelkv]

Hi Mike,

Thanks for your prompt response.

Attached are the VI's.

The main VI is Excel_Tablecontrol.vi and the sub vi is excel_read.vi

In the main VI select any excel sheet from your PC and it will extract the first sheet data in it.

But in my real project i will be reading line by line.

Could you please make me clear how should i put an indicator whcih would go line by line.

Cheers,

Suneel.V

[MikeS81]

Hi Suneel,

see the attached example.

Mike

[suneelkv]

Mike,

Yes, this is the example i'm looking for, i'll try to use the same login for my VI and will keep update you.

Thank you.

-Suneel.V

[suneelkv]

read login as logic...

SOrry

[MikeS81]

Hi Suneel,

you can edit your message within 10 minutes.

Mike

Message Edited by MikeS81 on 07-04-2008 09:04 AM

[suneelkv]

Hi Mike,

THis VI is having some bug ...

THe LED is going out of table control if the Table control size is minimized

And also onemore thing....

SInce the data is less its ok

what if data is some 100 lines....

will the sroll bar automatically moves down and also the LED should move down parallely....

Run this VI

Cheers,

Suneel.V

[Andrey_Dmitriev]

Hi, suneelkv,

Are you sure that you need Boolean? It looks nice, but you should figure out, how to synchronize position of the indicator with proper line every time, when table scrolled, moved, etc.
Probably solution with Symbols will be better for you?

Andrey.