Memory Problem Worksheet.Cell.InsertDataTable

Last post 02-10-2012, 1:21 AM by Amjad Sahi. 3 replies.
Sort Posts: Previous Next
  •  02-08-2012, 3:31 PM 360204

    Memory Problem Worksheet.Cell.InsertDataTable .NET

    Dear I am inserting data into different sheets, and when you reach the third page I encounter this problem 'System.OutOfMemoryException', not how to solve it.

    In advance thank you very much


     
  •  02-08-2012, 10:20 PM 360228 in reply to 360204

    Re: Memory Problem Worksheet.Cell.InsertDataTable

    Hi,

    Thanks for your posting and using Aspose.Cells for .NET.

    Please download and try the latest version: Aspose.Cells for .NET v7.1.0.5 and let us know if it works fine for you.

    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     
  •  02-09-2012, 3:19 PM 360519 in reply to 360228

    Re: Memory Problem Worksheet.Cell.InsertDataTable

    Dear thank you very much, I do not re-appear at the problem, but if I have one last question, what is the maximum number of records that I can export my excel template with this tool? .

    Attentive to your comments
    Esteban
     
  •  02-10-2012, 1:21 AM 360563 in reply to 360519

    Re: Memory Problem Worksheet.Cell.InsertDataTable

    Hi,

    Regarding maximum number of records/rows, this limitation is concerned with MS Excel for XLS and XLSX formats and it depends on the format type. Aspose.Cells does not put forth any limitation but follows MS Excel Standards.

    e.g
    For XLS (Excel 97- 2003)  --> you can have 65536 rows and 256 columns in a worksheet
    For XLSX or other Excel 2007/2010 formats, you may have 1048576 rows and lots of columns in a single worksheet.
    And, you can add/have as many worksheet as you like (it depends upon your resources) in a single workbook  Excel file.

    Thank you.

    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
View as RSS news feed in XML