从javascript或Jquery创建简单的xlsx(excel文件)

看看这个小提琴来解决你的问题.它将为Google Chrome和IE创建文件

https://jsfiddle.net/shaswatatripathy/fo4ugmLp/1/

HTML

JS

var tab_text;
var data_type = 'data:application/vnd.ms-excel';


function CreateHiddenTable(ListOfMessages)
{
var ColumnHead = "Column Header Text";
var TableMarkUp='';

for(i=0; i';
}
TableMarkUp += "
'+ColumnHead+'
  
";
$('#MessageHolder').append(TableMarkUp);
}

function fnExcelReport() {
var Messages = "\n message1.\n message2.";
var ListOfMessages = Messages.split(".");

CreateHiddenTable(ListOfMessages);

    tab_text = '';
    tab_text = tab_text + '';

    tab_text = tab_text + 'Error Messages';

    tab_text = tab_text + '';
    tab_text = tab_text + '';

    tab_text = tab_text + "";
    tab_text = tab_text + $('#myModifiedTable').html();;
    tab_text = tab_text + '';

    data_type = 'data:application/vnd.ms-excel';

    var ua = window.navigator.userAgent;
    var msie = ua.indexOf("MSIE ");

    if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) {
        if (window.navigator.msSaveBlob) {
            var blob = new Blob([tab_text], {
                type: "application/csv;charset=utf-8;"
            });
            navigator.msSaveBlob(blob, 'Test file.xls');
        }
    } else {
    console.log(data_type);
console.log(tab_text);
      $('#testAnchor')[0].click()
    }
$('#MessageHolder').html("");
}
$($("#testAnchor")[0]).click(function(){
console.log(data_type);
console.log(tab_text);
  $('#testAnchor').attr('href', data_type + ', ' + encodeURIComponent(tab_text));
        $('#testAnchor').attr('download', 'Test file.xls');
});

CSS

.visibilityHide
{
  visibility:hidden;
}