//service层的方法
public String importXls(File file, String fileName, String contentType, String enterId) throws Exception{
Enter enter = enterDao.get(enterId);
//输入流
InputStream inputStream = null;
//获得excel格式的输入流,并进行解析
POIFSFileSystem fileSystem = null;
//读取excel格式的输入流
HSSFWorkbook workbook = null;
//读1个工作表
HSSFSheet sheet = null;
//读一行记录
try{
inputStream = new FileInputStream(file);
fileSystem = new POIFSFileSystem(inputStream);
workbook = new HSSFWorkbook(fileSystem);
int sheetNum = workbook.getNumberOfSheets();
for(int sheetIdx = 0; sheetIdx<sheetNum; sheetIdx++){
sheet = workbook.getSheetAt(sheetIdx);
int rowNum = sheet.getLastRowNum();
for(int rowIdx=0; rowIdx<=rowNum; rowIdx++){
if(rowIdx==0){
continue;
}
row = sheet.getRow(rowIdx);
String barcode = Project.formatCellString(row.getCell(0));
int number = Project.formatCellInt(row.getCell(1));
Enlist enlist = new Enlist();
enlist.setEnterId(enter.getId());
enlist.setProductId(product.getId());
enlist.setInitial(number);
enlist.setRemain(number);
enterDao.save(enlist);
}
}
return new Message("导入成功!").toString();
}catch(Exception e){
throw e;
}finally{
if(inputStream!=null){
try{
inputStream.close();
}catch(Exception ex){
}
}
Project.delFile(file.getAbsolutePath());
}
}