How to extract row and column from excel?
in [LabView]
|
From: MikeMike on 9 May 2007 01:10 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
From: Damiano on 9 May 2007 05:40 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.
From: MikeMike on 9 May 2007 06:10 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
From: craigc on 9 May 2007 06:10 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
From: MikeMike on 9 May 2007 06:10
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 |