javascript export to excel Example

javascript export to excel: Learn how to import and export Excel files, and provide users with an interface to interact with those files, all in pure JavaScript Source code.

A quick JavaScript library to create export to Excel/CSV from HTML tables in the browser.

javascript export to excel

Export HTML Table Data to Excel using JavaScript : How in javascript export html table data into excel (.xslx). Easily convert HTML table data, into an excel file.

Steps to export HTML table to excel using JavaScript

HTML Markup: index.html
Add table with data and button tag.

Sr Name Address Job Profile
1

Kishan Tala

Ganesh Laravel Devloper
2

Mayur Dhameliya

Swati AngularJS Devloper
3

Rekha Talpada

Ranjua PHP Devloper

Download and Import SheetJS Library on our webpage


JavaScript code

Using Sheetjs library export table data into an excel file.

function ExportToExcel(type, fn, dl) {
       var elt = document.getElementById('tbl_exporttable_to_xls');
       var wb = XLSX.utils.table_to_member(elt, { sheet: "sheet1" });
       return dl ?
         XLSX.write(wb, { memberType: type, memberSST: true, type: 'base64' }):
         XLSX.writeFile(wb, fn || ('MySheetName.' + (type || 'xlsx')));
    }

Example 2: Export HTML Table Data to Excel using JavaScript

Export HTML Table Data to Excel

function exportTableToExcel(tableID, docname = ''){
    var fourceDLink;
    var dataType = 'application/vnd.ms-excel';
    var tableSelect = document.getElementById(tableID);
    var tableHTML = tableSelect.outerHTML.replace(/ /g, '%20');
    
    docname = docname?docname+'.xls':'excel_data.xls';
    
    fourceDLink = document.createElement("a");
    
    document.body.appendChild(fourceDLink);
    
    if(navigator.msSaveOrOpenBlob){
        var blob = new Blob(['\ufeff', tableHTML], {
            type: dataType
        });
        navigator.msSaveOrOpenBlob( blob, docname);
    }else{
        fourceDLink.href = 'data:' + dataType + ', ' + tableHTML;
    
        fourceDLink.download = docname;
        
        fourceDLink.click();
    }
}

HTML Code

Name Email City
Krishna Dave [email protected] Rajkot
Jagruti Bhavshdiya [email protected] Surat
Hitesh Ajera [email protected] Kalavad

Don’t Miss : JavaScript export to Excel with formatting

I hope you get an idea about javascript export to excel.
I would like to have feedback on my infinityknow.com.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

Leave a Comment