使用POI读取EXCEL大文件时,在解析数据的过程中对数据完成处理转换

一、基于eventusermodel的excel解析工具类

这一部分和网上大部分的差不多,变化在二和三

import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import org.apache.log4j.LogManager;
import org.apache.log4j.Logger;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.openxml4j.exceptions.OpenXML4JException;
import org.apache.poi.openxml4j.opc.OPCPackage;
import org.apache.poi.xssf.eventusermodel.ReadOnlySharedStringsTable;
import org.apache.poi.xssf.eventusermodel.XSSFReader;
import org.apache.poi.xssf.eventusermodel.XSSFSheetXMLHandler;
import org.apache.poi.xssf.model.StylesTable;
import org.xml.sax.InputSource;
import org.xml.sax.SAXException;
import org.xml.sax.XMLReader;
import org.xml.sax.helpers.XMLReaderFactory;

public class ImportantUtil{
   

	private static final Logger logger = LogManager.getLogger(ImportantUtil.class);
	
	public ImportantUtil(ISheetContentHandler handler) {
   
		contentHandler=handler;
	}

	/**
	 * 表格默认处理器
	 */
	private ISheetContentHandler contentHandler = null;
	/**
	 * 读取数据
	 */
	private List<Object[]> data=new ArrayList<Object[]>();

	/**
	 * 转换表格,默认为转换第一个表格
	 * @param stream
	 * @return
	 * @throws InvalidFormatException
	 * @throws IOException
	 * @throws ParseException
	 */
	public List<Object[]> parse(InputStream stream)throws InvalidFormatException, IOException, ParseException {
   
		return parse(stream, 1);
	}

	/**
	 *
	 * @param stream
	 * @param sheetId:为要遍历的sheet索引，从1开始
	 * @return
	 * @throws InvalidFormatException
	 * @throws IOException
	 * @throws ParseException
	 */
	public synchronized List<Object[]> parse(InputStream stream, int sheetId)throws InvalidFormatException, IOException, ParseException 
	{
   
		// 每次转换前都清空数据
		data.clear();
		
		// 打开表格文件输入流
		OPCPackage pkg = OPCPackage.open(stream);
		try {
   
			// 创建表阅读器
			XSSFReader reader;
			try {
   
				reader = new XSSFReader(pkg);
			} catch (