Extract Text From An Image

Have you ever seen a very informative body of text that unfortunately has been packed into an image and you would really like to use that text but unfortunately all fails? It is common to face this issue if you want to

Extract text from an image (most commonly in PDF file format)

Using UiPath and the help of a third party lifesaving software you can perform this task, here’s how:

  1. First you have to download FreeOCR, a PDF editor and word processing service. Basically it can be used to format PDF files
  2. After installing the software, capture all the steps taken to extract text from your image
  3. Convert these steps you have captured in to your UiPath project/workflow and use it for your main application.

Excel File Save As Output Type

Is not it direly important to save your excel file during your tedious work with UiPath. Saving your work only increases the chances of its safety and quick retrieval for later. But if you are trying to:

Save an Excel file in UiPath in CSV format

Then there is a slightly different process to follow than usual. It goes a little like this:

  1. Go to Excel Application Scope
  2. Click on “File”
  3. Click on “Export”
  4. Click on the option of “Change File Type”
  5. Double click on the desired format that shows up
  6. A “Save As” window will pop up, and you can then determine the download destination

Empty Cells Taking Up Space

Whilst creating your excel sheets in UiPath there is a large possibility that duplicate cells take up all your space. The easiest way to remove duplicate cells in an excel sheet without doing it the hard and length manner is by following these steps:

  1. Create 2 data tables, 1 should be filtered and the other with a column header with first column set to unique
  2. Assign a primary key to the filtered date table
  3. Check if the filtered table contains value of “(emp_id)” in the first column inside its “For Each Row”
  4. Install this code in the place of an If condition:
    If ExistingRow IsNot Nothing Then
    
    Remove Existing Row from FilteredTable
    
    Add row.ItemArray To FilteredTable (Array is require because the datarow still belong to Initial table)
    
    Else
    
    Add row.ItemArray To FilteredTable
    
    End if
    

     

Select One Column With If Condition

Selecting a single column from multiple columns that you are provided with, can be done very easily once you have the necessary code to implement. Mostly you have to utilize one of the many activity windows in UiPath. Here is how you can:

Select one column with If Condition

  1. Use the Read CSV activity to transfer your sheet data to a data table
  2. In the If Condition section enter the code:
     dtOutput.Columns.Contains("YourColumnName") 
  3. Also put the default value of database variable as “New Data Table”
  4. Moreover, you have to keep in mind that your database should be completely empty/null. You can check that after reading your CSV sheet

Google Sheets Data In UiPath

Google is surely known to be the biggest service provider around the world. So it is only natural that you would want to utilize its services with UiPath. If you want to:

Read Google Sheets data in UiPath

Follow these steps:

  1. Go to Activities in UiPath and click on Manage Packages
  2. Right click on the left pane and select “Configure Source”
  3. Add a new package by clicking on the “+” sign
  4. Enter the source as “https://gallery.uipath.com/api/v2” and click “OK”
  5. You can see your new package when you expand the “Available” section under Manage Package window
  6. Click on the package source
  7. Locate “UiPathTeam.GoogleSpreadsheet.Activities” and install it

Collecting Contact Information

Swiftly collecting contact information for your company or for a job project is the upgraded version of data entry. Gone are the days where you had to individually collect contact details. With UiPath, you only have to tweak some settings and it can do it for you. Find out how to:

Quickly collect people’s contact info from online websites

  1. Use data scraping and scrape the URL and name for each user that is listed on the webpage in front of you
  2. Data will be stored in data table
  3. Use the For Each Row loop to retrieve the URL of each user from the database
  4. Click on Open Browser activity and pass the URL
  5. Use Click Activity and click on “Show Coordinates”
  6. Retrieve the text value of your choice and append the value into an Excel sheet or text file

Notepad UiPath Squabbles

As everyone may know notepad files play the biggest role in coding, programming and executing similar activities. The simple application is possibly the backbone of all coding tasks. But when it comes to opening a notepad file onto your UiPath workflow and an error comes up, here is when you have to take drastic measures.

  1. First you have to create a text file and save onto your device and remember its pathway
  2. Now specify the pathway as the Arguments field’s value
  3. The name of your text file should become the value of the title element in the selector field
  4. The file name will be automatically generated so it is not necessary that you have to change that.

 

 

Extract Specific Data

Selective extraction of certain data from a big string of data proves useful in multiple situations. Here you will get to know all about how to extract numerical data only from a string of data that is made up of alphabets as well as numbers. Follow the following steps:

  1. First of all you need to create a data table with 2 columns. You might be familiar with this, because the same thing works in excel
  2. Utilize the Add Data Row Activity and add the 2 values of alphabets and numbers to the data row
  3. Now write your data table to an excel sheet with the Write Range activity

Extract Tabular Data From Outlook

Data scraping is possibly the trickiest task to be accomplished in UiPath. There are many little details that can be mistaken, forgotten or confused which leads to the bigger picture being messed up and over complicated. For instance if you are trying to:

Extract tabular data from Outlook

Here is how to do it:

  1. Using the Get Outlook Mail Message activity fetch the mail message
  2. Save the mail message in “.eml” format with the Save Mail Message activity
  3. With Start Process activity open the saved mail message (mail will open in outlook)
  4. Select all the email page and copy it
  5. Paste everything onto an excel file and save the file
  6. Utilizing Read Range activity get the content into a data table.

Convert A List Of Terms Into A Consecutive Line

CSV format has increasingly come in demand nowadays for it has made everyone’s life a whole lot easier. For instance, when you are trying to

Convert a list of terms into a consecutive line and separated by commas

Then this format can truly save your life. This usually is an important skill to know about in the tech work sphere. Here’s how you can do it:

  1. Using this piece of code to help your list turn into a string of words separated by commas:
    arrvalue=strValue.Split(Environment.NewLine.ToArray, StringSplitOptions.RemoveEmptyEntries)
    
  2. After that you are going to want to utilize the Foreach activity to loop through this value so it can repeat.