SpreadJS16.0.0 data without binding sheets, direct download to Excel

SpreadJS16.0.0 data without binding sheets, direct download to Excel

Posted by: dingxinyu on 26 February 2023, 9:31 pm EST

• 

  dingxinyu

  • Post Options:
  • Link
    Copy

  Posted 26 February 2023, 9:31 pm EST

  Due to the huge amount of data, more than 2 million rows in Excel, the screen can only display a maximum of 200,000 rows, but the total amount of data exceeds 2 million rows, the paging function has been implemented, but the download requires 2 million rows to be downloaded together into the same Excel file.

  I tried to make a hidden workbook in the page and bind 2 million rows of data to it before downloading, but the browser would crash and get stuck.
  
  So I’m looking for a way to download JavaScript objects (in a format similar to java’s List) directly into Excel without binding data to a table.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 27 February 2023, 11:44 am EST

  Hello,

  Please note there are no limitations on the number of rows or columns in SpreadJS. Since SpreadJS is a client-side base application, the performance of SpreadJS depends upon the specifications of the client’s machine. Though there are no limitations on the number of rows and columns in SpreadJS, having data in more rows and columns may cause performance issues and slow exporting into an excel file. Please describe your use case so that we could help you appropriately.

  Regards,
  
  Avinash