How To Include HTML table In Mail Body With Dynamic Values – UiPath

Sometimes we might need to send the emails which will contain the tabular data in it… This small HTML template can help you in inserting tabular structure inside the mail body. Implementation using UiPath : In the Html Template file provided, Add the required number of “tags” for the required number of rows inside the … Continue reading How To Include HTML table In Mail Body With Dynamic Values – UiPath

How To Find Common/Uncommon Rows Between Two Datatables – In UiPath

Datatables in programming are commonly used to store the collection of data in rows and columns We might sometimes need to find the common/uncommon items between the two DataTables. Let us see how to implement it!!! Common Values dt_CommonRows = dt1.AsEnumerable().Intersect(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable UnCommon Values dt_UnCommonRows = dt1.AsEnumerable().Except(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable Note: Replace dt1 and dt2 with your appropriate lists … Continue reading How To Find Common/Uncommon Rows Between Two Datatables – In UiPath

UiPath’s Integration With Splunk – Dashboard

Introduction Splunk Inc. is an American public multinational corporation based in San Francisco, California, that produces software for searching, monitoring, and analyzing machine-generated big data, via a Web-style interface. Splunk (the product) captures, indexes, and correlates real-time data in a searchable repository from which it can generate graphs, reports, alerts, dashboards, and visualizations. Splunk’s mission is to … Continue reading UiPath’s Integration With Splunk – Dashboard

How To Transpose DataTable – In UiPath

Few times while working with DataTables, we might want to convert rows to column and vice versa. let’s see how to do that…!!! Example Implementation using UiPath : Let us implement a workflow to convert rows to columns in DataTable. (If you find the logic a little difficult to understand, no worries please leave a … Continue reading How To Transpose DataTable – In UiPath

UiPath REFramework Templates For Queues, Excel, And Mails

REFramework aka Robotic Enterprise Framework is a framework which is provided by UiPath to help developers build RPA processes quickly and efficiently. It can be used as the starting point to all the UIPath Projects. It offers robust exception handling scheme and event logging for all exceptions and relevant transaction. Different business processes may operate … Continue reading UiPath REFramework Templates For Queues, Excel, And Mails

How To Delete Sheets From An Excel File Programmatically – In UiPath

Sometimes we might want to delete unwanted sheets from an excel file. We can do it through different means .i.e VB.net code, Powershell Script, Python or 3rd party Uipath activities… Let’s see how to do it using PowerShell script for now 🙂 Example Implementation using UiPath : Let us implement a workflow to delete unwanted … Continue reading How To Delete Sheets From An Excel File Programmatically – In UiPath

Introduction To UiPath Licensing

Before we explore the different available licenses, it’s important to know about the different UiPath products. 1. Studio: Used by developers to build the automation projects. 2. Robots: Executes the process designed in the Studio. There the dedicated licenses for each robot type: Attended, Unattended and Non-production. 3. Orchestrator: It is a web-based platform to … Continue reading Introduction To UiPath Licensing

How To Read/Write To Text File – In UiPath

We use text files a lot during our daily work, So does the RPA. Let’s see how to read and write to Text file!!! Example Implementation using UiPath : Let us implement a workflow to write the data to a text file, then read data from it and then again append some text to it. … Continue reading How To Read/Write To Text File – In UiPath

How To Read Values From DataTable(Excel) – In UiPath

During automation, we deal with a lot of data in the form of Text files, Excel sheets, and many other such sources. For now, let us consider Excel’s data. Let’s see how to read the values from DataTable!!! Example (Article +Video) Implementation using UiPath : Let us implement a workflow to read values from DataTable(Excel) … Continue reading How To Read Values From DataTable(Excel) – In UiPath