Excel Automation task


#1

Hi All,

I am new to uipath here i have one conversation i have to do one task on excel that is we have the or more excel files with data i have to read each and every row of excel and want to get minimum value and maximum value from each of the excel and it has to store another excel can any one give idea about this

Thanks in Advance


#2

@certified


#3

Can you please be more specific how you want to fetch maximum value from each row in excel sheet or maximum value from particular column in excel?


#4

Hi Lokesh,

Thank you for your response i want to get maximum and minimum value from
overall excel sheet by reading each row and column


#5

Can any one help me ???


#6

Hi,

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