js-xlsx 导出详细使用
时间: 2023-06-20 21:04:09 浏览: 79
js-xlsx 是一个用于在浏览器中导入导出 Excel 文件的 JavaScript 库。下面是使用 js-xlsx 导出 Excel 文件的详细步骤:
1. 首先,在 HTML 文件中引入 js-xlsx:
```html
<script src="https://cdn.bootcss.com/xlsx/0.15.1/xlsx.full.min.js"></script>
```
2. 在 JavaScript 中创建要导出的数据。数据可以是数组、JSON 对象等。
```javascript
var data = [
["姓名", "年龄", "性别"],
["张三", 18, "男"],
["李四", 20, "女"],
["王五", 22, "男"]
];
```
3. 创建一个 Workbook 对象,并向其中添加一个 Sheet。
```javascript
var workbook = XLSX.utils.book_new();
var sheet = XLSX.utils.aoa_to_sheet(data);
XLSX.utils.book_append_sheet(workbook, sheet, "Sheet1");
```
4. 将 Workbook 对象转换为二进制数据。
```javascript
var wbout = XLSX.write(workbook, { bookType: "xlsx", type: "binary" });
```
5. 将二进制数据转换为 Blob 对象。
```javascript
function s2ab(s) {
var buf = new ArrayBuffer(s.length);
var view = new Uint8Array(buf);
for (var i = 0; i < s.length; i++) {
view[i] = s.charCodeAt(i) & 0xff;
}
return buf;
}
var blob = new Blob([s2ab(wbout)], { type: "application/octet-stream" });
```
6. 创建一个链接,并将 Blob 对象赋值给链接的 href 属性。
```javascript
var link = document.createElement("a");
link.href = URL.createObjectURL(blob);
link.download = "data.xlsx";
```
7. 点击链接,即可下载 Excel 文件。
```javascript
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
```
完整代码如下:
```javascript
var data = [
["姓名", "年龄", "性别"],
["张三", 18, "男"],
["李四", 20, "女"],
["王五", 22, "男"]
];
var workbook = XLSX.utils.book_new();
var sheet = XLSX.utils.aoa_to_sheet(data);
XLSX.utils.book_append_sheet(workbook, sheet, "Sheet1");
var wbout = XLSX.write(workbook, { bookType: "xlsx", type: "binary" });
function s2ab(s) {
var buf = new ArrayBuffer(s.length);
var view = new Uint8Array(buf);
for (var i = 0; i < s.length; i++) {
view[i] = s.charCodeAt(i) & 0xff;
}
return buf;
}
var blob = new Blob([s2ab(wbout)], { type: "application/octet-stream" });
var link = document.createElement("a");
link.href = URL.createObjectURL(blob);
link.download = "data.xlsx";
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
```