Excel file read

Help Activities
,
1

I’m having an xls file with an ‘n’ number of rows so when I’m using Excel application scope it reads only first 9 rows, and when using Excel process scope it just starts reading the file and never ends the process.
Any solution for this on how the read large Excel files?

2

Hi

welcome to UiPath forum

Is it like read range activity is set with some range
Would recommend to check that once

Or if you feel like that doesn’t solve then we can read the same file with workbook activity

Search as workbook in activity panel and u get same set of activities as u see in excel

From that use read range and try again
This doesn’t need excel application to be installed and excel application scope
Directly we can use and read

Cheers @Ritik_Ingole

3

Hi @Ritik_Ingole, welcome to the Community.

Please make sure you do not mention the range for the Read Range activity. Please build the excel reading activity as mentioned below:

image

Hope this helps,
Best Regards.

4

@Ritik_Ingole

Welcome to forums

Can you try with other Excel file you have?
If that is reading fine then you can copy the existing file details to another file
There might be an issue with the existing Excel file

Thanks,
Srini