Count filled lines

Learn
, , , ,
1

I need the robot do the reading Excel and print how many lines are filled in the Excel document.

How can I do this?

2

Use a Read Range activity to read the data, then use DtData.Rows.Count.ToString to get the number of rows as a string, where DtData is the datatable you’ve saved the Excel data in. If your workbook does not have headers, uncheck the Add Headers option in the Read Range activity.

2 Likes
3

Can you send me a printscreen, please ?

I couldn’t open the file

4

For some reason, the forums will not allow me to upload anything. Not sure what’s going on with that.

5

Got it to work that time.

Processusvierge.zip (17,9 Ko)

6

did not work here.
When I added a value on the line it brought the wrong result

7

There were 5 records in the test workbook if you do not count headers. If you read the data after you’ve made your adjustments, you’ll get the correct count.

8

@_danielcrruz
You can try to use below package with Get last row activity

9

Can you share your some sample excel file ?

10

Thank yooou!!!

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.