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