aardio的npoi库合并excel实例

import console; 
import fsys;
import npoi;

//aardio的npoi库合并excel实例
var tabData = {}

var i=0
fsys.enum(  "/data","*.xlsx",
	function(dir,filename,fullpath,findData){ //指定触发器
		if(filename){ 
			i++
			console.log(i,filename)
			var excel = npoi("\data\"+filename);
			var sheet = excel.sheet(1);
			var tab = sheet.getTable("A"++(i=1?1:2),"F"++sheet.lastRowNum); //修改最后列F
			tabData = table.concat(tabData,tab)
		}
	} 
);

console.log("合并 ... ")
var saveFile = "/合并.xlsx"
if io.exist(saveFile) io.remove(saveFile)
var excel = npoi(saveFile);
var sheet = excel.sheet("sheet1");
sheet.setTable("A1",tabData);
excel.save() 

console.getText("按任意键继续 ... ");