java poi读取2003或2007版本excl为list.docx

MAVEN配置org.apache.poipoi3.14org.apache.poipoi-ooxml3.14Java代码本段代码主要是读取2003和2007版本的excl文件，如果要读取所有sheet的文本内容，可以在这基础上循环sheet，做些简单的封装即可。package com.youku.core.utils;import java.io.IOException;import java.io.InputStream;import java.util.ArrayList;import java.util.List;import mons.fileupload.FileItem;import mons.io.FilenameUtils;import mons.lang.StringUtils;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.xssf.usermodel.XSSFCell;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;/* * Excel组件 * * author sunyue * version 2.0 * since 2.0 */public abstract class ExcelHelper /* * Excel 2003 */private final static String XLS = xls;/* * Excel 2007 */private final static String XLSX = xlsx;/* * 由Excel文件的Sheet导出至List * * param file * param sheetNum * return */public static ListList readExcel(FileItem file, int sheetNum) throws IOException String extensionName = FilenameUtils.getExtension(file.getName();InputStream is = file.getInputStream();return readExcel(is, extensionName, sheetNum);/* * 读取excl文件 * * param is * param extensionName * param sheetNum * return * throws IOException */SuppressWarnings(resource)private static ListList readExcel(InputStream is, String extensionName, int sheetNum)throws IOException if (extensionName.toLowerCase().equals(XLS) Workbook workbook = new HSSFWorkbook(is);Sheet sheet = workbook.getSheetAt(sheetNum);return getXlsSheetList(sheet); else if (extensionName.toLowerCase().equals(XLSX) XSSFWorkbook workbook = new XSSFWorkbook(is);XSSFSheet sheet = workbook.getSheetAt(sheetNum);return getXlsxSheetList(sheet);elsereturn null;/* * 读取XLS后缀excl * * param workbook * param sheetNum * return * throws IOException */private static ListList getXlsSheetList(Sheet sheet) ListList result = new ArrayListList();int minRow = sheet.getFirstRowNum();int maxRow = sheet.getLastRowNum();for (int rowIx = minRow; rowIx = maxRow; rowIx+) List list = new ArrayList();Row row = sheet.getRow(rowIx);int minCell = row.getFirstCellNum();int maxCell = row.getLastCellNum();for (int ci = minCell; ci maxCell; ci+) Cell cell = row.getCell(ci);if (cell != null) cell.setCellType(XSSFCell.CELL_TYPE_STRING);String cellVal = cell.getStringCellValue();if(StringUtils.isNotBlank(cellVal)list.add(cellVal);elselist.add();elselist.add();result.add(list);return result;/* * 读取XLSX后缀excl * * param workbook * param sheetNum * return * throws IOException */private static ListList getXlsxSheetList(XSSFSheet sheet) ListList result = new ArrayListList();try int minRow = sheet.getFirstRowNum();int maxRow = sheet.getLastRowNum();for (int rowIx = minRow; rowIx = maxRow; rowIx+) List list = new ArrayList();XSSFRow row = sheet.getRow(rowIx);int minCell = row.getFirstCellNum();int maxCell = row.getLastCellNum();for (int ci = minCell; ci maxCell; ci+) XSSFCell cell = row.getCell(ci);if (cell != null) cell.setCellType(XSSFCell.CELL_TYPE_STRING);String cellVal = cell.getStringCellValue();