How to change the excel sheet dynamically using vb .net or java
Visual Basic
2
Posts
2
Posters
0
Views
1
Watching
-
I have an records near about 2.5 lac but excel sheet(sheet1) can contain maximum of 65 thousand now how can I transfer the records to the excel sheet . my application gets hang. :(
Excel simply isn't going to handle this. Excel's limit cannot be changed. The only way you'll get more rows is to add more sheets. But, even if you do this, I doubt you'll get 2.5 million rows into Excel, no matter how many sheets you use. It sounds like you're trying to treat Excel as a database, something which it's not designed to do.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007