com.northconcepts.datapipeline.excel

Class PoiXssfbProvider

java.lang.Object

com.northconcepts.datapipeline.excel.PoiXssfbProvider

All Implemented Interfaces:

DataExceptionContributor

public class PoiXssfbProvider
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
protected ExcelFieldMetadata	fieldMetadata

Constructor Summary

Constructors

Constructor and Description
PoiXssfbProvider()

Method Summary

Modifier and Type	Method and Description
DataException	addExceptionProperties(DataException exception) Adds this object's current state to a DataException.
void	close()
void	endReading()
protected void	endReadingImpl()
void	endRecord(Record record, int currentRowIndex)
void	endWriting()
protected void	endWritingImpl()
int	getCellCount(int rowIndex)
protected ExcelReader	getExcelReader()
protected ExcelWriter	getExcelWriter()
int	getLastColumnIndex()
int	getLastRowIndex()
String[]	getSheetNames()
void	initStyles()
boolean	isCellStyleSupported()
boolean	isDataFormatSupported()
boolean	isEvaluateExpressions()
boolean	isFreezePaneSupported()
boolean	isHyperlinkSupported()
void	newWorkbook()
void	openWorkbook(File file)
void	openWorkbook(InputStream inputStream)
void	readField(int rowIndex, int fieldIndex, Field field)
void	saveWorkbook(File file)
void	saveWorkbook(OutputStream outputStream)
void	setAutoFilter(int firstRow, int firstColumn)
void	setAutofitColumns(int firstColumnIndex, int[] columnCharacterCount)
com.northconcepts.datapipeline.excel.Provider	setEvaluateExpressions(boolean evaluateExpressions)
protected void	setExcelReader(ExcelReader excelReader)
protected void	setExcelWriter(ExcelWriter excelWriter)
protected void	setFreezePane()
protected void	setFreezePaneImpl(int columns, int rows)
void	startReading(int sheetIndex)
void	startReading(String sheetName)
protected void	startReadingImpl(int sheetIndex)
protected void	startReadingImpl(String sheetName)
void	startRecord(Record record, int currentRowIndex)
void	startWriting(String sheetName, int sheetIndex)
protected void	startWritingImpl(String sheetName, int sheetIndex)
void	writeField(int rowIndex, int columnIndex, int recordIndex, int fieldIndex, Field field)

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.northconcepts.datapipeline.core.DataExceptionContributor

addExceptionProperties, contributeExceptionProperties, contributeExceptionProperties, exception, exception, exception

Field Detail

fieldMetadata

protected ExcelFieldMetadata fieldMetadata

Constructor Detail

PoiXssfbProvider

public PoiXssfbProvider()

Method Detail

openWorkbook

public void openWorkbook(File file)
                  throws Throwable

Throws:

Throwable

openWorkbook

public void openWorkbook(InputStream inputStream)

newWorkbook

public void newWorkbook()

close

public void close()

saveWorkbook

public void saveWorkbook(OutputStream outputStream)
                  throws Throwable

Throws:

Throwable

startReadingImpl

protected void startReadingImpl(String sheetName)

startReadingImpl

protected void startReadingImpl(int sheetIndex)

readField

public void readField(int rowIndex,
                      int fieldIndex,
                      Field field)

endReadingImpl

protected void endReadingImpl()

startWritingImpl

protected void startWritingImpl(String sheetName,
                                int sheetIndex)

writeField

public void writeField(int rowIndex,
                       int columnIndex,
                       int recordIndex,
                       int fieldIndex,
                       Field field)

setAutofitColumns

public void setAutofitColumns(int firstColumnIndex,
                              int[] columnCharacterCount)

endWritingImpl

protected void endWritingImpl()

getLastRowIndex

public int getLastRowIndex()

getLastColumnIndex

public int getLastColumnIndex()

getCellCount

public int getCellCount(int rowIndex)

isDataFormatSupported

public boolean isDataFormatSupported()

setAutoFilter

public void setAutoFilter(int firstRow,
                          int firstColumn)

getSheetNames

public String[] getSheetNames()

isFreezePaneSupported

public boolean isFreezePaneSupported()

isHyperlinkSupported

public boolean isHyperlinkSupported()

isCellStyleSupported

public boolean isCellStyleSupported()

isEvaluateExpressions

public boolean isEvaluateExpressions()

setEvaluateExpressions

public com.northconcepts.datapipeline.excel.Provider setEvaluateExpressions(boolean evaluateExpressions)

saveWorkbook

public void saveWorkbook(File file)
                  throws Throwable

Throws:

Throwable

startReading

public final void startReading(String sheetName)

startReading

public final void startReading(int sheetIndex)

endReading

public final void endReading()

startWriting

public final void startWriting(String sheetName,
                               int sheetIndex)

endWriting

public final void endWriting()

setFreezePane

protected void setFreezePane()

setFreezePaneImpl

protected void setFreezePaneImpl(int columns,
                                 int rows)

startRecord

public void startRecord(Record record,
                        int currentRowIndex)

endRecord

public void endRecord(Record record,
                      int currentRowIndex)

setExcelReader

protected void setExcelReader(ExcelReader excelReader)

getExcelReader

protected ExcelReader getExcelReader()

setExcelWriter

protected void setExcelWriter(ExcelWriter excelWriter)

getExcelWriter

protected ExcelWriter getExcelWriter()

initStyles

public void initStyles()

addExceptionProperties

public DataException addExceptionProperties(DataException exception)

Description copied from interface: DataExceptionContributor

Adds this object's current state to a DataException. Since this method is called whenever an exception is thrown, subclasses should override it to add their specific information.

Specified by:

addExceptionProperties in interface DataExceptionContributor