关键词:
前端工作量最多的就是需求,需求就是一直在变,比如当前端数据写完之后,需要用Excel把数据下载出来。
第一步安装依赖包,需要把代码下载你的项目当中
cnpm install file-saver
cnpm install xlsx
cnpm install script-loader
第二步在项目中创建一个新的文件夹用于存放Blob和Export2Excel两个js文件
第三步在你那个组件中使用
tHeader:标题
filterVal:字段名
tableData:前端请求的数据
exportToExcel() //excel数据导出 require.ensure([], () => const export_json_to_excel = require(‘../../assets/js/Export2Excel‘); const tHeader = [‘序号‘,‘省份‘, ‘投资总额‘, ‘收益总额‘, ‘主要投资项目‘,‘投资周期‘, ‘投资人数‘, ‘投资年变化率‘,‘备注‘]; const filterVal = [‘index‘,‘provinces‘, ‘orderMoney‘, ‘incomeMoney‘, ‘payType‘,‘orderPeriod‘, ‘orderPersonConunt‘, ‘orderYearRate‘, ‘remarks‘]; const list = this.tableData; const data = this.formatJson(filterVal, list); export_json_to_excel(tHeader, data, ‘列表excel‘); ) , formatJson(filterVal, jsonData) return jsonData.map(v => filterVal.map(j => v[j]))
附录:
需要把这个两个文件复制到自己的目录中
Export2Excel.js文件
/* eslint-disable */ require(‘script-loader!file-saver‘); // require(‘script-loader!src/vendor/Blob‘); require(‘script-loader!../../assets/js/Blob‘); require(‘script-loader!xlsx/dist/xlsx.core.min‘); function generateArray(table) var out = []; var rows = table.querySelectorAll(‘tr‘); var ranges = []; for (var R = 0; R < rows.length; ++R) var outRow = []; var row = rows[R]; var columns = row.querySelectorAll(‘td‘); for (var C = 0; C < columns.length; ++C) var cell = columns[C]; var colspan = cell.getAttribute(‘colspan‘); var rowspan = cell.getAttribute(‘rowspan‘); var cellValue = cell.innerText; if (cellValue !== "" && cellValue == +cellValue) cellValue = +cellValue; //Skip ranges ranges.forEach(function (range) if (R >= range.s.r && R <= range.e.r && outRow.length >= range.s.c && outRow.length <= range.e.c) for (var i = 0; i <= range.e.c - range.s.c; ++i) outRow.push(null); ); //Handle Row Span if (rowspan || colspan) rowspan = rowspan || 1; colspan = colspan || 1; ranges.push(s: r: R, c: outRow.length, e: r: R + rowspan - 1, c: outRow.length + colspan - 1); ; //Handle Value outRow.push(cellValue !== "" ? cellValue : null); //Handle Colspan if (colspan) for (var k = 0; k < colspan - 1; ++k) outRow.push(null); out.push(outRow); return [out, ranges]; ; function datenum(v, date1904) if (date1904) v += 1462; var epoch = Date.parse(v); return (epoch - new Date(Date.UTC(1899, 11, 30))) / (24 * 60 * 60 * 1000); function sheet_from_array_of_arrays(data, opts) var ws = ; var range = s: c: 10000000, r: 10000000, e: c: 0, r: 0; for (var R = 0; R != data.length; ++R) for (var C = 0; C != data[R].length; ++C) if (range.s.r > R) range.s.r = R; if (range.s.c > C) range.s.c = C; if (range.e.r < R) range.e.r = R; if (range.e.c < C) range.e.c = C; var cell = v: data[R][C]; if (cell.v == null) continue; var cell_ref = XLSX.utils.encode_cell(c: C, r: R); if (typeof cell.v === ‘number‘) cell.t = ‘n‘; else if (typeof cell.v === ‘boolean‘) cell.t = ‘b‘; else if (cell.v instanceof Date) cell.t = ‘n‘; cell.z = XLSX.SSF._table[14]; cell.v = datenum(cell.v); else cell.t = ‘s‘; ws[cell_ref] = cell; if (range.s.c < 10000000) ws[‘!ref‘] = XLSX.utils.encode_range(range); return ws; function Workbook() if (!(this instanceof Workbook)) return new Workbook(); this.SheetNames = []; this.Sheets = ; 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; export function export_table_to_excel(id) var theTable = document.getElementById(id); console.log(‘a‘) var oo = generateArray(theTable); var ranges = oo[1]; /* original data */ var data = oo[0]; var ws_name = "SheetJS"; console.log(data); var wb = new Workbook(), ws = sheet_from_array_of_arrays(data); /* add ranges to worksheet */ // ws[‘!cols‘] = [‘apple‘, ‘banan‘]; ws[‘!merges‘] = ranges; /* add worksheet to workbook */ wb.SheetNames.push(ws_name); wb.Sheets[ws_name] = ws; var wbout = XLSX.write(wb, bookType: ‘xlsx‘, bookSST: false, type: ‘binary‘); saveAs(new Blob([s2ab(wbout)], type: "application/octet-stream"), "test.xlsx") function formatJson(jsonData) console.log(jsonData) export function export_json_to_excel(th, jsonData, defaultTitle) /* original data */ var data = jsonData; data.unshift(th); var ws_name = "SheetJS"; var wb = new Workbook(), ws = sheet_from_array_of_arrays(data); /* add worksheet to workbook */ wb.SheetNames.push(ws_name); wb.Sheets[ws_name] = ws; var wbout = XLSX.write(wb, bookType: ‘xlsx‘, bookSST: false, type: ‘binary‘); var title = defaultTitle || ‘列表‘ saveAs(new Blob([s2ab(wbout)], type: "application/octet-stream"), title + ".xlsx")
Blob.js文件
/* eslint-disable */ /* Blob.js*/ /*global self, unescape */ /*jslint bitwise: true, regexp: true, confusion: true, es5: true, vars: true, white: true, plusplus: true */ /*! @source http://purl.eligrey.com/github/Blob.js/blob/master/Blob.js */ (function (view) "use strict"; view.URL = view.URL || view.webkitURL; if (view.Blob && view.URL) try new Blob; return; catch (e) // Internally we use a BlobBuilder implementation to base Blob off of // in order to support older browsers that only have BlobBuilder var BlobBuilder = view.BlobBuilder || view.WebKitBlobBuilder || view.MozBlobBuilder || (function (view) var get_class = function (object) return Object.prototype.toString.call(object).match(/^[objects(.*)]$/)[1]; , FakeBlobBuilder = function BlobBuilder() this.data = []; , FakeBlob = function Blob(data, type, encoding) this.data = data; this.size = data.length; this.type = type; this.encoding = encoding; , FBB_proto = FakeBlobBuilder.prototype , FB_proto = FakeBlob.prototype , FileReaderSync = view.FileReaderSync , FileException = function (type) this.code = this[this.name = type]; , file_ex_codes = ( "NOT_FOUND_ERR SECURITY_ERR ABORT_ERR NOT_READABLE_ERR ENCODING_ERR " + "NO_MODIFICATION_ALLOWED_ERR INVALID_STATE_ERR SYNTAX_ERR" ).split(" ") , file_ex_code = file_ex_codes.length , real_URL = view.URL || view.webkitURL || view , real_create_object_URL = real_URL.createObjectURL , real_revoke_object_URL = real_URL.revokeObjectURL , URL = real_URL , btoa = view.btoa , atob = view.atob , ArrayBuffer = view.ArrayBuffer , Uint8Array = view.Uint8Array , origin = /^[w-]+:/*[?[w.:-]+]?(?::[0-9]+)?/ ; FakeBlob.fake = FB_proto.fake = true; while (file_ex_code--) FileException.prototype[file_ex_codes[file_ex_code]] = file_ex_code + 1; // Polyfill URL if (!real_URL.createObjectURL) URL = view.URL = function (uri) var uri_info = document.createElementNS("http://www.w3.org/1999/xhtml", "a") , uri_origin ; uri_info.href = uri; if (!("origin" in uri_info)) if (uri_info.protocol.toLowerCase() === "data:") uri_info.origin = null; else uri_origin = uri.match(origin); uri_info.origin = uri_origin && uri_origin[1]; return uri_info; ; URL.createObjectURL = function (blob) var type = blob.type , data_URI_header ; if (type === null) type = "application/octet-stream"; if (blob instanceof FakeBlob) data_URI_header = "data:" + type; if (blob.encoding === "base64") return data_URI_header + ";base64," + blob.data; else if (blob.encoding === "URI") return data_URI_header + "," + decodeURIComponent(blob.data); if (btoa) return data_URI_header + ";base64," + btoa(blob.data); else return data_URI_header + "," + encodeURIComponent(blob.data); else if (real_create_object_URL) return real_create_object_URL.call(real_URL, blob); ; URL.revokeObjectURL = function (object_URL) if (object_URL.substring(0, 5) !== "data:" && real_revoke_object_URL) real_revoke_object_URL.call(real_URL, object_URL); ; FBB_proto.append = function (data/*, endings*/) var bb = this.data; // decode data to a binary string if (Uint8Array && (data instanceof ArrayBuffer || data instanceof Uint8Array)) var str = "" , buf = new Uint8Array(data) , i = 0 , buf_len = buf.length ; for (; i < buf_len; i++) str += String.fromCharCode(buf[i]); bb.push(str); else if (get_class(data) === "Blob" || get_class(data) === "File") if (FileReaderSync) var fr = new FileReaderSync; bb.push(fr.readAsBinaryString(data)); else // async FileReader won‘t work as BlobBuilder is sync throw new FileException("NOT_READABLE_ERR"); else if (data instanceof FakeBlob) if (data.encoding === "base64" && atob) bb.push(atob(data.data)); else if (data.encoding === "URI") bb.push(decodeURIComponent(data.data)); else if (data.encoding === "raw") bb.push(data.data); else if (typeof data !== "string") data += ""; // convert unsupported types to strings // decode UTF-16 to binary string bb.push(unescape(encodeURIComponent(data))); ; FBB_proto.getBlob = function (type) if (!arguments.length) type = null; return new FakeBlob(this.data.join(""), type, "raw"); ; FBB_proto.toString = function () return "[object BlobBuilder]"; ; FB_proto.slice = function (start, end, type) var args = arguments.length; if (args < 3) type = null; return new FakeBlob( this.data.slice(start, args > 1 ? end : this.data.length) , type , this.encoding ); ; FB_proto.toString = function () return "[object Blob]"; ; FB_proto.close = function () this.size = 0; delete this.data; ; return FakeBlobBuilder; (view)); view.Blob = function (blobParts, options) var type = options ? (options.type || "") : ""; var builder = new BlobBuilder(); if (blobParts) for (var i = 0, len = blobParts.length; i < len; i++) if (Uint8Array && blobParts[i] instanceof Uint8Array) builder.append(blobParts[i].buffer); else builder.append(blobParts[i]); var blob = builder.getBlob(type); if (!blob.slice && blob.webkitSlice) blob.slice = blob.webkitSlice; return blob; ; var getPrototypeOf = Object.getPrototypeOf || function (object) return object.__proto__; ; view.Blob.prototype = getPrototypeOf(new view.Blob()); ( typeof self !== "undefined" && self || typeof window !== "undefined" && window || this ));
vue前端实现excel的导入导出打印功能(代码片段)
目录一、相关依赖下载二、excel导入功能三、table导出excel表格1.导出行数据2.导出table数据(也会导出合并单元格)3.导出二维数据的table数据4.导出合并单元格table数据四、table导出excel表格(带样式)1.导出带样式的excel2... 查看详情
vue通过blob对象实现导出excel功能(代码片段)
不同的项目有不同的导出需求,有些只导出当前所显示结果页面的表格进入excel,这个时候就有很多插件,比如vue-json-excel或者是Blob.js+Export2Excel.js来实现导出Excel功能。但是有些需求因为数据量太大,成千上万条数据,所以... 查看详情
vue项目实现导入导出excel表格功能(代码片段)
前提:在我的项目中我使用的是ElementUi前端UI框架,用到的是里面的Upload上传组件。第一步:需要安装三个依赖npminstall-Sfile-saverxlsx (这里其实安装了2个依赖)npminstall-Dscript-loader 第二步:在main.js文件中全局导入挂载xlsx插... 查看详情
基于vue实现excel导出导入功能(代码片段)
第一步下包excel导入导出功能需要我们下载哪些包?在vue-element-admin中有着详细的文档查看:Excel导出Excel的导入导出都是依赖于js-xlsx来实现的。在js-xlsx的基础上又封装了Export2Excel.js来方便导出数据。#使用由于Export2Excel不... 查看详情
vue中element的table表格导入与导出为excel表格的实现(代码片段)
Vue中element的table表格导入与导出为excel表格的实现一、导入2.1安装xlsx插件2.2新建导入功能组件2.3注册全局的导入excel组件2.4创建导入路由组件2.5封装导入接口实现excel导入2.6导入时间格式的处理二、导出2.1安装excel所需依赖和按需... 查看详情
vue小模块之功能全面的表格表格数据的excel导入(代码片段)
Vue小模块之功能全面的表格(十)表格数据的Excel导入技术栈Vue全家桶:前端框架Vue.js状态管理Vuex动态路由匹配vue-routerhttp服务axios模块打包webpackUI框架element数据服务器服务器端node.js基于node的web框架express分布式数据... 查看详情
vue导出表格为excel(代码片段)
...ulid文件夹下的webpack.base.config.js中alias的声明为准。 //导出ExcelexportExcel()require.ensure([],()=> constexport_json_to_excel=require(‘@/Excel/Export2Excel.js‘); //引入文件 consttHeader=[‘创建时间‘,‘订单ID‘,.... 查看详情
vue+iview中的table表格导出excel表格(代码片段)
一、iveiw框架中table中有exportCsv()方法可以导出.csv后缀文件,类似于excel文件,但是并不是excel文件。二、实现table表格导出excel文件利用Blob.js和Export2Excel.js两个文件实现 1.Blob.js和Export2Excel.js文件 链接:https://pan.baidu.co... 查看详情
纯前端导出表格(代码片段)
前端excel表格导出我们习惯了后端去处理表格,直接接口返回,那前端如何轻松的导出表格呢?文章目录前端excel表格导出Ⅰ.通过js-xlsx⭐⭐⭐⭐⭐安装①vue2中使用②vue3中使用③react中使用Ⅲ.通过vue-json-excel⭐⭐安装... 查看详情
vue---excel表格导出(代码片段)
一、安装依赖 npminstallfile-saver--save npminstallxlsx--save npminstallscript-loader--save-dev 二、下载插件 到https://pan.baidu.com/s/1DiIGxik9HaanMQwx 查看详情
vue插件之导出excel(代码片段)
本周项目需要实现导出列表数据的功能,在githup上找到了一个比较好用的插件~简单的整理一下,希望对各位有所帮助。githup地址使用方法:1.npm安装依赖npminstallvue-json-excel2.项目主文件入口main.js全局引入importJsonExcelfrom‘vue-json-ex... 查看详情
elementui导出数据为xlsxexcel表格(代码片段)
我这里为了同学们好理解,把所有元素都写到一个页面。1.第一步安装插件npminstallfile-savernpminstallxlsx2.第二步在mian.js中设置全局//vue中导出excel表格模板importFileSaverfrom'file-saver'importXLSXfrom'xlsx'Vue.prototype.$FileSave 查看详情
vue实现导出表格数据(代码片段)
...XLSXfrom"xlsx"importFileSaverfrom'file-saver'3.使用注意导出的表格可以直接复制上面的表格,但是有三个地方需要改动1.要隐藏导出的表格;2.一定要给 查看详情
vue中导出excel表格(代码片段)
项目中我们可能会碰到导出Excel文件的需求,一般后台管理系统中居多,将table中展示的数据导出保存到本地。当然我们也可以通过一些处理来修改要导出的数据格式,具体需求具体对待。1、首先我们需要安装3个依赖,file-saver... 查看详情
poi方式实现excel表格数据导出(代码片段)
Excel表格导出1.添加pom依赖1<!--office操作工具-->2<dependency>3<groupId>org.apache.poi</groupId>4<artifactId>poi</artifactId>5<version>3.17</version>6</dependency 查看详情
sas的导入导出excel表格的实现(代码片段)
首先SAS可以使用手动来导入,导出但是这样对于每次操作都需要来手动操作,所以就使用了SAS中的宏来编写代码需求:1.首先是给定excel的文件路径,来生成一个数据集2.然后是对数据集中进行数据的处理3.最后是对处理好的数据集导出... 查看详情
前端万级数据量表格预览及前端导出excel方案组件封装(基于vxetable虚拟滚动和webworker)(代码片段)
...题,本文主要解决前端展示渲染大数据量table数据及导出Excel的问题,主要是通过使用v3版本的vxetable和webworker来实现的。亲测可以表格可渲染30w条数据,可在10s内导出30w条数据Excel。框架:vue2;一、安装vxetable... 查看详情
[layui]layui表格全部数据!导出(代码片段)
Layui表格全部数据!导出一、前言开发工具:VisualStudio2017前端框架:layui使用了layui自带的导出功能后,真的是超级便捷,但是只能导出当前页的数据,又研究了下文档,发现还有【导出任意数据】的功... 查看详情