Index
All Classes and Interfaces|All Packages|Constant Field Values
A
- afterReading() - Method in class jp.ecuacion.util.poi.excel.table.bean.StringExcelTableBean
-
Is called after reading an excel file.
C
- CellFreeExcelTableReader - Class in jp.ecuacion.util.poi.excel.table.reader.concrete
-
Reads tables with unknown number of columns, unknown whether it have a header line, unknown header labels if it has a header line.
- CellFreeExcelTableReader(String, Integer, int, Integer, Integer) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.concrete.CellFreeExcelTableReader
-
Constructs a new instance.
- CellFreeExcelTableWriter - Class in jp.ecuacion.util.poi.excel.table.writer.concrete
-
Reads tables with unknown number of columns, unknown whether it have a header line, unknown header labels if it has a header line.
- CellFreeExcelTableWriter(String, Integer, int) - Constructor for class jp.ecuacion.util.poi.excel.table.writer.concrete.CellFreeExcelTableWriter
-
Constructs a new instance.
- CellOneLineHeaderExcelTableReader - Class in jp.ecuacion.util.poi.excel.table.reader.concrete
-
Reads tables with known number of columns, known header labels and known start position of the table.
- CellOneLineHeaderExcelTableReader(String, String[], Integer, int, Integer) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.concrete.CellOneLineHeaderExcelTableReader
-
Constructs a new instance. the obtained value from an empty cell is
null. - CellOneLineHeaderExcelTableWriter - Class in jp.ecuacion.util.poi.excel.table.writer.concrete
-
Reads tables with known number of columns, one line header labels if it has a header line.
- CellOneLineHeaderExcelTableWriter(String, String[], Integer, int) - Constructor for class jp.ecuacion.util.poi.excel.table.writer.concrete.CellOneLineHeaderExcelTableWriter
-
Constructs a new instance.
- columnDateTimeFormat(int, DateTimeFormatter) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringExcelTableReader
-
Sets dateTimeFormat for specific column.
- columnDateTimeFormat(int, DateTimeFormatter) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringFreeExcelTableReader
- columnDateTimeFormat(int, DateTimeFormatter) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableReader
- columnDateTimeFormat(int, DateTimeFormatter) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableToBeanReader
- columnDateTimeFormatMap - Variable in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringExcelTableReader
- ContextContainer(Sheet, int, int, Integer, Integer) - Constructor for class jp.ecuacion.util.poi.excel.table.ExcelTable.ContextContainer
-
Constructs a new instance.
- copiesDataFormatOnly() - Method in class jp.ecuacion.util.poi.excel.table.writer.concrete.CellFreeExcelTableWriter
- copiesDataFormatOnly() - Method in class jp.ecuacion.util.poi.excel.table.writer.concrete.CellOneLineHeaderExcelTableWriter
- copiesDataFormatOnly() - Method in interface jp.ecuacion.util.poi.excel.table.writer.IfDataTypeCellExcelTableWriter
-
Returns copiesDataFormatOnly value.
- copiesDataFormatOnly(boolean) - Method in class jp.ecuacion.util.poi.excel.table.writer.concrete.CellFreeExcelTableWriter
- copiesDataFormatOnly(boolean) - Method in class jp.ecuacion.util.poi.excel.table.writer.concrete.CellOneLineHeaderExcelTableWriter
- copiesDataFormatOnly(boolean) - Method in interface jp.ecuacion.util.poi.excel.table.writer.IfDataTypeCellExcelTableWriter
-
Sets copiesDataFormatOnly value.
- createWorkbookWithSheet(String) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelWriteUtil
-
Creates new workbook with adding sheet of name
sheetName.
D
- dateTimeFormat - Variable in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringExcelTableReader
- defaultDateTimeFormat(DateTimeFormatter) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringExcelTableReader
-
Sets defaultDateTimeFormat.
- defaultDateTimeFormat(DateTimeFormatter) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringFreeExcelTableReader
- defaultDateTimeFormat(DateTimeFormatter) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableReader
- defaultDateTimeFormat(DateTimeFormatter) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableToBeanReader
E
- EMPTY_STRING - Enum constant in enum class jp.ecuacion.util.poi.excel.enums.NoDataString
-
means
empty string (""). - emptyToNull(String) - Method in class jp.ecuacion.util.poi.excel.table.bean.StringExcelTableBean
-
Returns
nullif the argument value is empty or returns the argument value. - evaluateFormula(Cell, String) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelWriteUtil
-
Catches
Exceptions which are thrown whenworkbook.getCreationHelper().createFormulaEvaluator().evaluateAll()is called and changes it to aExcelAppExceptionwith an appropriate message. - evaluateFormula(Workbook, String, boolean) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelWriteUtil
-
Catches
Exceptions which are thrown whenworkbook.getCreationHelper().createFormulaEvaluator().evaluateFormulaCell()is called and changes it to aExcelAppExceptionwith an appropriate message. - evaluateFormula(Workbook, String, boolean, String...) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelWriteUtil
-
Catches
Exceptions which are thrown whenworkbook.getCreationHelper().createFormulaEvaluator().evaluateFormulaCell()is called and changes it to aExcelAppExceptionwith an appropriate message. - ExcelReadUtil - Class in jp.ecuacion.util.poi.excel.util
-
Provides excel reading related
apache POIutility methods. - ExcelTable<T> - Class in jp.ecuacion.util.poi.excel.table
-
Stores properties in an excel table.
- ExcelTable(String, Integer, int) - Constructor for class jp.ecuacion.util.poi.excel.table.ExcelTable
-
Constructs a new instance with the sheet name, the position and the size of the excel table.
- ExcelTable.ContextContainer - Class in jp.ecuacion.util.poi.excel.table
-
Stores context data.
- ExcelTableReader<T> - Class in jp.ecuacion.util.poi.excel.table.reader
-
Is a parent of excel table reader classes.
- ExcelTableReader(String, Integer, int, Integer, Integer) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
-
Constructs a new instance with the sheet name, the position and the size of the excel table.
- ExcelTableReader.IterableReader<T> - Class in jp.ecuacion.util.poi.excel.table.reader
-
Provides
Iterable. - ExcelTableReader.IteratorReader<T> - Class in jp.ecuacion.util.poi.excel.table.reader
-
Provides Iterator.
- excelTableToBeanList(String) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableToBeanReader
-
Obtains excel table in the form of
List<PoiStringTableBean>. - ExcelTableWriter<T> - Class in jp.ecuacion.util.poi.excel.table.writer
-
Is a parent of excel table writer classes.
- ExcelTableWriter(String, Integer, int) - Constructor for class jp.ecuacion.util.poi.excel.table.writer.ExcelTableWriter
-
Constructs a new instance with the sheet name, the position of the excel table.
- ExcelTableWriter.IterableWriter<T> - Class in jp.ecuacion.util.poi.excel.table.writer
-
Provides
Iterable. - ExcelWriteUtil - Class in jp.ecuacion.util.poi.excel.util
-
Provides excel writing related
apache POIutility methods.
G
- getCellData(Cell, int) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfDataTypeCellExcelTableReader
- getCellData(Cell, int) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfDataTypeStringExcelTableReader
- getCellData(Cell, int) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfExcelTableReader
-
Returns the obtained value from the cell.
- getColumnStyleMap() - Method in class jp.ecuacion.util.poi.excel.table.writer.concrete.CellFreeExcelTableWriter
- getColumnStyleMap() - Method in class jp.ecuacion.util.poi.excel.table.writer.concrete.CellOneLineHeaderExcelTableWriter
- getColumnStyleMap() - Method in interface jp.ecuacion.util.poi.excel.table.writer.IfDataTypeCellExcelTableWriter
-
Gets
columnStyleMapto reuseCellStyle. - getDateTimeFormat(int) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringExcelTableReader
- getDateTimeFormat(int) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfDataTypeStringExcelTableReader
-
Returns the date time format considering
columnDateTimeFormatMapanddefaultDateTimeFormat. - getFarLeftAndTopHeaderLabel() - Method in interface jp.ecuacion.util.poi.excel.table.IfExcelTable
-
Returns the value of the far left and top header cell to specify the position of the table.
- getFarLeftAndTopHeaderLabel() - Method in interface jp.ecuacion.util.poi.excel.table.IfFormatFreeExcelTable
- getFarLeftAndTopHeaderLabel() - Method in interface jp.ecuacion.util.poi.excel.table.IfFormatOneLineHeaderExcelTable
- getFarLeftAndTopHeaderLabel() - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.CellOneLineHeaderExcelTableReader
- getFieldNameArray() - Method in class jp.ecuacion.util.poi.excel.table.bean.StringExcelTableBean
-
Returns
Stringarray of field names in the bean. - getHeaderLabelData() - Method in interface jp.ecuacion.util.poi.excel.table.IfExcelTable
-
Returns an array of header label strings.
- getHeaderLabelData() - Method in interface jp.ecuacion.util.poi.excel.table.IfFormatFreeExcelTable
- getHeaderLabelData() - Method in interface jp.ecuacion.util.poi.excel.table.IfFormatOneLineHeaderExcelTable
- getHeaderLabels() - Method in interface jp.ecuacion.util.poi.excel.table.IfFormatOneLineHeaderExcelTable
-
Defines the header labels in the excel table.
- getHeaderLabels() - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.CellOneLineHeaderExcelTableReader
- getHeaderLabels() - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableReader
- getHeaderLabels() - Method in class jp.ecuacion.util.poi.excel.table.writer.concrete.CellOneLineHeaderExcelTableWriter
- getIterable(Workbook) - Method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
-
Provides an
Iterablereader. - getIterable(Workbook) - Method in class jp.ecuacion.util.poi.excel.table.writer.ExcelTableWriter
-
Provides an
Iterablewriter. - getNoDataString() - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringFreeExcelTableReader
- getNoDataString() - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableReader
- getNoDataString() - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfDataTypeStringExcelTableReader
-
Gets NoDataString.
- getNoDataStringIfNoData(String, String) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelReadUtil
-
Returns proper
NoDataStringvalue if the argument value isnullor"", otherwize returns the argument value. - getNumberOfHeaderLines() - Method in interface jp.ecuacion.util.poi.excel.table.IfExcelTable
-
Returns the number of header lines.
- getNumberOfHeaderLines() - Method in interface jp.ecuacion.util.poi.excel.table.IfFormatFreeExcelTable
- getNumberOfHeaderLines() - Method in interface jp.ecuacion.util.poi.excel.table.IfFormatOneLineHeaderExcelTable
- getPoiBasisDeterminedTableStartColumnNumber() - Method in class jp.ecuacion.util.poi.excel.table.ExcelTable
-
Returns tableStartColumnNumber.
- getPoiBasisDeterminedTableStartRowNumber(Sheet, int) - Method in class jp.ecuacion.util.poi.excel.table.ExcelTable
-
Returns the row number at which the table starts.
- getReadyToEvaluateFormula(Cell, boolean, boolean, boolean, String[]) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelWriteUtil
-
There are patterns where excel can evaluate formulas but POI cannot.
- getReadyToReadTableData(ExcelTableReader<T>, Workbook, String, int, Integer, boolean) - Static method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
-
Gets ready to read table data.
- getReadyToWriteTableData(ExcelTableWriter<T>, Workbook, String, int) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelWriteUtil
-
Gets ready to write table data.
- getSheetName() - Method in class jp.ecuacion.util.poi.excel.table.ExcelTable
- getSheetName() - Method in interface jp.ecuacion.util.poi.excel.table.IfExcelTable
-
Returns the excel sheet name the
TableReaderand theTableWriteraccess. - getStringFromCell(Cell) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelReadUtil
-
Returns
Stringformat cell value in spite of the format or value kind of the cell. - getStringFromCell(Cell, String) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelReadUtil
-
Returns
Stringformat cell value in spite of the format or value kind of the cell. - getStringFromCell(Cell, String, DateTimeFormatter) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelReadUtil
-
Returns
Stringformat cell value in spite of the format or value kind of the cell. - getStringFromCell(Cell, String, DateTimeFormatter, String) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelReadUtil
-
Returns
Stringformat cell value in spite of the format or value kind of the cell. - getStringValue(String) - Method in interface jp.ecuacion.util.poi.excel.table.IfDataTypeStringExcelTable
- getStringValue(Cell) - Method in interface jp.ecuacion.util.poi.excel.table.IfDataTypeCellExcelTable
- getStringValue(Cell) - Method in class jp.ecuacion.util.poi.excel.table.writer.concrete.CellFreeExcelTableWriter
- getStringValue(T) - Method in interface jp.ecuacion.util.poi.excel.table.IfExcelTable
-
Is used to get the header label string from the argument cell data.
- getTableColumnSize(Sheet, int, int, boolean) - Method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
-
Returns tableColumnSize.
- getTableRowSize() - Method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
-
Returns tableRowSize, may be
null.
H
- hasNext() - Method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader.IteratorReader
- headerCheck(Workbook) - Method in class jp.ecuacion.util.poi.excel.table.writer.concrete.CellFreeExcelTableWriter
- headerCheck(Workbook) - Method in class jp.ecuacion.util.poi.excel.table.writer.concrete.CellOneLineHeaderExcelTableWriter
- headerCheck(Workbook) - Method in class jp.ecuacion.util.poi.excel.table.writer.ExcelTableWriter
-
Obtains header list from the file at
templateFilePath.
I
- IfDataTypeCellExcelTable - Interface in jp.ecuacion.util.poi.excel.table
-
Provides the excel table interface with object type obtained from the excel data is
Cell. - IfDataTypeCellExcelTableReader - Interface in jp.ecuacion.util.poi.excel.table.reader
-
Provides the excel table reader interface with object type obtained from the excel data is
Cell. - IfDataTypeCellExcelTableWriter - Interface in jp.ecuacion.util.poi.excel.table.writer
-
Provides the excel table writer interface with object type obtained from the excel data is
Cell. - IfDataTypeStringExcelTable - Interface in jp.ecuacion.util.poi.excel.table
-
Provides the excel table interface with object type obtained from the excel data is
String. - IfDataTypeStringExcelTableReader - Interface in jp.ecuacion.util.poi.excel.table.reader
-
Provides the excel table reader interface with object type obtained from the excel data is
String. - IfExcelTable<T> - Interface in jp.ecuacion.util.poi.excel.table
-
Provides the methods the extending interfaces use.
- IfExcelTableReader<T> - Interface in jp.ecuacion.util.poi.excel.table.reader
-
Provides the excel table reader methods.
- IfExcelTableWriter<T> - Interface in jp.ecuacion.util.poi.excel.table.writer
-
Provides the excel table writer methods.
- IfFormatFreeExcelTable<T> - Interface in jp.ecuacion.util.poi.excel.table
-
Is a reader interface which treats free format tables.
- IfFormatFreeExcelTableReader<T> - Interface in jp.ecuacion.util.poi.excel.table.reader
-
Is a reader which treats free format tables.
- IfFormatOneLineHeaderExcelTable<T> - Interface in jp.ecuacion.util.poi.excel.table
-
Is a reader interface which treats one line header format tables.
- IfFormatOneLineHeaderExcelTableReader<T> - Interface in jp.ecuacion.util.poi.excel.table.reader
-
Is a reader which treats one line header format tables.
- ignoresAdditionalColumnsOfHeaderData - Variable in class jp.ecuacion.util.poi.excel.table.ExcelTable
- ignoresAdditionalColumnsOfHeaderData() - Method in class jp.ecuacion.util.poi.excel.table.ExcelTable
- ignoresAdditionalColumnsOfHeaderData() - Method in interface jp.ecuacion.util.poi.excel.table.IfExcelTable
-
Obtains the boolean value which indicates whether
validateHeaderDataignores additional header columns. - ignoresAdditionalColumnsOfHeaderData(boolean) - Method in interface jp.ecuacion.util.poi.excel.table.IfExcelTable
-
Stores the boolean value which indicates whether
validateHeaderDataignores additional header columns. - ignoresAdditionalColumnsOfHeaderData(boolean) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableToBeanReader
- ignoresAdditionalColumnsOfHeaderData(boolean) - Method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
- ignoresAdditionalColumnsOfHeaderData(boolean) - Method in class jp.ecuacion.util.poi.excel.table.writer.ExcelTableWriter
- isCellDataEmpty(String) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfDataTypeStringExcelTableReader
- isCellDataEmpty(Cell) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfDataTypeCellExcelTableReader
- isCellDataEmpty(T) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfExcelTableReader
-
Returns whether the value of the cell is empty.
- isVerticalAndHorizontalOpposite - Variable in class jp.ecuacion.util.poi.excel.table.ExcelTable
- isVerticalAndHorizontalOpposite() - Method in class jp.ecuacion.util.poi.excel.table.ExcelTable
- isVerticalAndHorizontalOpposite() - Method in interface jp.ecuacion.util.poi.excel.table.IfExcelTable
-
Obtains whether header is top (normal table) or left.
- isVerticalAndHorizontalOpposite(boolean) - Method in interface jp.ecuacion.util.poi.excel.table.IfExcelTable
-
Decides whether header is top (normal table) or left.
- isVerticalAndHorizontalOpposite(boolean) - Method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
- isVerticalAndHorizontalOpposite(boolean) - Method in class jp.ecuacion.util.poi.excel.table.writer.ExcelTableWriter
- IterableReader(ExcelTableReader<T>, ExcelTable.ContextContainer, int) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader.IterableReader
-
Constructs a new instance.
- IterableWriter(ExcelTableWriter<T>, ExcelTable.ContextContainer, int) - Constructor for class jp.ecuacion.util.poi.excel.table.writer.ExcelTableWriter.IterableWriter
-
Constructs a new instance.
- iterator() - Method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader.IterableReader
- IteratorReader(ExcelTableReader<T>, ExcelTable.ContextContainer, int) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader.IteratorReader
-
Constructs a new instance.
J
- jp.ecuacion.util.poi - module jp.ecuacion.util.poi
-
Provides excel-related
apache POIutility classes. - jp.ecuacion.util.poi.excel.enums - package jp.ecuacion.util.poi.excel.enums
-
Provides enums.
- jp.ecuacion.util.poi.excel.table - package jp.ecuacion.util.poi.excel.table
-
Provides abstract classes and interfaces which are related to excel table reading and writing.
- jp.ecuacion.util.poi.excel.table.bean - package jp.ecuacion.util.poi.excel.table.bean
-
Stores the data obtained by
StringExcelTableToBeanReader. - jp.ecuacion.util.poi.excel.table.reader - package jp.ecuacion.util.poi.excel.table.reader
-
Provides excel table reader abstract classes and interfaces.
- jp.ecuacion.util.poi.excel.table.reader.concrete - package jp.ecuacion.util.poi.excel.table.reader.concrete
-
Provides excel table reader concrete classes.
- jp.ecuacion.util.poi.excel.table.writer - package jp.ecuacion.util.poi.excel.table.writer
-
Provides excel table writer abstract classes and interfaces.
- jp.ecuacion.util.poi.excel.table.writer.concrete - package jp.ecuacion.util.poi.excel.table.writer.concrete
-
Provides excel table writer concrete classes.
- jp.ecuacion.util.poi.excel.util - package jp.ecuacion.util.poi.excel.util
-
Provides excel-related poi utility methods used by
ecuacion-util-poiclasses.
M
- max - Static variable in class jp.ecuacion.util.poi.excel.table.ExcelTable.ContextContainer
N
- next() - Method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader.IteratorReader
- NoDataString - Enum Class in jp.ecuacion.util.poi.excel.enums
-
Has the selections which
javagets when the value of a cell in an excel file is empty. - NULL - Enum constant in enum class jp.ecuacion.util.poi.excel.enums.NoDataString
-
means
null. - nullToEmpty(String) - Method in class jp.ecuacion.util.poi.excel.table.bean.StringExcelTableBean
-
Returns
emptyif the argument value is null or returns the argument value.
O
- openForOutput(String) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelWriteUtil
-
Opens the excel file and returns
Workbookobject. - openForRead(String) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelReadUtil
-
Opens the excel file and returns
Workbookobject. - openForWrite(String) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelWriteUtil
-
Opens the excel file and returns
Workbookobject.
P
- poiBasisTableStartColumnNumber - Variable in class jp.ecuacion.util.poi.excel.table.ExcelTable.ContextContainer
- poiBasisTableStartRowNumber - Variable in class jp.ecuacion.util.poi.excel.table.ExcelTable.ContextContainer
R
- read(String) - Method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
-
Reads a table data in an excel file at
excelPathand Return it in the form ofList<List<T>>. - read(Workbook) - Method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
-
Reads a table data in an excel file at
filePathand Return it in the form ofList<List<T>>. - readToBean(String) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableToBeanReader
-
Obtains excel table in the form of
List<PoiStringTableBean>and validate obtained values.. - readToBean(String, boolean) - Method in class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableToBeanReader
-
Obtains excel table in the form of
List<PoiStringTableBean>and validate obtained values..
S
- saveToFile(Workbook, FileOutputStream) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelWriteUtil
-
Opens the excel file and returns
Workbookobject. - setTableColumnSize(int) - Method in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
-
sets
tableColumnSize. - sheet - Variable in class jp.ecuacion.util.poi.excel.table.ExcelTable.ContextContainer
- sheetName - Variable in class jp.ecuacion.util.poi.excel.table.ExcelTable
-
Is the sheet name of the excel file.
- StringExcelTableBean - Class in jp.ecuacion.util.poi.excel.table.bean
-
Stores values obtained from excel tables with
StringFixedTableToBeanReader. - StringExcelTableBean(List<String>) - Constructor for class jp.ecuacion.util.poi.excel.table.bean.StringExcelTableBean
-
Constructs a new instance with the list of strings which consists of data of a line from the excel table.
- StringExcelTableReader - Class in jp.ecuacion.util.poi.excel.table.reader.concrete
-
Adds String feature to
ExcelTableReader. - StringExcelTableReader(String, Integer, int, Integer, Integer) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.concrete.StringExcelTableReader
-
Constructs a new instance.
- StringFreeExcelTableReader - Class in jp.ecuacion.util.poi.excel.table.reader.concrete
-
Reads tables with unknown number of columns, unknown whether it have a header line, unknown header labels if it has a header line.
- StringFreeExcelTableReader(String, Integer, int, Integer, Integer) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.concrete.StringFreeExcelTableReader
-
Constructs a new instance.
- StringFreeExcelTableReader(String, Integer, int, Integer, Integer, NoDataString) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.concrete.StringFreeExcelTableReader
-
Constructs a new instance.
- StringOneLineHeaderExcelTableReader - Class in jp.ecuacion.util.poi.excel.table.reader.concrete
-
Reads tables with known number of columns, known header labels and known start position of the table.
- StringOneLineHeaderExcelTableReader(String, String[], Integer, int, Integer) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableReader
-
Constructs a new instance. the obtained value from an empty cell is
null. - StringOneLineHeaderExcelTableReader(String, String[], Integer, int, Integer, NoDataString) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableReader
-
Constructs a new instance with the obtained value from an empty cell.
- StringOneLineHeaderExcelTableToBeanReader<T> - Class in jp.ecuacion.util.poi.excel.table.reader.concrete
-
Stores the excel table data into a bean.
- StringOneLineHeaderExcelTableToBeanReader(Class<?>, String, String[], Integer, int, Integer, NoDataString) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableToBeanReader
-
Constructs a new instance with the obtained value from an empty cell.
- StringOneLineHeaderExcelTableToBeanReader(Class<?>, String, String[], Integer, int, Integer, T...) - Constructor for class jp.ecuacion.util.poi.excel.table.reader.concrete.StringOneLineHeaderExcelTableToBeanReader
-
Constructs a new instance. the obtained value from an empty cell is
null.
T
- tableColumnSize - Variable in class jp.ecuacion.util.poi.excel.table.ExcelTable.ContextContainer
- tableColumnSizeGivenByConstructor - Variable in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
-
Is the column size of the table.
- tableRowSize - Variable in class jp.ecuacion.util.poi.excel.table.ExcelTable.ContextContainer
- tableRowSizeGivenByConstructor - Variable in class jp.ecuacion.util.poi.excel.table.reader.ExcelTableReader
-
Is the row size of the table.
- tableStartColumnNumber - Variable in class jp.ecuacion.util.poi.excel.table.ExcelTable
-
Is the column number from which the table starts.
- tableStartRowNumber - Variable in class jp.ecuacion.util.poi.excel.table.ExcelTable
-
Is the row number from which the table starts.
- toBigDecimal(String) - Method in class jp.ecuacion.util.poi.excel.table.bean.StringExcelTableBean
-
Returns
BigDecimaldatatype of the argument string. - toBigInteger(String) - Method in class jp.ecuacion.util.poi.excel.table.bean.StringExcelTableBean
-
Returns
BigIntegerdatatype of the argument string. - toDouble(String) - Method in class jp.ecuacion.util.poi.excel.table.bean.StringExcelTableBean
-
Returns
Doubledatatype of the argument string. - toFloat(String) - Method in class jp.ecuacion.util.poi.excel.table.bean.StringExcelTableBean
-
Returns
Floatdatatype of the argument string. - toInteger(String) - Method in class jp.ecuacion.util.poi.excel.table.bean.StringExcelTableBean
-
Returns
Integerdatatype of the argument string. - toLong(String) - Method in class jp.ecuacion.util.poi.excel.table.bean.StringExcelTableBean
-
Returns
Longdatatype of the argument string.
U
- updateAndGetHeaderData(List<List<T>>) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfExcelTableReader
-
Updates excel data to treat it easily, like remove its header line, and returns the header list.
- updateAndGetHeaderData(List<List<T>>) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfFormatFreeExcelTableReader
- updateAndGetHeaderData(List<List<T>>) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfFormatOneLineHeaderExcelTableReader
V
- validateHeaderData(List<List<T>>) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfExcelTableReader
-
Validates the excel table header.
- validateHeaderData(List<List<T>>) - Method in interface jp.ecuacion.util.poi.excel.table.reader.IfFormatFreeExcelTableReader
- valueOf(String) - Static method in enum class jp.ecuacion.util.poi.excel.enums.NoDataString
-
Returns the enum constant of this class with the specified name.
- values() - Static method in enum class jp.ecuacion.util.poi.excel.enums.NoDataString
-
Returns an array containing the constants of this enum class, in the order they are declared.
W
- write(String, String, List<List<T>>) - Method in class jp.ecuacion.util.poi.excel.table.writer.ExcelTableWriter
-
Writes table data to the specified excel file.
- write(String, List<List<T>>) - Method in class jp.ecuacion.util.poi.excel.table.writer.ExcelTableWriter
-
Writes table data to the designated excel file.
- write(List<T>) - Method in class jp.ecuacion.util.poi.excel.table.writer.ExcelTableWriter.IterableWriter
-
Writes one line.
- write(Workbook, List<List<T>>) - Method in class jp.ecuacion.util.poi.excel.table.writer.ExcelTableWriter
-
Writes table data to the designated excel file.
- writeTableLine(ExcelTableWriter<T>, ExcelTable.ContextContainer, int, List<T>) - Static method in class jp.ecuacion.util.poi.excel.util.ExcelWriteUtil
-
Provides common procedure for write one line of a table.
- writeToCell(int, Cell, Cell) - Method in interface jp.ecuacion.util.poi.excel.table.writer.IfDataTypeCellExcelTableWriter
-
Writes a value to the cell.
- writeToCell(int, T, Cell) - Method in interface jp.ecuacion.util.poi.excel.table.writer.IfExcelTableWriter
-
writes cell data to the cell.
All Classes and Interfaces|All Packages|Constant Field Values