While working with Excel, sometimes it’s necessary to find the number of records available in it.
Let’s see how to do that!!!
total_Count = my_DataTable.Rows.Count
Note:
my_DataTable : The DataTable you are working with
Example
Implementation using UiPath :
Let us implement a workflow to count the total number of rows in Excel.
Step 1:
Drag “Excel Application Scope” activity into the designer panel and supply the “File Path” to it. (Sample file has been attached in the link provided at the article’s end)
         Â
Step 2:
Drag “Read Range” activity to read the Excel data and pass the mandatory fields to it like “Sheet Name” and output DataTable variable
Step 3:
Drag “Message Box” activity to display the rows count.
I am an engineer by profession and by heart :)
It's been 7+ years since I have been working with software development and robotic process automation.
I have implemented close to 80+ RPA processes in total by using Uipath.
It is so true that someone learns more by not reading something but by practicing the skill.
I have been trying to understand exactly where people who are just starting out their career struggle and understand the pain of struggling for hours trying to figure something out.I can help you with that.
Having a passion to share my piece of content, I have created step-by-step easy-to-digest courses.
My goal is to help you get ready for the future by learning new talents and becoming more productive by providing you with relevant and useful courses.
I'm still learning and exploring my field of work :)
Every feedback should be as valuable as you are to me, please feel free to reach out to me if you have any feedback, questions, or need any help.Thank You...
View all posts by Sharath Raju
          
