How to extract row and column from excel?

[MikeMike]

Hi,

 I am new to lab view. I have an apllication which will store the parameter in excel sheet(excel have 6 parameter(i.e column) and 1000 rows). I want to extract data from the excel sheet and plot the graph of it according to user selection. If user select column 2,3,6 and rows 250 to 300 then all the element in the rows 250 to 300 and column 2,3,6 get extracted and will be plotted on lab view graph. How this graph can be plotted in lab view?

Thanks & Regards:-

Mike

[Damiano]

Take a look here

http://zone.ni.com/devzone/cda/epd/p/id/3409

and don't forget to rate

[MikeMike]

Hi Damiano,

  Thanks for your reply.But the link you have given some .llb file to be implemented in vi to read the excel row and column wise. But I have no idea of how to use this .llb file in my project. Can u please help me out?

Thanks in advance.

Thanks & Regards:-

Mike

[craigc]

Hi Mike,

If you look at your other thread i gave you an example of how to pull the data from the spreadsheet using a .csv file into a 2D array.  Once you have the 2D array, use the index array vi's in the array pallette to pull out the columns (or rows ) you desire.  you can then use the split 1D array to get a subset of numbers.

Craig

[Damiano]

You can start getting familiar with tjis library. Open the file  "Get Excel Values.vi" and run it. Moreover you can take a look to its block diagram to understand what VIs are used and how they are arranged. Once you have undestood the main things you can start creating your own VIs using the VIs in the library. Note that in the library there are many VIs that allow you to ritrieve data from Excel worhsheets in different formats.

Good Luck

P.S. don't forget to rate, please.

[MikeMike]

Hi Craigc,

  As per ur sugession I have used index array vi. But the problem is that this vi will return only single value at a time. What I exctly want is if user selects column number 2,4,5 and rows 50 to 100. Then i should get data from 2,4,5 column from 50 to 100 rows. As these vi returning single value i have to call this vi number of times. Is their any simpler way to do this?

 Mike

[craigc]

Hi Mike,

I made you a quick example on your other thread,  If you have any questions can we please keep them to your other thread as this is getting confusing :s

Good luck

Craig

[MikeMike]

Hi  Damiano,

    I have open the file Get Excel Values vi and try to run it. But it is showing the error. I try this by passing by .lvm,.cvs,.xls but it is showing error. Do u have any idea why error has coming?

Mike

[Damiano]

tell me what kind of error you find

[MikeMike]

Hi Damiano,

  Thanks!! Now it's working. Now my next problem is if user has given that he wants to see the graph of coulmn number 2,4,5 and rows 5 to 40 then what I should do. Using Get Excel Values vi i will provide start column as 2 and start row as 5 and end column as 2 and end row as 40, So now I will be having data of one column. Same way I can collect data from other column. Now how can I integrate the data from all this 3 column and provide it to the lab view graph vi?

Mike.