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)