balupad14
(Balamurugan)
November 28, 2019, 10:03pm
1
Hi ,
I have shared that how to sort the data in Excel.
I have the EmployeeData Excel file. I have to sort data based on bdate column.
Before sort the data :
After sort the data :
Design Screen
Sample : ExcelSort.zip (85.9 KB)
Regards
Balamurugan.S
12 Likes
balupad14
(Balamurugan)
November 29, 2019, 7:22am
3
Thank you @Lahiru.Fernando bro…
1 Like
balupad14
(Balamurugan)
November 29, 2019, 7:27am
5
Thank you @kommijeevan … I think . You have updated your profile that I can able to see your face. Nice…
2 Likes
Nice Explained balupad14 Sir.
1 Like
Awesome Bala, you’re amazing
1 Like
balupad14
(Balamurugan)
November 29, 2019, 9:55am
9
Welcome to UiPath Forum ! Thank you @VanessaCova …
balupad14
(Balamurugan)
November 29, 2019, 10:01am
10
It’s Ok @ balupad14 Sir.
1 Like
balupad14
(Balamurugan)
December 20, 2019, 5:47pm
12
Hi Friends,
It is an update with this thread. If already exists the table by using the Create Table , I will throw and error that already exits the table. So before create the table better we can verify that the table exists or not. I have developed an activity called “Get Table”. It will return the all the table which are exits in the Excel Sheet.
I have developed a new activity called “Get TableName”. It retrieves table name from the excel sheet. It returns it as List string.
Excel
[image]
Namespace :
[image]
Design Screen :
[image]
Sample :
ExcelSort.zip (87.2 KB)