Find Max and min value from excel using labview

[husssey]

Hi

I have data in excel file and I want to find maximum and minimum value from every column.

So please help required

thanks

[josborne]

You can do that within Excel using the MAX() function, you know?  No need to use LabVIEW.

But if you insist on loading the XLS file into LabVIEW, look here:  https://decibel.ni.com/content/docs/DOC-7991

[apok]

Spoiler

[husssey]

Thanks  apok

in your vi case we have to enter raw and column number so is it possible to find Max and min value from every column without any entering of data from our side. Is it possible to find all Max and min value from excel data sheet by one click only.

thanks for reply

[Ranjeet_Singh]

Use this library file & give input like number of columns & rows.

Later read the values & store into array. Later use this array and pass it to array max & min & get the result.

Let me know if you have any doubt