Not able to read excel data by using read rang

Help Activities
, ,
1

we have a large no of data in the excel file which will be more than 1lakh I am using read rang activity to count the data but I am getting Could not read range . please help me with your suggestion

image

3

@Chauhan_Nagesh Its not due to large number o data. are you using excel scope?

4

@Chauhan_Nagesh

Just you want to find out the number of rows in that excel file right ?

If yes then use Workbook Read Range activity to read the data from Excel file. It will give output as DataTable. Let’s say dtInput. And then try below expression to find out the number of rows.

              dtInput.Rows.Count
5

Hello @Chauhan_Nagesh

If you are using modern design, do as below.

  1. use “use excel activity” and select excel.
    2)use read range activity and select the sheet
    3)use assign message box and give “yourDT.rows.count”

yourDT is the datatable from the read range activity.

6

HI @Chauhan_Nagesh

Have you tried with Workbook Read Range activity Instead of Excel activity.

If possible share the dummy excel file with us?

Can you share the Version of Studio and activities

Regards
Gokul

7

have use Workbook read rang but i got the same error

8

Hi @Chauhan_Nagesh

Share the above detail it could be helpful to resolve your query

Regards
Gokul

9

Thanks for your Response the issue is resolved there was an unwanted data in excel sheet that’s why bot is not able to read the file

10

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