I have 4,22,049 rows to be added to a datatable, but after 342nd row datatable is not accepting any values. Has anyone faced an issue like this before?
Please help.
Thank you!
Hi @anushka.prasad,
How are you adding rows to datatable? manually or via read range via excel?
Is it throwing any error at 342nd row?
Regards
Sonali
Check if anything specific different with data on the 342nd row. Also any error you are getting?
Hey @anushka.prasad inserting all data in 1 time might be caused because of the RAM size issue.
Ensure that your machine has sufficient RAM to handle large datasets
instead of adding all 4,22,049 rows to the DataTable at once.You can read the data in smaller batches (e.g., 1000 rows at a time) and process them in smaller blocks to avoid memory overflow.
cheers