Community Learn Tools Library Leisure
search
English
Home > Web Front-end > JS Tutorial > Method for exporting Excel (CSV) files using JS-compatible browsers_javascript skills

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

WBOY
Release： 2016-05-16 16:50:07
Original
1254 people have browsed it

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.

Related labels：
javascript js
source：php.cn
Previous article：How to call the ajax method remotely through JSONP in jquery_jquery Next article：Solution to the duplicate submission problem in the Enter submission form under IE_javascript skills
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
CSS only method to dynamically modify image src on click without using JavaScript I need to change the src of an image on mouse click using only css like img:active{}
From 2024-04-06 19:25:49
0
1
505
Scatterplot points do not maintain values ​​when zooming in d3.js This is my first time using d3.js, so please bear with me. I implemented it as pure JavaSc...
From 2024-04-06 18:16:26
0
1
403
JavaScript hover events on vendor-specific pseudo-elements I have the following htmlinput tag. $("input[type='range']::-webkit-slider-thumb"...
From 2024-04-06 15:35:24
0
1
274
Submit form without button using Javascript/Jquery I'm trying to submit a form without a button by calling a JavaScript function and executin...
From 2024-04-06 14:54:03
0
2
421
Customize the appearance of Bootstrap accordion headers using the CollapseDisplay class I want to style the card title of a panel with class collapseshow. In this example, it's t...
From 2024-04-06 12:53:11
0
1
376
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template