var xlsx = require("node-xlsx");
module.exports = function(event) {
	const dataBuffer = new Buffer(event.data, 'base64'); //把base64码转成buffer对象
	let sheetList = xlsx.parse(dataBuffer);
	let data = [];
	event.sheetList.forEach(sheetItem => {
		try{
			let keys = [];
			if(sheetItem.keys && sheetItem.keys.length > 0){
				keys = sheetItem.keys
			}else{
				keys = sheetList[sheetItem.index].data.find((item,rowIndex) =>{
					return rowIndex ===sheetItem.keysIndex
				})
			}
			sheetList[sheetItem.index].data.forEach((rowItem, rowIndex) => {
				if (rowIndex < sheetItem.startIndex) return false;
				if (rowIndex > sheetItem.endIndex && sheetItem.endIndex !== -1) throw new Error('end forEach');
				let obj = {};
				rowItem.forEach((colItem, colIndex) => {
					obj[keys[colIndex]] = colItem
				})
				data.push(obj)
			})
		}catch(e){}
	})
	return data
}