How to extract row and column from excel?

[MikeMike]

Hi Damiano,

  Thanks for your kind help!! Now I will try to implement the according to suggestion. If any problem I will let u know.

  Once again thanks...

Thanks & Regards:-

Mike

[Damiano]

Mike,

LabVIEW measurement files are nothing but formatted text files. You can read them with some functions like "read from spreadsheet file" or "read from measurement file" (File I/O library).

[MikeMike]

Hi Damiano,

         Thanks for your additional input. I implementing your suggestion in my application And I come across one more problem. But as your knowing what I want to do I thing It's better to get input from you. Out of six parameter 1 one is date andTime parameter(i.e 05-10-2007 2: 28:13 PM). Now this parameter will be always be on x-axis.And according to time stamp x-axis remaining parameter(i.e 2,3,4,5,6) will be displayed against it. Will you please help me in this regard? For fair idea this is the contain of my file:-

 Parameter 1                            Parameter 2    Parameter 3   Parameter 4    Parameter 5

05-10-2007 2: 28:13 PM          12                       34                    23                       25

05-10-2007 2: 28:19 PM          13                       37                   27                        34

05-10-2007 2: 28:35 PM          17                       39                    25                       33 

05-10-2007 2: 30:17 PM           11                       33                    29                        29

  I will be having array in which this values are their. Now x-axis will be have to display parameter1 values. Please let me know how to plot the graph in lab view with this requirment.

Mike                        

[Damiano]

Data seem to be sampled at a non constant period (delay between samples is variable). Is it true? If so it could be a problem. Let me think...and know

[MikeMike]

Yes. Delay between sample collection is variable.

Mike

[Damiano]

Hi Mike,

maybe there is a simple solution to your problem without passing through the conversion into excel file format. You can see your parameters as waveforms.

Listen:

--> use the "read from measurement file" (file I/O menu). Remember to configure (double-click) it correctly .

--> the output of this VI will be an array of signal (dynamic data type).  No fear

--> use the "convert from dynamic data" VI (express-->signal manipulation). Double-click to configure it and choose the option       "1 D array of waveform"

--> At this point you have a 1D array of the waveforms stored in your measurement file

--> Use the "index array" function to select one of the waveforms. once you have done use the "get waveform subset" function      (waveform menu) to select only some samples.

Of course, the index of the array, the start index of waveform subset and the duration input of the waveform subset are input by the user.

I hope this will be useful.

Damiano.

P.S. Please rate my suggestions if you find them good, please. 

[MikeMike]

Hi Damiano,

        I have tried with this but its giving error. I am attaching the vi with .lvm file Please have a look. For time being I am trying to plot all parameter and at letter stage I will try to take input from user for plotting graph. Please correct this vi to plot all the parameter or u can use .csv file if it makes the task easy.

Mike

[Damiano]

ok, I'll try. Be patient, please. I'll do as soon as I can

[MikeMike]

Hi Damiano,

    Thanks for the effort u r taking for me. I will be waiting for the solution from you.

Mike