file为上传文件 fileName为文件名 (默认poi相关jar包完备)
InputStream inp = new FileInputStream(file);
方式一:
if(fileName.endsWith("xls")){
//2003
Workbook wb= new HSSFWorkbook(inp);
}else if(fileName.endsWith("xlsx")){
//2007
Workbook wb = new XSSFWorkbook(inp);
}
方式二:
Workbook wb =WorkbookFactory.create(inp);