Extract higher value

Hey all i have a excel file with multiple sheets in those sheets i have to extract the highest num from. Those multiple sheets any suggestions

@singh_sumit ,
Can you share the sample input file if possible?
You can refer this below workflow.

Excelactivity.zip (2.4 KB)
Excelactivities.xlsx (10.2 KB)

Regards,

Hi @singh_sumit

You can bring up all the data available into a single datatable & use the following query in the Invoke Code activity to get the highest of them:

Dim highestRow = dt.AsEnumerable.OrderByDescending(Function(row) row.Field(Of Double)("document number")).FirstOrDefault()

Here, dt is the datatable & highestRow is of type DataRow.

Hope this helps,
Best Regards.

Can you send me a zip file of that process