Automatic hall ticket generator using RPA in UiPath studio

Here's about automatic hall ticket generation using UiPath studio making use of RPA(Robotic process automation). So basically in order to use the UiPath studio you need to download and install it.

So then in the home page , in the new project section click on process. Then a pop up will appear , give the name of your project then give some description and also choose the location to save your project. Then click on create.

Now a new window will open , in that we can see activity section and UiPath community section , in this click on open main workflow. Then now we can start building our project using the required blocks from activity section.

So now to create an automatic hall ticket generator we need to have an excel dataset and a template of the hall ticket in Microsoft presentation. Below is the excel dataset and the draft power point template(just for reference).

So start by taking a sequence from activity panel then drag and drop it, then search for “Excel application scope” activity drag it and drop inside the sequence activity then within the excel application scope give the location of your excel file. Then drag and drop read range activity within the excel application scope.

Within the read range activity , in the properties panel in the input part give the sheet name as “Sheet1” (along with double quotes). Also assign the output DataTable in properties as readData. Also create a variable as readData of type table , no need to give default values.

Then add the “for each row in data table” activity then in for each current row give the just created and assigned variable name ie. in my case it it “readData” , then check the custom count , its value is 9 in my case.

Now add the assign activity , then since here in the template we are going to replace the name, reg no. , date of birth fields just create those variables and give the type as String , also assign these parameters to CurrentRow.Item(1).ToString , do as shown in the below figure.

Now include the “use power point presentation” activity, then within that give your template file location then reference as power point , check the create if not exits box.

Then within the do of power point add the “Replace text in presentation” activity from the activity panel, then in ‘find what’ give the specified text to be replaced from the template and in replace with give the variables that we have assigned or created like name etc. refer the below figure

Then add save presentation as PDF activity below this , give the location where you have to save the pdf (example “C:\location\your_loc_name\location\Documents\print "+name+".pdf"). That’s all hence we ‘ll get the pdf of hall ticket with replaced by the names from Excel file in power point template.