Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
655
XamGridExcelExporter Large Data sets and Limitations
posted

- What are the known issues and limitations for the new 11.2 XamGridExcelExporter?

- Is there a size or record/column limit on your end? Or should we be able to fully utilize excel limitations for each format 2003/2007/2010, etc.

- What is the recommended approach or method to handle large data sets? In several of my scenarios I have 100k + Records with 80-100+ columns. Are there any recommended setups for Workbooks, WorkSheets, Export, or anything else that are required or recommended for larger exports? The largest export samples I saw was 10,000, are there other larger tests that have been carried out? I dont have a problem with anything under 50,000.

- In some cases I am getting out of memory exceptions and xml document generation exceptions using both the writer and the new XamGridExcelExporter. Are there known limitations here from infragistics or are we only limited by memory and excel?

Thanks again