Excel Read option is taking too much Time

Help
1

I’m running a process which contains an excel file of at least 10000 lines. So whenever I run the process, the excel read option is taking too much time( more than 8+ hours). Previously it didn’t take time like this. For this my bot it running slower than before.
I’m thinking about changing the excel file format if it helps.

2

@nibir08

For 10,000 rows it won’t take that much time. Could you please check with Excel Workbook activities and then try once.

3

I processed 7k lines task before but back then there was no problem. I just recently faced this problem.
the process is already in production

4

Hi @nibir08

Are you using excel application scope or the workbook activities to read the file?

Is this happening in only production environment? How about the development machine?

5

I’ve used excel application scope and read range activity. When it was in development phase it worked perfectly fine. It also worked fine in production phase too. But recently I’ve faced this problem in production phase. One thing is that it happened when I activated the studio license to enterprise edition.

6

Hmm
Fine
Kindly reactivate the license and try once pls
Cheers @nibir08

1 Like
7

sure I’ll try to do that and let you know

1 Like
8

almost same as our problems. but our problems are not only limited to Excel activities. work fine in development machine but as slow as turtle in production machine :frowning:

9

did u find any solution?

10

Not , I m looking for solution as well. the last option is to refresh the server and reinstall studio/orchestrator .

11

The problem was solved by refreshing server and changing excel file. May be the process was too heavy for the system.

12

Are you using Workbook or Excel Application Activity scope…?? I have also faced similar kind of issue that time I was using Workbook activity in Process flow. For 10*10 data It was taking around 4-5 Minutes. I have changed the Activity from Workbook to Excel and It was working fine.

1 Like
13

@nibir08 have you resolved this issue? I have had the same problem for a month now and can’t find the answer anywhere. It takes 3 minutes to read a 100 row spreadsheet when it normally took 2 seconds. I also recently moved over to enterprise.

14

@mattjh09 My problem was solved by changing the excel file and I used excel workbook instead of excel application scope. you can try this see if it works out.

15

Removing “Preserve format” worked form me. The activity speeds up dramatically…!

1 Like