org.jberet.support.io

Class ExcelStreamingItemReader

java.lang.Object

org.jberet.support.io.ItemReaderWriterBase

org.jberet.support.io.JsonItemReaderWriterBase

org.jberet.support.io.ExcelItemReaderWriterBase

org.jberet.support.io.ExcelUserModelItemReader

org.jberet.support.io.ExcelStreamingItemReader

All Implemented Interfaces:

javax.batch.api.chunk.ItemReader

@Named
 @Dependent
public class ExcelStreamingItemReader
extends ExcelUserModelItemReader
implements javax.batch.api.chunk.ItemReader

An implementation of javax.batch.api.chunk.ItemReader for reading OOXML Excel files, based on Apache POI XSSF streaming reader API, and StAX.

Since:

1.1.0

See Also:

ExcelStreamingItemWriter, ExcelUserModelItemReader, ExcelItemReaderWriterBase

Field Summary

Fields

Modifier and Type	Field and Description
protected Boolean	r1c1 If set to true, the target sheet uses R1C1-style cell coordinates; if set to false, the target sheet uses the more common A1-style cell coordinates; defaults to null (not set).
protected org.apache.poi.xssf.model.SharedStringsTable	sharedStringsTable
protected InputStream	sheetInputStream
protected XMLStreamReader	sheetStreamReader

Fields inherited from class org.jberet.support.io.ExcelUserModelItemReader

end, formulaEvaluator, headerMapping, headerRow, inputStream, minColumnCount, rowIterator, sheetIndex, start

Fields inherited from class org.jberet.support.io.ExcelItemReaderWriterBase

beanType, currentRowNum, header, sheet, sheetName, workbook

Fields inherited from class org.jberet.support.io.JsonItemReaderWriterBase

customDataTypeModules, customDeserializers, customSerializers, deserializationFeatures, jsonFactory, jsonFactoryFeatures, jsonFactoryLookup, mapperFeatures, objectMapper, serializationFeatures

Fields inherited from class org.jberet.support.io.ItemReaderWriterBase

NEW_LINE, resource, skipBeanValidation

Constructor Summary

Constructors

Constructor and Description
ExcelStreamingItemReader()

Method Summary

Modifier and Type	Method and Description
void	close()
protected void	initWorkbookAndSheet(int startRowNumber)
Object	readItem()

Methods inherited from class org.jberet.support.io.ExcelUserModelItemReader

checkpointInfo, getCellValue, open

Methods inherited from class org.jberet.support.io.ExcelItemReaderWriterBase

getCellStringValues

Methods inherited from class org.jberet.support.io.JsonItemReaderWriterBase

initJsonFactory, initJsonFactoryAndObjectMapper, registerModule

Methods inherited from class org.jberet.support.io.ItemReaderWriterBase

getInputStream, getOutputStream, getValidator, validate

Methods inherited from class java.lang.Object

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

Methods inherited from interface javax.batch.api.chunk.ItemReader

checkpointInfo, open

Field Detail

r1c1

protected Boolean r1c1

If set to true, the target sheet uses R1C1-style cell coordinates; if set to false, the target sheet uses the more common A1-style cell coordinates; defaults to null (not set).

sheetInputStream

protected InputStream sheetInputStream

sheetStreamReader

protected XMLStreamReader sheetStreamReader

sharedStringsTable

protected org.apache.poi.xssf.model.SharedStringsTable sharedStringsTable

Constructor Detail

ExcelStreamingItemReader

public ExcelStreamingItemReader()

Method Detail

readItem

public Object readItem()
                throws Exception

Specified by:

readItem in interface javax.batch.api.chunk.ItemReader

Overrides:

readItem in class ExcelUserModelItemReader

Throws:

Exception

close

public void close()
           throws Exception

Specified by:

close in interface javax.batch.api.chunk.ItemReader

Overrides:

close in class ExcelUserModelItemReader

Throws:

Exception

initWorkbookAndSheet

protected void initWorkbookAndSheet(int startRowNumber)
                             throws Exception

Overrides:

initWorkbookAndSheet in class ExcelUserModelItemReader

Throws:

Exception