How can we read the excel file?

Help Activities
, ,
1

Hi All,

How can we read the excel file which contains 700000(7Lakh), in UiPath??
I am trying the same using the Read range workbook activity but it’s taking so much of time to read.

Thanks in advance.

2

Hi @naveen.s

Use Excel activities

Regards,

1 Like
3

Hi @naveen.s

use the macros (Invoke VBA) to run the code for excel files which has huge data and it will help to execute the code in less time.

Regards

1 Like
4

Hi @naveen.s
Instead of reading the excel. Use excel activities,macros(VBA)

1 Like
5

@pravallikapaluri
will reading excel activities helps to read faster??
How can I use the Macros??

6

@vrdabberu
How can I use the Macros??

7

@lchirathapudi
will reading excel activities helps to read faster??

9

@naveen.s

excel process >> use excel file >> invoke vba

In the invoke vba place the macros code and it will make all the changes in the excel file which you have mentioned in the use excel file activity.

Regards

10

HI @naveen.s

Please check the below video for better understanding

Regards

11

@naveen.s,

Use Excel as database approach. Follow this article.

Thanks,
Ashok :slight_smile: