You must Sign In to post a response.
  • Category: .NET

    Exporting issue into Excel with large dataset.

    I am working with Aspose.cells for exporting data into sheet. My resulting dataset have above 100000 records and excel taking records up to something 65,000 after that all records i am missing, so for that how to split dataset into two data tables so that i can get it and how cal i get remaining records in second sheet of same workbook.
  • #763275
    Hello Gorakh Jadhav,

    If you are using Office 2003 than you can store 65,535 rows.

    In later versions 2007, 2010, 2013 you can store upto 10,48,576 rows.

    So you can store 1,00,000 records easily. Try to use Excel 2007 or 2010.

    Hope this will help you.

    Regards,
    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"

  • #763282
    'Aspose' is third party component, you should check for their help forum, they will help you more in order to resolve the problem.
    As nirav said, Excel 2007+ has increased their limit, so you can try on them.
    Alternatively you can fetch records in batches to avoid the conflits

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]


Sign In to post your comments