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

MAVEN配置dependencygroupIdorg.apache.poi/groupIdartifactIdpoi/artifactIdversion3.14/version/dependencydependencygroupIdorg.apache.poi/groupIdartifactIdpoi-ooxml/artifactIdversion3.14/version/dependencyJava代码本段代码主要是读取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 ListListString 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 ListListString 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 getXlsxSheet