//获取输出流
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”;