com.northconcepts.datapipeline.excel

Class PoiXssfSaxProvider

java.lang.Object

com.northconcepts.datapipeline.excel.PoiXssfSaxProvider

public class PoiXssfSaxProvider
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
protected Sheet	sheet
protected Workbook	workbook

Constructor Summary

Constructors

Constructor and Description
PoiXssfSaxProvider()

Method Summary

Modifier and Type	Method and Description
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()
protected void	init()
boolean	isEvaluateExpressions()
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)
void	setStyleFormat(FieldType fieldType, String pattern)
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 recordndex, int fieldIndex, Field field)

Methods inherited from class java.lang.Object

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

Field Detail

workbook

protected Workbook workbook

sheet

protected Sheet sheet

Constructor Detail

PoiXssfSaxProvider

public PoiXssfSaxProvider()

Method Detail

openWorkbook

public void openWorkbook(File file)
                  throws Throwable

Throws:

Throwable

openWorkbook

public void openWorkbook(InputStream inputStream)

init

protected void init()

close

public void close()

newWorkbook

public void newWorkbook()

saveWorkbook

public void saveWorkbook(OutputStream outputStream)

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 recordndex,
                       int fieldIndex,
                       Field field)

setAutofitColumns

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

endWritingImpl

protected void endWritingImpl()

getCellCount

public int getCellCount(int rowIndex)

getLastRowIndex

public int getLastRowIndex()

getLastColumnIndex

public int getLastColumnIndex()

setStyleFormat

public void setStyleFormat(FieldType fieldType,
                           String pattern)

setAutoFilter

public void setAutoFilter(int firstRow,
                          int firstColumn)

getSheetNames

public String[] getSheetNames()

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()

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()