Method for exporting Excel (CSV) files using JS-compatible browsers_javascript skills

A common way to export a table from JS to an Excel file is to call: ActiveXObject("Excel.Application"), but this method has limitations and can only be implemented in browsers under the IE series, and the compatibility is not ideal.

After testing, the method recommended in this article can export table contents to Excel files with good compatibility.

Copy code The code is as follows:

var str = "Blog, domain name nBlog, 2njb51.net , 3";
var uri = 'data:text/csv;charset=utf-8,' str;

var downloadLink = document.createElement("a");
downloadLink.href = uri;
downloadLink.download = "export.csv";

document.body.appendChild(downloadLink);
downloadLink.click();
document.body.removeChild(downloadLink);

This method is used in Google/Firefox series browsers It's OK, but in IE there will be an error message "The data area passed to the system call is too small" because the value specified by href has too many bytes.

So, for IE browser, I have to make a judgment and use ActiveXObject.

In this way, you can better use Javascript to export HTML content to Excel files.