Export Datagridview data to existing excel sheet

Question

Hi Friends I binded some data from database to datagridview. its binded successully and then i tried to export the datagridview data to excel sheet1 its also export successfully. my doubt is how to use the same excel sheet1 again and again without any change the previous data in excel sheet1?

George eric · Answer

You are trying to use the same worksheet? As i Know one worksheet seems to contain 65 000 rows maxly. If you truly wish to continue that then you can merge worksheets. You can easily achieve it with Spire.Xls . Here is an article from a blog: http://c-sharp-paradise.blogspot.com/2012/04/how-to-merge-excel-files.html  which helps a lot. But please notice it is a commercial ware for developers. SO Choose when You need. I used it to develop my sulotion and feels fine. So I recommend. But Be Careful. Best Luck.