用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 " "