export html to excel,Export html table to excel using javascript

Here is a function I made.

Add "remove" class on elements you do not want to show in the excel.

function exportExcel(id,name){ //

var today = new Date();

var date = ('0'+today.getDate()).slice(-2)+"-"+('0'+(today.getMonth()+1)).slice(-2)+"-"+today.getFullYear();

var file_name = name+"_"+date+".xls"; //filename with current date, change if needed

var meta = '';

var html = $("#"+id).clone();

html.find('.remove').remove(); //add the 'remove' class on elements you do not want to show in the excel

html.find('a').each(function() { //remove links, leave text only

var txt = $(this).text();

$(this).after(txt).remove();

});

html.find('input, textarea').each(function() { //replace inputs for their respectives texts

var txt = $(this).val().replace(/\r\n|\r|\n/g,"
");

$(this).after(txt).remove();

});

html.find('select').each(function() { //replace selects for their selected option text

var txt = $(this).find('option:selected').text();

$(this).after(txt).remove();

});

html.find('br').attr('style', "mso-data-placement:same-cell"); //make line breaks show in single cell

html = "

";

var uri = 'data:application/vnd.ms-excel,'+encodeURIComponent(meta+html);

var a = $("", {href: uri, download: file_name});

$(a)[0].click();

}

Call it on an event, example:

$("#export_button").click(function(e){

exportExcel("table_id", "filename");

});