excel转为html table,<转>HTML中的table转为excel

Insert title here

vartableToExcel=(function() {varuri= 'data:application/vnd.ms-excel;base64,', template= '

', base64= function(s) {returnwindow.btoa(unescape(encodeURIComponent(s))) }

, format= function(s, c) {returns.replace(/{(w+)}/g,function(m, p) {returnc[p]; }) }return function(table, name) {if(!table.nodeType) table=document.getElementById(table)varctx={worksheet: name|| 'Worksheet', table: table.innerHTML}

window.location.href=uri+base64(format(template, ctx))

}

})()

tableToExcel Demo

Exporting the W3C Example Table

两行三列：

100200300400500600