Excel Automation task

[ddpadil (Dilip)]

Hi,

var maxRow = dt.Select(“ID = MAX(ID)”);
var minRow = dt.Select(“ID = MIN(ID)”);
Did you refer below topic.

Find Max value from datatable

I am using a write text file, in order to save it to a new notepad file. it will write out the highest number, but says it is 9, when the highest number is actually 980.304007 I have : row(“Close”).ToString.AsEnumerable().Max it seems as if it is not returning the full value and I also need to return the date associated with the highest value. I have attached the csv file I am talking aboutGOOG_YahooFinance_Data.xml (12.4 KB)

How to find the highest value in a CSV file

Well @sharks14 You can try @sfranzen way as well but i have also one more way to do this No need to use for each for this You can get the highest column value for “Close” Column like this Int maxval = Convert.ToInt32(data.Compute("max([Close])",String.Empty)) one more way is Datatable.select() as @sfranzen mentioned. there one more is to use IEnumerable.max method as well String maxval = datatable.AsEnumerable().Max(Function(r) r("Close")).ToString …