Read and Writing data into excel file when the input contains approximately 10,000 records or data in SharePoint

Hey All,
I have input data in my local approximately 10,000 records and i need to write it into one excel file which was in SharePoint folder.

If my input contains below 10,000 records my bot has been read the input data and inserted 5000-7000 records successfully without any issues but when the input contains 10,000 records it was unable to read and write into file in SharePoint…

Below is the error screenshot

Hey!

Is there any limitations in SharePoint to store the data?

Instead of looping through the excel .

Use Autofill,LinQ to paste the data

Regards,
NaNi

As we faced issues with big files where you have thousands of records and we have API Limitations.

We recommend using the new For Each Activity such as For Each File or For Each Row in Workbook and iterating through the records.

Behind the scene, this approach doesn’t load your memory and don’t have a size limitation.

Let me know if it solved your issue.
Thank you,