individual display of elements of excel files on numeric meter

[vjbharadwaj]

Hi

Im new to labview and i need my numeric display ( meter or gauge) to accept inputs from an excel file of 1 coulmn and 10000 rows.

Each element of the excel file i.e each row needs to be displayed to the meter one after the other with a one second delay.

Is this possible to do?

Thanks

Vijay

[RavensFan]

Sure.

Search the forums for how to read data from Excel Files.  Get that data as an array.

Autoindex through that array in a For Loop with a 1000 msec wait function in it.

[vjbharadwaj]

---

@RavensFan wrote:

Sure.

Search the forums for how to read data from Excel Files.  Get that data as an array.

Autoindex through that array in a For Loop with a 1000 msec wait function in it.

---

I have used the read from spreadsheet and got that data as an array. ive also tried using the index array function

problem is when connecting it to a numeric meter as the meter will not accept the indexed aray as an input as the numeric meters or gauges only accept a double source.

[RavensFan]

Attach your VI.

It sounds like you aren't feeding the data into your loop properly.

[vjbharadwaj]

Thanks

ive attached a samplevi  without connecting the meter as im unable to connect it.also attached a sample excel file with data

Thanks

Vijay

[RavensFan]

You said you have an Excel file, but you don't.  You have a CSV file which is a text-based file.

The problem is in your setup.  You need to follow what I said earlier.

Read the file outside the loop, and auto-index the array where you display the values inside the loop.

 

I would recommend looking at the online LabVIEW tutorials
LabVIEW Introduction Course - Three Hours
LabVIEW Introduction Course - Six Hours

[vjbharadwaj]

Thanks for your help.

i have followed your instructions, even if i put the read file outside the loop i still cannot get any compatible display or preferably numeric meter or gauge to work with this setup. ive tried using 0,1,2 etc for the coloumn and still no luck.

[RavensFan]

You didn't follow my instructions.  Your VI doesn't look like the snippet I posted.

And you'll get nothing on the meter if you don't bother to wire the data to it.

[ShamWOW!! · Accepted solution]

Hey there

I noticed that you said you are new to labview. Below is an example of your code that should work, as well as some links that will help you get started. The most different topic that labview has compared to other languages is the concept of data flow, which works very differently from traditional programming, so I linked an article on that below the screenshot. I also linked an article about auto indexing, as that pertains highly to your project at hand.

Another tip is 'highlight execution.' The lightbulb button on the block diagram toolbar will slow down and visualize the program so you can see how the program works in slow motion.

Hope that helps!

Data Flow Programming

Auto Index Tunnels