Export large html table to excel using javascript - Stack Overflow

admin管理员组

文章数量:1417045

I am using following code to generate excel file from html table, It is working fine for small scale data set, When it es to large html table data set it is showing download error.

   //creating a temporary HTML link element (they support setting file names)
    var a = document.createElement('a');
    //getting data from our div that contains the HTML table
    var data_type = 'data:application/vnd.ms-excel';
    var table_div = document.getElementById('dataTable');
    var table_html = table_div.outerHTML.replace(/ /g, '%20');
    a.href = data_type + ', ' + table_html;
    //setting the file name
    a.download = 'Sample.xls';
    //triggering the function
    a.click();
    //just in case, prevent default behaviour
    e.preventDefault();  

I am using following code to generate excel file from html table, It is working fine for small scale data set, When it es to large html table data set it is showing download error.

   //creating a temporary HTML link element (they support setting file names)
    var a = document.createElement('a');
    //getting data from our div that contains the HTML table
    var data_type = 'data:application/vnd.ms-excel';
    var table_div = document.getElementById('dataTable');
    var table_html = table_div.outerHTML.replace(/ /g, '%20');
    a.href = data_type + ', ' + table_html;
    //setting the file name
    a.download = 'Sample.xls';
    //triggering the function
    a.click();
    //just in case, prevent default behaviour
    e.preventDefault();  

• javascript
• html
• excel
• file-conversion

Share Improve this question Follow edited Oct 14, 2017 at 19:49 glennsl 29.2k1212 gold badges5959 silver badges7979 bronze badges asked Dec 26, 2016 at 4:30 DimuthuDimuthu 1,68111 gold badge1414 silver badges1616 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 2

I found one way to solve this issue using FileSaver.js 1: https://github./eligrey/FileSaver.js/ Please check followings

HTML

Javascript

this is working fine for me with large data set of HTML table.

Parsing large HTML tables can be extremely slow because of a lot of DOM elements. Please consider using a pure HTML5 canvas based data grid like this one (https://github./openfin/fin-hypergrid) or something along the line.

Also consider if saving as CSV is going to be quicker than saving as xls.

本文标签： Export large html table to excel using javascriptStack Overflow