解析EXCEL工具类

var ZkExcel = function(param) {
	this.file = param.file;
	var that = this;
	//开始执行Excel解析
	this.run = function() {
		var reader = new FileReader();
		reader.onload = function(e) {
			var data = e.target.result;
			var workbook = XLSX.read(data, {
				type: 'binary'
			});
			that.readedExcel(workbook);
		};
		reader.readAsBinaryString(this.file);
	};
	//读取到Excel时回调
	this.readedExcel = function(workbook) {
		var sheet = workbook.Sheets[workbook.SheetNames[0]];
		var jsonArray = XLSX.utils.sheet_to_json(sheet);
		//这里获得了excel的json格式数组，进行自定义转换
		var newJson = [];
		for (index in jsonArray) {
			var tempJson = {};
			for (key in jsonArray[index]) {
				var newKey = this.jsonKeyConvert(key);
				var newValue = this.jsonValueConvert(key, jsonArray[index][key]);
				tempJson[newKey] = newValue;
			}
			newJson.push(tempJson);
		}
		this.onLoad(newJson);
	};
	//JSON格式数据key和value的自定义转换
	this.jsonKeyConvert = function(key) {
		return key;
	}
	this.jsonValueConvert = function(key, value) {
		return value;
	}
	//数据加载完毕的回调事件
	this.onLoad = function(jsonData) {
		console.log("最终JSON：", jsonData);
	}
	//如果参数中有传入转换器就覆盖默认转换器
	if (param.callback) {
		this.onLoad = param.callback;
	}
	if (param.keyConvertor) {
		this.jsonKeyConvert = param.keyConvertor;
	}
	if (param.valueConvertor) {
		this.jsonValueConvert = param.valueConvertor;
	}
	return this;
}
//下载excel
function downExcel(sheet, saveName) {
	// 将一个sheet转成最终的excel文件的blob对象，然后利用URL.createObjectURL下载function sheet2blob(sheet, sheetName) {
	var 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);
	// 字符串转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;
	}
	var blob = new Blob([s2ab(wbout)], {
		type: "application/octet-stream"
	});
	var url = blob;
	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);
}