Examples with FormatTrackingHSSFListener org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener used on opensource projects

Example 1 with FormatTrackingHSSFListener

use of org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener in project poi by apache.

the class EventBasedExcelExtractor method triggerExtraction.

private TextListener triggerExtraction() throws IOException {
    TextListener tl = new TextListener();
    FormatTrackingHSSFListener ft = new FormatTrackingHSSFListener(tl);
    tl._ft = ft;
    // Register and process
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    request.addListenerForAllRecords(ft);
    factory.processWorkbookEvents(request, _dir);
    return tl;
}

Example 2 with FormatTrackingHSSFListener

use of org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener in project hutool by looly.

the class Excel03SaxReader method read.

/**
 * 读取
 *
 * @param fs {@link POIFSFileSystem}
 * @param sheetIndex sheet序号
 * @return this
 * @throws POIException IO异常包装
 */
public Excel03SaxReader read(POIFSFileSystem fs, int sheetIndex) throws POIException {
    this.sheetIndex = sheetIndex;
    formatListener = new FormatTrackingHSSFListener(new MissingRecordAwareHSSFListener(this));
    final HSSFRequest request = new HSSFRequest();
    if (isOutputFormulaValues) {
        request.addListenerForAllRecords(formatListener);
    } else {
        workbookBuildingListener = new SheetRecordCollectingListener(formatListener);
        request.addListenerForAllRecords(workbookBuildingListener);
    }
    final HSSFEventFactory factory = new HSSFEventFactory();
    try {
        factory.processWorkbookEvents(request, fs);
    } catch (IOException e) {
        throw new POIException(e);
    }
    return this;
}

Example 3 with FormatTrackingHSSFListener

use of org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener in project jeesuite-libs by vakinge.

the class XLS2CSV method process.

/**
 * Initiates the processing of the XLS file to CSV
 */
public List<String> process() throws IOException {
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
    formatListener = new FormatTrackingHSSFListener(listener);
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    if (outputFormulaValues) {
        request.addListenerForAllRecords(formatListener);
    } else {
        workbookBuildingListener = new SheetRecordCollectingListener(formatListener);
        request.addListenerForAllRecords(workbookBuildingListener);
    }
    factory.processWorkbookEvents(request, fs);
    return results;
}

Example 4 with FormatTrackingHSSFListener

use of org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener in project poi by apache.

the class XLS2CSVmra method process.

/**
	 * Initiates the processing of the XLS file to CSV
	 */
public void process() throws IOException {
    MissingRecordAwareHSSFListener listener = new MissingRecordAwareHSSFListener(this);
    formatListener = new FormatTrackingHSSFListener(listener);
    HSSFEventFactory factory = new HSSFEventFactory();
    HSSFRequest request = new HSSFRequest();
    if (outputFormulaValues) {
        request.addListenerForAllRecords(formatListener);
    } else {
        workbookBuildingListener = new SheetRecordCollectingListener(formatListener);
        request.addListenerForAllRecords(workbookBuildingListener);
    }
    factory.processWorkbookEvents(request, fs);
}