Question regarding the spreadsheet example

[mrdesai88]

Hello everyone,

I am new in the labview.I am using the labview 2013. I am stuck with the one problem.

I have a huge spreadsheet file which have a large number of rows and column. I am able to read out the file but my problem is I am not able to read out the perticular row which have a integer and alphabet. e.g.(I have a file like this)

Port 1  Port 2  Port 3....Port 170

20.55   25.45  26.47     20.45

.          .         .            .

.          .         .            .

23.65   30.67  28.55     29.55  

 Now I have to read out the first row and then make a function that locate the port number. for example if I want port 100 value for calculation then by that function I have to able to find the location of port and then I will use that port column value for the different calculation. Is it possible with labview??

Regards,

Maulik

[FCTesting]

Hi Maulik,

This can be done in LabVIEW, through the read from spreadsheet VI. There is an example on how to use this VI in a similar way to your goal posted on the NI Community.

https://decibel.ni.com/content/docs/DOC-12287

Also for reference:

http://zone.ni.com/reference/en-XX/help/371361K-01/glang/read_from_spreadsheet_file/

[mrdesai88]

Hi,

thank you very much for your reply it would be helpful for me.

but my main problem is I have a 170 column and i want to make a function which directly locate the port.

for example if I write in a function- port 101 then it reads automatically in which row and column this port is and show me that column of port.( I think the row should be the same for all ports but only I have to find is location of the column of port.) 

Example if I type port 101 (ans would be) =[ row 5 column 90] and from column 90 i have to pick values and calculates the other values.

its bit complicated to understand.

regards,

Maulik

[mrdesai88]

Any one find solution for my requirement??

Is it possible in labview?

[KoenR94]

I dont really get what you mean with your example, maybe some code.

But the you can easily read a row from a column using the index array.

[mrdesai88 · Accepted solution]

Hi,

Yes thats the double character I can read. But I have a row like,

e.g ROW 5 : Port 101  Port 102  Port 103 Port 104 ..... Port 171

this type of row I am not able to read. 

Regards,

Maulik 

[mrdesai88]

Ok I got my answer.

Thank you all for your kind help.