UiPath Q&A: How to sort an Excel column with month names (Tutorial) скачать в хорошем качестве

UiPath Q&A: How to sort an Excel column with month names (Tutorial)

This video tutorial shows how to sort an Excel column with month names with the RPA tool UiPath. 📸 Instagram:   / 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:    • My UiPath Groups - You're invited 🙌 (Faceb...   VIDEOS FOR YOU: 🔹 UiPath DateTime (.NET) Full Tutorial:    • UiPath - .net DateTime - Full Tutorial   🔹 How to Sort and Lookup a DataTable in UiPath:    • How to Sort and Lookup Data Table in UiPat...   FOLLOW ME: 💼 LinkedIn:   / andersjensenorg   🐦 Twitter:   / andersjensenorg   📸 Instagram:   / andersjensenorg   👨 Facebook:   / andersjensenorg   👨‍👩‍👧‍👦 Discord:   / discord   💌 Email Newsletter: https://andersjensen.org/email-newsle... 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. #uipath #excel #roboticprocessautomation