In a UiPath automation workflow, an activity designed to extract data from an excel file is intermittently failing with a ‘Read Range’ error. The workflow work correctly on some occasions but encounters issues sporadically. The excel file being accessed has a large number of rows and columns, and the issue is occurring without any clear pattern related to the content of the file or the system’s performance. How to get this issue solved?
Hi @Conradmax
The Read range workbook will failed when the activity takes a lot of time to read the excel file.
This happens because there are a lot of rows in the excel file. So, Use the excel activities Instead of the reading the excel, Do the excel amnipulations.
Hope it helps!!
–>Use Workbook Activities : Instead of using Excel Application Scope, use Workbook activities which are more lightweight and do not require Excel to be installed.
–>Read Data in Chunks: Instead of reading the entire file at once, read it in smaller chunks. You can achieve this by specifying ranges or using loops.
→ Increase Timeout: Adjust the timeout property of the activity to give it more time to complete.
2 Likes
1 Like
Welcome to the community
- What is the error you are getting?
- Did you try with workbook activities?
- Is the file being used multipel times in the process if so try to club the activitirs and reduce opening and closing
- Is the temp folder full?
Cheers