读取excel的2003版和2007版
public String readFileInfoUpload(InputStream ins) throws Exception {
Workbook wb = null;
String message = "";
if(!ins.markSupported()){
ins = new PushbackInputStream(ins,8);
}
if(POIFSFileSystem.hasPOIFSHeader(ins)){
wb = new HSSFWorkbook(ins);//2003以及以下低版本
}else if(POIXMLDocument.hasOOXMLHeader(ins)){
wb = new XSSFWorkbook(ins);//2007以及以上低版本
}else{
message = "你的excel版本目前poi解析不了";
}
if(wb == null){
message = "你的excel版本目前poi解析不了";
}else{
int totalSheet = wb.getNumberOfSheets();
for (int i = 0; i < totalSheet; i++) {
Sheet sheet = wb.getSheetAt(i);
int totalRow = sheet.getLastRowNum();
if (totalRow > 0 && !sheet.getSheetName().equals("hideSheet")) {//判断sheet是否有数据,并且不是隐藏sheet
message = analyseSheet(sheet);
}
}
}
return message;
}
public String readFileInfoUpload(InputStream ins) throws Exception {
Workbook wb = null;
String message = "";
if(!ins.markSupported()){
ins = new PushbackInputStream(ins,8);
}
if(POIFSFileSystem.hasPOIFSHeader(ins)){
wb = new HSSFWorkbook(ins);//2003以及以下低版本
}else if(POIXMLDocument.hasOOXMLHeader(ins)){
wb = new XSSFWorkbook(ins);//2007以及以上低版本
}else{
message = "你的excel版本目前poi解析不了";
}
if(wb == null){
message = "你的excel版本目前poi解析不了";
}else{
int totalSheet = wb.getNumberOfSheets();
for (int i = 0; i < totalSheet; i++) {
Sheet sheet = wb.getSheetAt(i);
int totalRow = sheet.getLastRowNum();
if (totalRow > 0 && !sheet.getSheetName().equals("hideSheet")) {//判断sheet是否有数据,并且不是隐藏sheet
message = analyseSheet(sheet);
}
}
}
return message;
}