UiPath not responding error when trying to write data from excel to dt

Help
, , ,
1

Hi All,

in one of my process i am getting an excel file as an input which containing 7 to 10 Lakh records average and i need to process all rows.

So i tried to split this excel into more then one excel (2 Lakh records in every excel).

I implemented this using loop concept.Bot adding chunk of rows in dt and pasting it into different excel every time. Here i have one problems-

Problem is that when i am running code some time its processing 4 lakh, some time processing 6 Lakh and stopped working… It showing error that “Uipath not responding.”
Excel input is same each time.

Can any one suggest what need to do.
:slightly_smiling_face:

2

Hi
Welcome to uipath community
Were we facing any issue when processing the datatable as a whole
Cheers @Techypanduit

3

@Techypanduit

Hi,

You can try using this custom activity.

https://go.uipath.com/component/read-extra-large-spreadsheets

4

Yes, i tried this option, in this case i got error that “uipath not responding” , not sure but may be it require more memory to process.
So i came through second option where i can read data in chunk of 2 lakhs rows and process them in separate excels. Here again same problem after processing 6 lakh records it giving error “UIPath Not responding”.

Now the solution which i found for this problem is i am using chunk of 1 lakh rows at a time and it’s working fine.

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.