LabVIEW for LEGO MINDSTORMS and LabVIEW for Education

cancel
Showing results for 
Search instead for 
Did you mean: 

search and read from an excel file

Solved!
Go to solution

Hello everyone, i was wondering if it is possible to make a labview code that reads data from a specified column on a excel file(or CSV), by searching for that column by name and not by index, and then importing its data.

 

As of now I'm using this code that extracts data by index (2,3 in the example shown below) but i want to make it more dynamic so other colleagues can use their own csv/excel files and won't have to change the index of the code incase their csv's are built differently  

Thank you. 

youvvvv77_0-1715585782735.png

youvvvv77_1-1715585824716.png

 

 

0 Kudos
Message 1 of 4
(1,385 Views)
Solution
Accepted by youvvvv77

Hello

You can use an excel template file to name cells. In that way you can read by name.

Only problem is that if the customer changes the names you need that new template.

 

greetings from the Netherlands
0 Kudos
Message 2 of 4
(1,364 Views)

Hi Albert, yeah i'm kinda having trouble with the "read by name" part (cells are already named), I'd really appreciate your help if you have an idea.

Thank you 

0 Kudos
Message 3 of 4
(1,335 Views)
Solution
Accepted by youvvvv77

It is a long time, since I used that.
We had customers that wanted to change layout and colors, so we used a template excel to keep them compliant.

 

So if you send your vi instead of pictures of a part of the vi, maybe I can find a problem.

Best a vi with data and an excel file,

greetings from the Netherlands
0 Kudos
Message 4 of 4
(1,312 Views)