揭秘Java SAX轻松解析Excel，告别繁琐数据处理！

在Java编程中，处理Excel文件是一项常见任务，尤其是在需要读取大量数据时。Apache POI库虽然功能强大，但在处理大数据量文件时，可能会遇到内存溢出的问题。这时，使用SAX（Simple API for XML）解析Excel文件成为一种高效的选择。本文将详细介绍如何在Java中使用SAX解析Excel文件，并提供详细的代码示例。
SAX简介
SAX是一种基于事件的解析方法，它允许程序员在解析XML文件时，只处理感兴趣的元素。与DOM（Document Object Model）解析不同，SAX解析不需要将整个文档加载到内存中，因此更适合处理大型文件。
使用SAX解析Excel文件
SAX解析Excel文件需要借助Apache POI库中的
XMLReader
和
SAXParser
。以下是一个使用SAX解析Excel文件的示例：
”`java
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.openxml4j.opc.OPCPackage;
import org.apache.poi.xssf.eventusermodel.XSSFReader;
import org.apache.poi.xssf.model.SharedStringsTable;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.xml.sax.InputSource;
import org.xml.sax.SAXException;
import org.xml.sax.XMLReader;
import org.xml.sax.helpers.DefaultHandler;
import javax.xml.parsers.SAXParser;
import javax.xml.parsers.SAXParserFactory;
import java.io.FileInputStream;
import java.io.IOException;
public class ExcelSAXParser extends DefaultHandler {
private SharedStringsTable sst;
private DataFormatter formatter = new DataFormatter();
private String[] values;
private int cellNum;

public void parseExcel(String filePath) throws IOException, SAXException, InvalidFormatException {
OPCPackage pkg = OPCPackage.open(filePath);
XSSFReader r = new XSSFReader(pkg);
SharedStringsTable sst = r.getSharedStringsTable();
XMLReader xmlReader = getXMLReader(sst);

// 获取第一个sheet
String relationId = r.get关系表().get关系().get(0).getId();
InputSource sheetSource = r.get关系().get(relationId).get关系().get(0).getRelationship().getTarget();
xmlReader.parse(sheetSource);
}

private XMLReader getXMLReader(SharedStringsTable sst) throws SAXException {
XMLReader xmlReader = XMLReaderFactory.createXMLReader();
xmlReader.setContentHandler(this);
xmlReader.setFeature(“http://xml.org/sax/features/namespaces”, true);
xmlReader.setFeature(“http://xml.org/sax/features/namespace-prefixes”, true);
xmlReader.setFeature(“http://apache.org/xml/features/nonvalidating/load-external-dtd”, false);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-duplicate-attribute”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-namespace-prefix”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-duplicate-namespace”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-namespace-uri”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-duplicate-attribute”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml/features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http://apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);
xmlReader.setFeature(“http//apache.org/xml(features/validation/warn-on-xml-version”, true);