java poi事件模型_POI事件模型处理execl导入功能(只支持07版本的execl)

package com.yygx.impexptemplate.utils;

import java.io.IOException;

import java.io.InputStream;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

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.XSSFReader;

import org.apache.poi.xssf.eventusermodel.XSSFReader.SheetIterator;

import org.apache.poi.xssf.model.SharedStringsTable;

import org.apache.poi.xssf.usermodel.XSSFRichTextString;

import org.springframework.beans.factory.annotation.Autowired;

import org.xml.sax.Attributes;

import org.xml.sax.InputSource;

import org.xml.sax.SAXException;

import org.xml.sax.XMLReader;

import org.xml.sax.helpers.DefaultHandler;

import org.xml.sax.helpers.XMLReaderFactory;

public class ExcelReaderParse extends DefaultHandler {

private List rowData = new ArrayList();

private List sheetData = new ArrayList();

private Map map = new HashMap();

private String lastContents;

private SharedStringsTable sst;

private boolean nextIsString;

private Integer limit = 0;

// 定义前一个元素和当前元素的位置，用来计算其中空的单元格数量，如A6和A8等

private String preRef = null, ref = null;

// 定义该文档一行最大的单元格数，用来补全一行最后可能缺失的单元格

private String maxRef = null;

private int curRow = 0;

private int maxlimit = 0;

private List sheetNames ;

private int titleRow = 2;

public int getSheetRow() {

return titleRow;

}

public void setSheetRow(int sheetRow) {

this.titleRow = sheetRow;

}

public List getSheetNames() {

return sheetNames;

}

public void setSheetNames(List sheetNames) {

this.sheetNames = sheetNames;

}

public Map getMap() {

return map;

}

public void setMap(Map map) {

this.map = map;</