Reading data from Excel File line by line and display it into indicators

[*E*]

I need to read data from a excel file. The excel file maybe 1-4 columns. And the amount of rows  may be 400+

I need the program to loop down through in a while loop and display all the values in each column and row. For example all data in column one be displayed constantly changing as it appends down the rows. Same as will column 2 and indicator 2 etc. Lastly i would like to be able to see the values on the front panel indicators changing.I attach 2 screenshots.

Can anyone help?

[Dennis_Knutson]

Easiest is to save the Excel file as tab or comma separated data and then use the Read From Spreadsheet File. That will read the entire file and convert it to a 2D array. You can then index the array as you wish in the loop. Otherwise, you will need to use ActiveX to read the file. If you have the Report Generation Toolkit, it's a relatively simple thing to do and shown in the examples that come with it.