This video tutorial shows how to sort an Excel column with month names with the RPA tool UiPath.

📸 Instagram: https://www.instagram.com/andersjensenorg

The solution is simple, and we will create a supporting column that will convert the month name into a month number (1-12) and sort based on the number.

I get a lot of great questions, and this one is from Instagram from my follower “anusajit1”.

Do you have a UiPath question: https://youtu.be/C6xmGfEL07I

VIDEOS FOR YOU:
🔹 UiPath DateTime (.NET) Full Tutorial: https://youtu.be/rk8h3Ggb9ew
🔹 How to Sort and Lookup a DataTable in UiPath: https://youtu.be/drwKgS7SkeY

FOLLOW ME:
💼 LinkedIn: https://www.linkedin.com/in/andersjensenorg
🐦 Twitter: https://twitter.com/andersjensenorg
📸 Instagram: https://www.instagram.com/andersjensenorg
👨 Facebook: https://www.facebook.com/andersjensenorg
👨‍👩‍👧‍👦 Discord: https://discord.gg/d8KQpTUvFD
💌 Email Newsletter: https://andersjensen.org/email-newsletter

0:00 Intro
I got a lot of great UiPath questions and decided to solve some of them in videos. I will prioritize content over the technical setup in this series. Expect less good sound, raw footage, and not much zooming and graphics. Anusajit1 made a great question about how to sort an Excel column with month names.

1:16 Read the Excel data
In an Excel application scope, we use a Read Range to read our data into a DataTable.

4:18 Convert month names to numbers (integers)
We add a supporting column to take the month name and covert it into a number (integer). In this way, we can later sort the data. To convert the month name to a number (integer), we use an Assign with a bit of VB .NET code.

10:19 Print results to Excel
We write our results on a new Excel sheet. This is good because then we don’t delete our initial data.

11:30 Sort Data Table and Delete column
We use the Sort Data Table to sort the month names (numbers) and delete the supporting column afterward.