Skip to Content
0
Jan 24, 2022 at 04:49 AM

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

143 Views Last edit Jan 24, 2022 at 05:54 AM 2 rev

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.

read-excel.png

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)

Attachments

read-excel.png (149.5 kB)