Java Web的Excel读取

//获取输出流
outputStream = response.getOutputStream();

//定义流读取文件
input = new FileInputStream(contextPath);
XSSFWorkbook workBook = new XSSFWorkbook(input);

//获取第一个SHEET页
XSSFSheet sheet = workBook.getSheetAt(0);

//存储信息
List titleList = new ArrayList();
List paramList = new ArrayList();

if (sheet != null){

//获取模板第一行(当然，此处也可写成循环，但我想处理的Excel只有2行)
XSSFRow rowOne  = sheet.getRow(0);
//遍历第一行每一列
for (int j = 0; j < rowOne.getPhysicalNumberOfCells(); j++){
    XSSFCell cell = rowOne.getCell(j);
    titleList.add(cell.toString());
}

//获取模板第二行
XSSFRow rowTwo = sheet.getRow(1);
//遍历第二行每一列
for (int j = 0; j < rowTwo.getPhysicalNumberOfCells(); j++){
    XSSFCell cell = rowTwo.getCell(j);
    paramList.add(cell.toString());
}

此处结束后，记得关闭流，此处略。
另contextPath为想处理的文件路径，此处为
String contextPath = SessionManager.getSession().getServletContext().getRealPath(Constants.UPLOAD_EXCEL_PATH);
contextPath = contextPath + “/管理.xslx”;