Count rows in Excel

Help StudioX
,
1

Hi, I would like the robot to give me the number of rows in excel without the header.
What I am doing:

  1. read range (activity from excel), write to the variable “test”
  2. set variable value test=test.rows.count - but shows error “Value of type integer cannot be converted to datatable.
    How can I solve this? :slight_smile:
2

@sullivanne,

You are assigning integer type of data to a datatable variable.

Declare an integer type of variable and then assign

intRowCount=test.rows.count

3

Thank You, but the robot instead of the number of rows shows me the name of the sheet in message box :frowning:

4

@sullivanne,

Can you please show how you are using the activities for this. Looks like something got configured incorrectly.

5

The image shows a UiPath workflow that reads an Excel sheet into a DataTable, counts the rows, and displays the count in a message box, with variables 'test' and 'test2' configured in the Variables panel. (Captioned by AI)
The image shows a UiPath workflow that reads an Excel sheet into a DataTable, counts the rows, and displays the count in a message box, with variables 'test' and 'test2' configured in the Variables panel. (Captioned by AI)1353×694 44.5 KB

Thank You :slight_smile:

6

Hi, Change the log message variable to ‘test2’ instead of ‘test’

1 Like
7

@sullivanne,

Use test2 variable in message box

1 Like
8

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