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.

'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 conflitsThanksKoolprasd2003Editor, DotNetSpider MVMMicrosoft MVP 2014 [ASP.NET/IIS]