Groovy 读取excel文件

用Apache的POI组建读取Excel文件

相关jar包：http://poi.apache.org/download.html#POI-3.8

class UpdateResourceDate {

	def fileUrl = "E:\\www\\updateRes\\过期时间批量更新.xls";
	
	void updateResourceDate(){
		FileInputStream is = new FileInputStream(fileUrl);
		HSSFWorkbook workbook = new HSSFWorkbook(is);
		workbook.setMissingCellPolicy(Row.CREATE_NULL_AS_BLANK);
		
		//循环sheet
		(0..<workbook.getSheets().iterator().collect {return it}.@size).each {s->
			HSSFSheet sheet = workbook.getSheetAt(s);
			int rows = sheet.physicalNumberOfRows;
			
			//忽略第一行,标题行
			(1..<rows).each{r->
				HSSFRow row = sheet.getRow(r); 	
				def cells = row.physicalNumberOfCells;
				
				(0..<cells).each{c->
					HSSFCell cell = row.getCell(c);
					if (c==4 || c==5) {
						print "  "+getDataCellVal(cell);
					}else{
						print "  "