com.northconcepts.datapipeline.excel

Class PoiSxssfProvider

java.lang.Object

com.northconcepts.datapipeline.excel.PoiSxssfProvider

All Implemented Interfaces:

DataExceptionContributor

public class PoiSxssfProvider
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
protected ExcelFieldMetadata	fieldMetadata
protected static int	JAN_1_1970
protected Sheet	sheet
protected Workbook	workbook

Constructor Summary

Constructors

Constructor and Description
PoiSxssfProvider()

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()
protected HyperlinkType	fromExcelHyperlinkType(ExcelHyperlinkType type)
int	getCellCount(int rowIndex)
protected ExcelColor	getDefaultFontColor() Returns default font color for XLSX file type.
protected ExcelReader	getExcelReader()
protected ExcelWriter	getExcelWriter()
int	getLastColumnIndex()
int	getLastRowIndex()
protected SXSSFSheet	getSheet()
String[]	getSheetNames()
protected SXSSFWorkbook	getWorkbook()
protected void	init()
void	initStyles()
boolean	isCellStyleSupported()
boolean	isDataFormatSupported()
boolean	isEvaluateExpressions()
boolean	isFreezePaneSupported()
boolean	isHyperlinkSupported()
void	newWorkbook()
void	openWorkbook(File file)
void	openWorkbook(InputStream inputStream)
protected ExcelColor	readBackgroundColor(CellStyle style)
protected void	readExcelHyperlink(Cell cell, Field field)
protected void	readExcelStyle(Workbook workbook, Cell cell, Field field)
void	readField(int rowIndex, int fieldIndex, Field field)
protected ExcelColor	readFontColor(Font font)
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)
protected ExcelHyperlinkType	toExcelHyperlinkType(HyperlinkType type)
protected void	writeCellStyle(Workbook workbook, DataFormat format, Cell cell, Field field)
void	writeField(int rowIndex, int columnIndex, int recordndex, int fieldIndex, Field field)
protected void	writeHyperlink(CreationHelper helper, Cell cell, 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

JAN_1_1970

protected static final int JAN_1_1970

See Also:

Constant Field Values

workbook

protected Workbook workbook

sheet

protected Sheet sheet

fieldMetadata

protected ExcelFieldMetadata fieldMetadata

Constructor Detail

PoiSxssfProvider

public PoiSxssfProvider()

Method Detail

getWorkbook

protected SXSSFWorkbook getWorkbook()

getSheet

protected SXSSFSheet getSheet()

newWorkbook

public void newWorkbook()

saveWorkbook

public void saveWorkbook(File file)
                  throws Throwable

Throws:

Throwable

saveWorkbook

public void saveWorkbook(OutputStream outputStream)

startWritingImpl

protected void startWritingImpl(String sheetName,
                                int sheetIndex)

init

protected void init()

setAutoFilter

public void setAutoFilter(int firstRow,
                          int firstColumn)

close

public void close()

isFreezePaneSupported

public boolean isFreezePaneSupported()

isHyperlinkSupported

public boolean isHyperlinkSupported()

isCellStyleSupported

public boolean isCellStyleSupported()

openWorkbook

public void openWorkbook(InputStream inputStream)

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

setFreezePaneImpl

protected void setFreezePaneImpl(int columns,
                                 int rows)

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

getSheetNames

public String[] getSheetNames()

readExcelHyperlink

protected void readExcelHyperlink(Cell cell,
                                  Field field)

readExcelStyle

protected void readExcelStyle(Workbook workbook,
                              Cell cell,
                              Field field)

getDefaultFontColor

protected ExcelColor getDefaultFontColor()

Returns default font color for XLSX file type.

readFontColor

protected ExcelColor readFontColor(Font font)

readBackgroundColor

protected ExcelColor readBackgroundColor(CellStyle style)

writeHyperlink

protected void writeHyperlink(CreationHelper helper,
                              Cell cell,
                              Field field)

toExcelHyperlinkType

protected ExcelHyperlinkType toExcelHyperlinkType(HyperlinkType type)

fromExcelHyperlinkType

protected HyperlinkType fromExcelHyperlinkType(ExcelHyperlinkType type)

writeCellStyle

protected void writeCellStyle(Workbook workbook,
                              DataFormat format,
                              Cell cell,
                              Field field)

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

isEvaluateExpressions

public boolean isEvaluateExpressions()

setEvaluateExpressions

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

openWorkbook

public void openWorkbook(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()

startRecord

public void startRecord(Record record,
                        int currentRowIndex)

endRecord

public void endRecord(Record record,
                      int currentRowIndex)

isDataFormatSupported

public boolean isDataFormatSupported()

setExcelReader

protected void setExcelReader(ExcelReader excelReader)

getExcelReader

protected ExcelReader getExcelReader()

setExcelWriter

protected void setExcelWriter(ExcelWriter excelWriter)

getExcelWriter

protected ExcelWriter getExcelWriter()

initStyles

public void initStyles()