Export To Excel a div content using JavascriptJquery - Stack Overflow

admin管理员组

文章数量:1391951

I am trying to export div data which using JavaScript. It is exported to Excel but without css. No border is showing in Excel format, even I am not able to give name of Excel file.

Here is my code:

function ExportToExcel() {
    var contents = $(".divclass").html();
    window.open('data:application/vnd.ms-excel,' + encodeURIComponent(contents));
}

I am trying to export div data which using JavaScript. It is exported to Excel but without css. No border is showing in Excel format, even I am not able to give name of Excel file.

Here is my code:

function ExportToExcel() {
    var contents = $(".divclass").html();
    window.open('data:application/vnd.ms-excel,' + encodeURIComponent(contents));
}

• javascript
• jquery

Share Improve this question Follow edited Jul 31, 2017 at 13:47 hbulens 1,96933 gold badges2424 silver badges5151 bronze badges asked Jul 31, 2017 at 13:09 SujeetSujeet 2111 gold badge11 silver badge22 bronze badges 1

• 2 and your div is posed of? – Prabhakaran Commented Jul 31, 2017 at 13:12

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 2

$("#btnExport").click(function(e) {
  let file = new Blob([$('.divclass').html()], {type:"application/vnd.ms-excel"});
let url = URL.createObjectURL(file);
let a = $("<a />", {
  href: url,
  download: "filename.xls"}).appendTo("body").get(0).click();
  e.preventDefault();
});

本文标签： Export To Excel a div content using JavascriptJqueryStack Overflow