How to show the range of data?

[CHAN_Hiu_Fung_Victor_Stud (CHAN, Hiu Fung Victor [Student])]

Hello guys, as the Excel file shows the ID is from A to E this time, how can I show the range A-E in the Excel file by using UiPath, when the robot reads other Excel files, the range may vary for example A-Z, A-T, etc. How can I show the range? Thank you for the help!

[vrdabberu (Varunraj Dabberu)]

Hi @CHAN_Hiu_Fung_Victor_Stud

→ Use Read Range Workbook to read the excel and store it in a datatable say Dt.

→ Use the below syntaxes in Assign activity:

First= Dt.AsEnumerable().Select(Function(row) row.Field(Of String)("ID")).FirstOrDefault()
Last= Dt.AsEnumerable().Select(Function(row) row.Field(Of String)("ID")).LastOrDefault()

First and Last variables are of DataType System.String
→ You can print that in Message box by below syntax:

"Range= "+First+"-"+Last

Regards

[CHAN_Hiu_Fung_Victor_Stud (CHAN, Hiu Fung Victor [Student])]

Thanks for your help!!!

[vrdabberu (Varunraj Dabberu)]

You’re welcome @CHAN_Hiu_Fung_Victor_Stud

Happy Automation
Regards