cancel
Showing results for 
Search instead for 
Did you mean: 

SAP IRPA take a long time to read excel files in loop

0 Kudos

I have a folder that contains several excel files with the same format and number of rows. Sometimes SAP IRPA is fast to read the file (about 5 s) per file, but sometimes it can be very long with an estimate of one file for 1 minute, any idea how to improve the speed to be more consistent.

1. Get Excel path collection
2. Read the data
3. If meet the condition (TRUE/FALSE value only)
4. Add to transaction data


PS: 1. AppendLog (Custom daily log for user in notepad)

Accepted Solutions (0)

Answers (1)

Answers (1)

Chaitanya_Priya
Product and Topic Expert
Product and Topic Expert
0 Kudos
teguh_ramadhan71

Can you send the screen of your automation which helps better to share the thoughts on improvement?

0 Kudos

Done, i add the workflow

TJe
Product and Topic Expert
Product and Topic Expert
0 Kudos

Had a first look. Guess you should open the Excel Instance before the loop only once and not for all Excel Workbooks. Close Excel Instance only at the end, and you should also include close Excel Instance in case of an error on the automation.