\u9700\u8981\u7684\u5f15\u5165\u7684 SDN \u8d44\u6e90<\/p>\n\n\n\n
<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/xlsx-style@0.8.13\/dist\/jszip.js\"><\/script>
<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/xlsx-style@0.8.13\/dist\/cpexcel.js\"><\/script>
<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/xlsx-style@0.8.13\/dist\/ods.js\"><\/script>
<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/file-saver@2.0.2\/dist\/FileSaver.js\"><\/script>
<script src=\"https:\/\/cdn.jsdelivr.net\/npm\/xlsx@0.16.6\/dist\/xlsx.js\"><\/script>
<!--\u5f15\u5165\u7684\u672c\u5730\u8d44\u6e90-->
<script src=\".\/xlsx.js\"><\/script><\/code><\/pre>\n\n\n\nxlsx.js \u4ee3\u7801 [ \u5c06\u4e0b\u8f7d\u7684 txt \u6539\u6210 js \u6269\u5c55\u540d ]<\/strong><\/p>\n\n\n\nxlsx<\/a>\u4e0b\u8f7d<\/a><\/div>\n\n\n\nvue\u4e2d\u4f7f\u7528<\/p>\n\n\n\n
<template>
<div class=\"home\">
<button @click=\"exportExcel\">\u5bfc\u51faexecl<\/button>
<div class=\"tableContainer\">
<table id=\"tableContainer\">
... \u8868\u683c\u7684\u5185\u5bb9
<\/table>
<\/div>
<\/div>
<\/template>
<script>
const XLSX = window.XLSX;
const XLSXX = window.XLSXX;
export default {
name: \"HomeView\",
data() {
return {};
},
components: {},
methods: {
exportExcel() {
this.sheetJSExportTable(document.getElementById(\"tableContainer\"));
},
\u200b
sheetJSExportTable(table) {
var elt = table;
var wb = XLSX.utils.table_to_book(elt, { sheet: \"Sheet JS\", raw: true });
let range = XLSX.utils.decode_range(wb.Sheets[\"Sheet JS\"][\"!ref\"]);
console.log(wb);
console.log(range);
let borderStyle = {
top: {
style: \"thin\",
color: { rgb: \"000000\" },
},
bottom: {
style: \"thin\",
color: { rgb: \"000000\" },
},
left: {
style: \"thin\",
color: { rgb: \"000000\" },
},
right: {
style: \"thin\",
color: { rgb: \"000000\" },
},
};
wb.Sheets[\"Sheet JS\"][\"!merges\"].forEach((item) => {
if (item.e.r == item.s.r && item.e.c != item.s.c) {
\/\/ \u5217\u5408\u5e76
let R = item.s.r;
\/\/ let countLength = item.e.c - item.s.c;
for (let i = item.s.c; i <= item.e.c; i++) {
let cell = { c: i, r: R };
let cell_ref = XLSX.utils.encode_cell(cell);
if (!wb.Sheets[\"Sheet JS\"][cell_ref]) {
wb.Sheets[\"Sheet JS\"][cell_ref] = { t: \"s\", v: \"\" };
}
}
} else if (item.e.c == item.s.c && item.e.r != item.s.r) {
\/\/ \u884c\u5408\u5e76
let C = item.s.c;
\/\/ let countLength = item.e.r - item.s.r;
for (let i = item.s.r; i <= item.e.r; i++) {
let cell = { c: C, r: i };
let cell_ref = XLSX.utils.encode_cell(cell);
if (!wb.Sheets[\"Sheet JS\"][cell_ref]) {
wb.Sheets[\"Sheet JS\"][cell_ref] = { t: \"s\", v: \"\" };
}
}
}
});
console.log(wb);
console.log(range);
for (let C = range.s.c; C <= range.e.c; ++C) {
for (let R = range.s.r; R <= range.e.r; ++R) {
let cell = { c: C, r: R };
let cell_ref = XLSX.utils.encode_cell(cell);
if (R == 1) {
wb.Sheets[\"Sheet JS\"][cell_ref].s = {
alignment: {
horizontal: \"center\",
vertical: \"center\",
},
font: {
name: \"\u9ed1\u4f53\",
\/\/ sz: \"15\",
bold: true,
},
border: borderStyle,
};
} else {
if (wb.Sheets[\"Sheet JS\"][cell_ref]) {
wb.Sheets[\"Sheet JS\"][cell_ref].s = {
font: {
name: \"\u9ed1\u4f53\",
\/\/ sz: \"12\",
},
border: borderStyle,
};
}
}
}
}
var wopts = { bookType: \"xlsx\", bookSST: false, type: \"binary\" };
var wbout = XLSXX.write(wb, wopts); \/\/ \u4f7f\u7528xlsx-style \u5199\u5165
\/\/ eslint-disable-next-line
saveAs(new Blob([this.s2ab(wbout)], { type: \"\" }), \"aa.xlsx\");
},
\u200b
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;
},
},
};
<\/script><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u9700\u8981\u7684\u5f15\u5165\u7684 SDN \u8d44\u6e90 xlsx.js \u4ee3\u7801 [ \u5c06\u4e0b\u8f7d\u7684 txt \u6539\u6210 js \u6269\u5c55\u540d ] vue\u4e2d\u4f7f\u7528<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-726","post","type-post","status-publish","format-standard","hentry","category-vue"],"_links":{"self":[{"href":"https:\/\/gjweb.top\/index.php?rest_route=\/wp\/v2\/posts\/726","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gjweb.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gjweb.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gjweb.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gjweb.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=726"}],"version-history":[{"count":2,"href":"https:\/\/gjweb.top\/index.php?rest_route=\/wp\/v2\/posts\/726\/revisions"}],"predecessor-version":[{"id":729,"href":"https:\/\/gjweb.top\/index.php?rest_route=\/wp\/v2\/posts\/726\/revisions\/729"}],"wp:attachment":[{"href":"https:\/\/gjweb.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gjweb.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gjweb.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}