<template>
<div class="">
<input @change="changeFile($event)" type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"/>
<input type="file" id="file" style="display:none;" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"/>
<button @click="selectFile()">批量文本加密模板下载</button>
<h2>{{msg}}</h2>
<div class="mt-sm" style="padding-top:40px;">
<button @click="exportExcel2()">批量文本加密下载</button>
</div>
</div>
</template>
<script>
var testarr = []
var _this
import XLSX from 'xlsx'
import sha256 from 'js-sha256'
export default {
name: "",
components: {
},
props: {},
data () {
return {
msg: '',
sheetToJson: []
}
},
watch: {},
methods: {
selectFile() {
// 放在静态文件目录 public static
window.open("./static/批量文本加密模板.xlsx");
},
changeFile(e){
console.log(e)
var files = e.target.files;
if(files.length == 0) return;
var f = files[0];
if(!/\.xlsx$/g.test(f.name)) {
alert('仅支持读取xlsx格式！');
return;
}
this.readWorkbookFromLocalFile(f, function(workbook) {
// _this.readWorkbook(workbook);
});
},
// 读取本地excel文件
readWorkbookFromLocalFile(file, callback) {
this.msg = '文件读取中...'
var reader = new FileReader();
reader.onload = function(e) {
var data = e.target.result;
var workbook = XLSX.read(data, {type: 'binary'});
// console.log(workbook)
var worksheet = workbook.Sheets[workbook.SheetNames[0]]; // 只能通过工作表名称来获取指定工作表
// this.sheetToJson = []
// this.sheetToJson = XLSX.utils.sheet_to_json(worksheet)
testarr = []
testarr = XLSX.utils.sheet_to_json(worksheet)
console.log('testarr===')
_this.msg = '文件读取完成'
// if(callback) callback(workbook);
};
reader.readAsBinaryString(file);
},
/**
* 通用的打开下载对话框方法，没有测试过具体兼容性
* @param url 下载地址，也可以是一个blob对象，必选
* @param saveName 保存文件名，可选
*/
openDownloadDialog(url, saveName)
{
if(typeof url == 'object' && url instanceof Blob)
{
url = URL.createObjectURL(url); // 创建blob地址
}
var aLink = document.createElement('a');
aLink.href = url;
aLink.download = saveName || ''; // HTML5新增的属性，指定保存文件名，可以不要后缀，注意，file:///模式下不会生效
var event;
if(window.MouseEvent) event = new MouseEvent('click');
else
{
event = document.createEvent('MouseEvents');
event.initMouseEvent('click', true, false, window, 0, 0, 0, 0, 0, false, false, false, false, 0, null);
}
aLink.dispatchEvent(event);
},
// 将一个sheet转成最终的excel文件的blob对象，然后利用URL.createObjectURL下载
sheet2blob(sheet, sheetName) {
sheetName = sheetName || 'sheet1';
var workbook = {
SheetNames: [sheetName],
Sheets: {}
};
workbook.Sheets[sheetName] = sheet;
// 生成excel的配置项
var wopts = {
bookType: 'xlsx', // 要生成的文件类型
bookSST: false, // 是否生成Shared String Table，官方解释是，如果开启生成速度会下降，但在低版本IOS设备上有更好的兼容性
type: 'binary'
};
var wbout = XLSX.write(workbook, wopts);
var blob = new Blob([s2ab(wbout)], {type:"application/octet-stream"});
// 字符串转ArrayBuffer
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;
}
return blob;
},
exportExcel2() {
this.msg = '加密文件生成中...'
for(let i=0;i<testarr.length;i++){
testarr[i]['加密后的文本'] = sha256(testarr[i]['原始文本'].toString())
}
// console.log(testarr)
var sheet = XLSX.utils.json_to_sheet(testarr);
this.openDownloadDialog(this.sheet2blob(sheet), '批量文本加密.xlsx');
this.msg = '加密文件生成完成'
}
},
mounted () {
_this = this
document.getElementById('file').addEventListener('change', function(e) {
console.log(e)
var files = e.target.files;
if(files.length == 0) return;
var f = files[0];
if(!/\.xlsx$/g.test(f.name)) {
alert('仅支持读取xlsx格式！');
return;
}
_this.readWorkbookFromLocalFile(f, function(workbook) {
// _this.readWorkbook(workbook);
});
});
}
}
</script>
<!-- Add "scoped" attribute to limit CSS to this component only -->
<style scoped>
</style>
