Finding minimum value from spreadsheet

[jyotia]

I want to find minimum value from already saved spreadsheet (B column) containing about 300 readings. Also how to find minimunvalue of XY-Graph and its corresponding index.

[srikrishnaNF]

Hi jyotia,

  Can you attach your spreadsheet also?

Thanks and regards

[nolsqn]

read the whole array of column B from the spread sheet and use the function MIN and MAX value from the array's plate. 

[jyotia]

This is my readings' spreadsheet file attached over here. I want to calculate minimum value of column D.

[srikrishnaNF]

Hi jyotia,

  I am attaching a VI which will read your excel sheet and disaply the minimum value as well as minimum index.

Thanks and regards,

srikrishnaNF

(remember program is in Labview 9.0)

[jyotia]

Thank You ShrikrishnaNF,

but the problem is, I dont have LabVIEW9 in my lab. So can you please help me with 8.5 version.

[srikrishnaNF]

Hi jyotia,

  Here it is the VI with labview 8.5 version

Thanks and regards,

srikrishnaNF

Message Edited by srikrishnaNF on 03-17-2010 07:27 AM

[jyotia]

Thank you very much ShrikrishnaNF for Read Excel code.

Now I am having another spreadsheet in which graph is also ploted. My aim is to plot column A against column C and calculate area under all individual curve sepatately (there are 12 curves in the graph attached).

Can you please help me with this. (with LabVIEW 8.6)

[srikrishnaNF]

Hi jyotia,

  I am attaching the VI to calculate the area too.Please find it in the attachments.

Thanks and regards,

srikrishnaNF

[jyotia]

Thank You ShrikrishnaNF for the VI. But the VI sent by you is showing broken arrow. screenshot of error list I am attaching here.

thanx