Exporting FlexGrid with 70k+ cells

Exporting FlexGrid with 70k+ cells

Posted by: szymon.piekny on 16 August 2022, 8:28 am EST

• 

  szymon.piekny

  • Post Options:
  • Link
    Copy

  Posted 16 August 2022, 8:28 am EST

  Hello
  
  I have problems with exporting FlexGrid:
  
  I use method SaveExcel it take ~2minutes, it is too time consuimg.
  
  The another problem is that after export, the style file contains too many styles:
  
  
  
  In fact the FlexGrid contains only a few styles.
  
  When I want to open the file, Excel crash and doesn’t apply the styles to cells.

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 17 August 2022, 3:09 am EST

  Hi,

  We tested the issue you mentioned by using sample data containing 100k rows and 6 columns, but we did not face any issues while exporting. We also altered some styles in the C1FlexGrid and we did not see any issues in the exported styles.xml file either. The export took nearly 3.5 seconds to complete on our system. Kindly refer to the attached sample showing the same. The sample also contains the exported excel file.

  Could you please provide a small sample or update the attached sample to show your implementation and the issue you are facing, so we can investigate further and assist you in the best way possible?

  Also, please let us know the exact version of the C1FlexGrid you are using and provide some sample data similar to the one used in your application, as the time taken for the export can depend on that as well.

  Attachment: ExcelExport_Fg.zip

  Thanks, and Kind Regards,
  
  Kartik