UiPath Tutorial || Day 21 : Excel Automation Project - Calculate Student Marks

#RPA #UiPath #ExcelAutomationProject
In this Session:
 We will work on Simple Project to calculate marks of the students

Activities :
1) Excel Application Scope
2) Read Range
3) Assign
4) For Each Row
5) Write Cell
6) Message Box
7) Data Table

 Steps :
1)Excel Application scope we are going to read the excel
2) Read Range -- we are going to read Entire data and save the data in Data Table
3) Assign -- RowNo =1 and Total Marks =0
4) For Each Row --- Looping each and every row in the data table
5) Write Cell --- writing the sum of marks of the students in I cell
6) Message Box --- Display as completed
More Learning Videos
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
● BluePrism ➤
● Automation Anywhere ➤
● UIpath ➤
● Microsoft Power Automate ➤
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

As Always, Please do Like, Subscribe and comment.

[Vijay_]

Good... If it's given also rank it's would be better 💐

[SG-kzbq]

Nice content.Kindly upload calculate percentages in this excel automation.

[efe]

Hey Ameer, great tutorial as always but I have a question for you. Wouldn't you be able to get the same result by using the option that lets you create an "Index" variable at the properties of the "For Each Row" activity instead of using the "Assign" activity to create your RowNo variable like you have done so in this video?

[prashantht.v]

Great Videos and tutorials, Thanks for a detailed Explanation. However, I have couple of questions.
I do not understand, When should we convert a data to String and Data to Integer. This is slightly confusing.
Eg: In this video, You converted "Total Marks" to "Integer" in Assign Window an then converted Total Marks to String in "Write Cell" window. Can you please explain

[kranthipodcaster]

hi good to learn
i have one doubt can you please explain about assign and how it will work and all those things

[susengeorge]

sir how can you put assign ..for calculating percentage

[fazantanveer]

Sir, can u plx upload a video how to create a bot how can we read the info from database

[vijaiganesan]

How to find out the student percentage based on that total. Can you pls. guide me.

[yashmahale]

Hey! Sir why you given () in messages box :-
Total marks.Tostring()

[richasinha]

can you please make a video in excel automation to calculate percentages, rank, grade, remark

[rameshwarprasaad]

Respected Sir,

Thank for sharing useful video

Sir could you pls share what changes did you made in the message box because whenever i am hitting run there is showing message all the time for every calculation

Looking forward!
Many Thanks