How to extract row and column from excel?

[Damiano]

I don't get any error if I run the VI choosing as input file an Excel worksheet with the following structure:

        A         B          C

1      11      12        13

2      21      22         23

3      31      32         33

and select, for example, the following parameters:

Start row1 col1

end row2 col3

[Damiano]

I don't know what you mean when say "integrate data".

Do you want to concatenate them to obtain a unique graph or do you want to obtain 3 plots? 

[MikeMike]

Hi Damiano,

  Exactly correct What I mean by integrating data is to concatenate it. Since in first iteration I will be geting the data of 2 column and in next iteration i will be getting data from 3 column and next I will be getting data form 5 column. Now, to pass this data to plot the graph I have to combine(concatenate) them. So how can I do this?

Mike.

[Damiano]

simply use the function "build array" in the array library.

remember to right-click on it once place in the block diagram and select the "Concatenate Inputs" options otherwhise you will concatenate row-wise and obtain a matrix instead of an array.

Let me know.

[MikeMike]

Hi Damiano,

   Yes it is working. Build array vi i am using and it is giving correct result. But their is one more problem I am getting. Since earlier I am using the .lvm file for storing the data, I am not aware of how to insert data in the in .csv file. I try to convert the .lvm file to .csv file by simply changing the extention. But the .csv file created from this contain dis formatted data. I also try to do this by providing .csv file insteaed of .lvm in my application but it is not writting into the file.Please let me know how to store data in .csv file.

Mike 

[Damiano]

I didn't understand what do you want to do. Do you want to store the selected data (the ones tou used to make the plot) in another text file? If so you could try to use the function "Write to spreadsheet file" in the file I/O menu and see if the result is OK for you. If not, what do you want to do exactly?

[Damiano]

I didn't understand what do you want to do. Do you want to store the selected data (the ones tou used to make the plot) in another text file? If so you could try to use the function "Write to spreadsheet file" in the file I/O menu and see if the result is OK for you. If not, what do you want to do exactly?

[MikeMike]

Hi Damiano,

     No I do not want to store the data I have collected to plot the graph. What I have ask is very simple i.e How to write data (from which some data will be extracted for plotting graph) in .csv file?   The whole data will be in ,csv file.

Mike

[Damiano]

Very simple. Use the function "write to spreadsheet file" indicating comma (,) as delimiter and your array as input data. You will get a file that you can open with a text editor. You will find all the elements separated by comma

[MikeMike]

Hi,

 I think u miss understand now. I have a file .lvm from which I want to extract data to plot graph. But since Get Excel Value vi does not accept the .lvm file I have to use .csv file. So how I can write data into .csv file. So that this .csv file will be input to the Get Excel Value vi to extract data to plot graph.

  Currently I am using Format Into File vi to log data in the .lvm file. If I want to use Get Excel Value vi this .lvm file will be of no use to me. That's why I want to use .csv file.