cn.idev.excel.analysis.v03

Class XlsSaxAnalyser

java.lang.Object

cn.idev.excel.analysis.v03.XlsSaxAnalyser

All Implemented Interfaces:

ExcelReadExecutor, org.apache.poi.hssf.eventusermodel.HSSFListener

public class XlsSaxAnalyser
extends Object
implements org.apache.poi.hssf.eventusermodel.HSSFListener, ExcelReadExecutor

A text extractor for Excel files.

Returns the textual content of the file, suitable for indexing by something like Lucene, but not really intended for display to the user.

To turn an excel file into a CSV or similar, then see the XLS2CSVmra example

See Also:

XLS2CSVmra

Constructor Summary

Constructors

Constructor and Description
XlsSaxAnalyser(XlsReadContext xlsReadContext) Constructor to initialize the XlsSaxAnalyser with the given context.

Method Summary

Modifier and Type	Method and Description
void	execute() Executes the parsing process for the Excel file.
void	processRecord(org.apache.poi.hssf.record.Record record) Processes a single Excel record.
List<ReadSheet>	sheetList() Retrieves the list of sheets in the workbook.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

XlsSaxAnalyser

public XlsSaxAnalyser(XlsReadContext xlsReadContext)

Constructor to initialize the XlsSaxAnalyser with the given context.

Parameters:

xlsReadContext - The context containing necessary information for reading the Excel file.

Method Detail

sheetList

public List<ReadSheet> sheetList()

Retrieves the list of sheets in the workbook.

If the sheet data list is not already loaded, it triggers the execution of a listener to load the data.

Specified by:

sheetList in interface ExcelReadExecutor

Returns:

A list of ReadSheet objects representing the sheets in the workbook.

execute

public void execute()

Executes the parsing process for the Excel file.

This method sets up the necessary listeners and processes the workbook events using HSSFEventFactory.

Specified by:

execute in interface ExcelReadExecutor

processRecord

public void processRecord(org.apache.poi.hssf.record.Record record)

Processes a single Excel record.

This method retrieves the appropriate handler for the given record and processes it. If the record is ignorable or unsupported, it skips processing.

Specified by:

processRecord in interface org.apache.poi.hssf.eventusermodel.HSSFListener

Parameters:

record - The Excel record to be processed.