Module jp.ecuacion.util.poi

Package jp.ecuacion.util.poi.excel.table.reader.concrete

Class StringExcelTableReader

java.lang.Object

jp.ecuacion.util.poi.excel.table.ExcelTable<String>

jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader<String>

jp.ecuacion.util.poi.excel.table.reader.concrete.StringExcelTableReader

All Implemented Interfaces:

IfDataTypeStringExcelTable, IfExcelTable<String>, IfDataTypeStringExcelTableReader, IfExcelTableReader<String>

Direct Known Subclasses:

StringFreeExcelTableReader, StringOneLineHeaderExcelTableReader

public abstract class StringExcelTableReader
extends ExcelTableReader<String>
implements IfDataTypeStringExcelTableReader

Adds String feature to ExcelTableReader.

Nested Class Summary

Nested classes/interfaces inherited from class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader

ExcelTableReader.IterableReader<T>, ExcelTableReader.IteratorReader<T>

Nested classes/interfaces inherited from class jp.ecuacion.util.poi.excel.table.ExcelTable

ExcelTable.ContextContainer

Field Summary

Fields

Modifier and Type	Field	Description
protected Map<Integer,DateTimeFormatter>	columnDateTimeFormatMap
protected DateTimeFormatter	dateTimeFormat

Fields inherited from class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader

tableColumnSizeGivenByConstructor, tableRowSizeGivenByConstructor

Fields inherited from class jp.ecuacion.util.poi.excel.table.ExcelTable

ignoresAdditionalColumnsOfHeaderData, isVerticalAndHorizontalOpposite, sheetName, tableStartColumnNumber, tableStartRowNumber

Constructor Summary

Constructors

Constructor	Description
StringExcelTableReader(String sheetName, Integer tableStartRowNumber, int tableStartColumnNumber, Integer tableRowSize, Integer tableColumnSize)	Constructs a new instance.

Method Summary

Modifier and Type	Method	Description
StringExcelTableReader	columnDateTimeFormat(int columnNumber, DateTimeFormatter dateTimeFormat)	Sets dateTimeFormat for specific column.
StringExcelTableReader	defaultDateTimeFormat(DateTimeFormatter dateTimeFormat)	Sets defaultDateTimeFormat.
DateTimeFormatter	getDateTimeFormat(int columnNumber)	Returns the date time format considering columnDateTimeFormatMap and defaultDateTimeFormat.

Methods inherited from class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader

getIterable, getReadyToReadTableData, getTableColumnSize, getTableRowSize, ignoresAdditionalColumnsOfHeaderData, isVerticalAndHorizontalOpposite, read, read, setTableColumnSize

Methods inherited from class jp.ecuacion.util.poi.excel.table.ExcelTable

getPoiBasisDeterminedTableStartColumnNumber, getPoiBasisDeterminedTableStartRowNumber, getSheetName, ignoresAdditionalColumnsOfHeaderData, isVerticalAndHorizontalOpposite

Methods inherited from class java.lang.Object

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

Methods inherited from interface jp.ecuacion.util.poi.excel.table.IfDataTypeStringExcelTable

getStringValue

Methods inherited from interface jp.ecuacion.util.poi.excel.table.reader.IfDataTypeStringExcelTableReader

getCellData, getNoDataString, isCellDataEmpty

Methods inherited from interface jp.ecuacion.util.poi.excel.table.IfExcelTable

getFarLeftAndTopHeaderLabel, getHeaderLabelData, getNumberOfHeaderLines, getSheetName, ignoresAdditionalColumnsOfHeaderData, ignoresAdditionalColumnsOfHeaderData, isVerticalAndHorizontalOpposite, isVerticalAndHorizontalOpposite

Methods inherited from interface jp.ecuacion.util.poi.excel.table.reader.IfExcelTableReader

updateAndGetHeaderData, validateHeaderData

Field Details

columnDateTimeFormatMap

protected Map<Integer,DateTimeFormatter> columnDateTimeFormatMap

dateTimeFormat

protected DateTimeFormatter dateTimeFormat

Constructor Details

StringExcelTableReader

public StringExcelTableReader(String sheetName,
 Integer tableStartRowNumber,
 int tableStartColumnNumber,
 Integer tableRowSize,
 Integer tableColumnSize)

Constructs a new instance.

Method Details

defaultDateTimeFormat

public StringExcelTableReader defaultDateTimeFormat(DateTimeFormatter dateTimeFormat)

Sets defaultDateTimeFormat.

Parameters:

dateTimeFormat - dateTimeFormat string for DateTimeFormatter.

Returns:

StringExcelTableReader (for method chain)

columnDateTimeFormat

public StringExcelTableReader columnDateTimeFormat(int columnNumber,
 DateTimeFormatter dateTimeFormat)

Sets dateTimeFormat for specific column.

Parameters:

columnNumber - the column number data is obtained from, starting with 1 and column A is equal to columnNumber 1. When the far left column of a table is 2 and you want to speciries the far left column, the columnNumber is 2.

dateTimeFormat - dateTimeFormat string for DateTimeFormatter.

Returns:

StringExcelTableReader (for method chain)

getDateTimeFormat

@Nullable
public DateTimeFormatter getDateTimeFormat(int columnNumber)

Description copied from interface: IfDataTypeStringExcelTableReader

Returns the date time format considering columnDateTimeFormatMap and defaultDateTimeFormat.

Specified by:

getDateTimeFormat in interface IfDataTypeStringExcelTableReader

Parameters:

columnNumber - the column number data is obtained from, starting with 1 and column A is equal to columnNumber 1. When the far left column of a table is 2 and you want to speciries the far left column, the columnNumber is 2.

Returns:

date format