Hi Vijay,
I am not sure what exactly the issue you faced. but I will suggest you do not use write collection for huge data and it will make your process slower. if possible try to use copy paste operations from excel to excel it will more fast and quick.
I have used write collection for 1-10 columns with less data (may be max 300 to 500 rows) but I didn't faced any error.
please explain in detail how you are implementing.
------------------------------
Mahesh Kushare
Sr. Consultant
Capgemini Solutions Canada Inc
Toronto
2269886490
------------------------------