Index
All Classes and Interfaces|All Packages|Serialized Form
A
- Address - Class in io.github.mbenincasa.javaexcelutils.samples.parseSheetToExcel
- Address() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.parseSheetToExcel.Address
- appendCells(String, Stream<Object[]>) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Method that allows you to append a data matrix starting from a source cell
- autoSize() - Element in annotation interface io.github.mbenincasa.javaexcelutils.annotations.ExcelHeaderStyle
C
- cellColor() - Element in annotation interface io.github.mbenincasa.javaexcelutils.annotations.ExcelBodyStyle
- cellColor() - Element in annotation interface io.github.mbenincasa.javaexcelutils.annotations.ExcelHeaderStyle
- CellNotFoundException - Exception in io.github.mbenincasa.javaexcelutils.exceptions
-
This exception signals that the Excel cell was not found
- CellNotFoundException() - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.CellNotFoundException
-
Constructs an
CellNotFoundException
withnull
as its error detail message. - CellNotFoundException(String) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.CellNotFoundException
-
Constructs an
CellNotFoundException
with the specified detail message. - CellNotFoundException(String, Throwable) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.CellNotFoundException
-
Constructs an
CellNotFoundException
with the specified detail message and cause. - checkExcelExtension(String) - Static method in class io.github.mbenincasa.javaexcelutils.tools.ExcelUtility
-
Check if the extension is that of an Excel file
- close() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Close a workbook
- close(CSVWriter) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Close a workbook
- close(InputStream) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Close a workbook
- close(OutputStream) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Close a workbook
- close(OutputStream, CSVReader) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Close a workbook
- close(OutputStream, InputStream) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Close a workbook
- Converter - Class in io.github.mbenincasa.javaexcelutils.tools
-
Converter
is the static class with implementations of conversion methods - Converter() - Constructor for class io.github.mbenincasa.javaexcelutils.tools.Converter
- countAllColumns(Boolean) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Counts how many Cells are compiled
- countAllRows(Boolean) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Counts how many Rows are compiled
- countSheets() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
The amount of Sheets in the Workbook
- create() - Static method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Create a new workbook
- create(Extension) - Static method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Create a new workbook
- create(String) - Static method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Create a new workbook
- createCell(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Create a new Cell in the Row
- createRow(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Create a new Row in the Sheet
- createSheet() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Create a new Sheet inside the Workbook
- createSheet(String) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Create a new Sheet inside the Workbook
- CSV - Enum constant in enum class io.github.mbenincasa.javaexcelutils.enums.Extension
-
This extension is used for CSV (Comma-separated values) files
- csvToExcelByte(byte[], String, Extension) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- csvToExcelFile(File, String, String, Extension) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- csvToExcelStream(InputStream, String, Extension) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
D
- deltaCol() - Element in annotation interface io.github.mbenincasa.javaexcelutils.annotations.ExcelCellMapping
- deltaRow() - Element in annotation interface io.github.mbenincasa.javaexcelutils.annotations.ExcelCellMapping
- Direction - Enum Class in io.github.mbenincasa.javaexcelutils.model.parser
-
This enum defines the direction of the list in an Excel sheet which is used in the parseToList() method in the ExcelSheet
E
- Employee - Class in io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToObjects
- Employee - Class in io.github.mbenincasa.javaexcelutils.samples.convertObjectsToExcelFile
- Employee - Class in io.github.mbenincasa.javaexcelutils.samples.parseSheetToExcel
- Employee() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToObjects.Employee
- Employee() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.convertObjectsToExcelFile.Employee
- Employee() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.parseSheetToExcel.Employee
- ExcelBodyStyle - Annotation Interface in io.github.mbenincasa.javaexcelutils.annotations
-
This annotation defines the style of the Excel file body when converting a list of objects to an Excel file
- excelByteToObjects(byte[], List<ExcelToObject<?>>) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- ExcelCell - Class in io.github.mbenincasa.javaexcelutils.model.excel
-
ExcelCell
is theCell
wrapper class of the Apache POI library - ExcelCell() - Constructor for class io.github.mbenincasa.javaexcelutils.model.excel.ExcelCell
- ExcelCellMapping - Annotation Interface in io.github.mbenincasa.javaexcelutils.annotations
-
This annotation is needed when the parseToObject() method in ExcelSheet is used
- ExcelCellParser - Interface in io.github.mbenincasa.javaexcelutils.model.parser
-
This interface is needed when the parseToObject() method in the ExcelSheet is used.
- ExcelField - Annotation Interface in io.github.mbenincasa.javaexcelutils.annotations
-
This annotation defines the header field of the Excel file
- excelFileToObjects(File, List<ExcelToObject<?>>) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- ExcelHeaderStyle - Annotation Interface in io.github.mbenincasa.javaexcelutils.annotations
-
This annotation defines the header style of the Excel file when converting a list of objects to an Excel file
- ExcelListParserMapping - Class in io.github.mbenincasa.javaexcelutils.model.parser
-
Class used to define the rules to be applied for a Sheet in a list of objects
- ExcelListParserMapping() - Constructor for class io.github.mbenincasa.javaexcelutils.model.parser.ExcelListParserMapping
- ExcelRow - Class in io.github.mbenincasa.javaexcelutils.model.excel
-
ExcelRow
is theRow
wrapper class of the Apache POI library - ExcelRow() - Constructor for class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
- ExcelSheet - Class in io.github.mbenincasa.javaexcelutils.model.excel
-
ExcelSheet
is theSheet
wrapper class of the Apache POI library - ExcelSheet() - Constructor for class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
- excelStreamToObjects(InputStream, List<ExcelToObject<?>>) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- excelToCsvByte(byte[]) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- excelToCsvFile(File, String) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- excelToCsvStream(InputStream) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- excelToJsonByte(byte[]) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- excelToJsonFile(File, String) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- excelToJsonStream(InputStream) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- ExcelToObject<T> - Class in io.github.mbenincasa.javaexcelutils.model.converter
-
This is a support class that is used by the
Converter
to perform conversions from Excel to Objects - ExcelToObject() - Constructor for class io.github.mbenincasa.javaexcelutils.model.converter.ExcelToObject
- ExcelUtility - Class in io.github.mbenincasa.javaexcelutils.tools
-
ExcelUtility
is the static class with the implementations of some utilities on Excel files - ExcelUtility() - Constructor for class io.github.mbenincasa.javaexcelutils.tools.ExcelUtility
- ExcelWorkbook - Class in io.github.mbenincasa.javaexcelutils.model.excel
-
ExcelWorkbook
is theWorkbook
wrapper class of the Apache POI library - Extension - Enum Class in io.github.mbenincasa.javaexcelutils.enums
-
This Enum defines the file extensions supported by the library.
- ExtensionNotValidException - Exception in io.github.mbenincasa.javaexcelutils.exceptions
-
This exception signals that the extension is invalid
- ExtensionNotValidException() - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.ExtensionNotValidException
-
Constructs an
ExtensionNotValidException
withnull
as its error detail message. - ExtensionNotValidException(String) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.ExtensionNotValidException
-
Constructs an
ExtensionNotValidException
with the specified detail message. - ExtensionNotValidException(String, Throwable) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.ExtensionNotValidException
-
Constructs an
ExtensionNotValidException
with the specified detail message and cause.
F
- FileAlreadyExistsException - Exception in io.github.mbenincasa.javaexcelutils.exceptions
-
This exception signals that the file already exists
- FileAlreadyExistsException(String) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.FileAlreadyExistsException
-
Constructs an
FileAlreadyExistsException
with the specified detail message. - formatStyle(short) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelCell
-
Format text according to the pattern provided
- formatStyle(String) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelCell
-
Format the cell according to the chosen format
G
- getCell(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Retrieve a cell by index
- getCellIndexes(String) - Static method in class io.github.mbenincasa.javaexcelutils.tools.ExcelUtility
-
Return an array containing column and row indexes
- getCellName() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelCell
-
Returns the cell name
- getCellName(int, int) - Static method in class io.github.mbenincasa.javaexcelutils.tools.ExcelUtility
-
Returns the cell name
- getCells() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
The list of Cells related to the Row
- getExcelExtension(String) - Static method in enum class io.github.mbenincasa.javaexcelutils.enums.Extension
-
This method retrieves the Enum value based on the extension name provided as input
- getFormulaEvaluator() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Create a new FormulaEvaluator
- getIndex() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
The Sheet index in the Workbook
- getLastColumnIndex() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Retrieves the index of the last Cell
- getLastRowIndex() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Retrieves the index of the last Row
- getOrCreateCell(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Retrieve or create a cell by index
- getOrCreateRow(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Retrieve or create a row by index
- getRow() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelCell
-
Returns the Row to which it belongs
- getRow(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Retrieve a row by index
- getRows() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
The list of Rows related to the Sheet
- getSheet() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Returns the Sheet to which it belongs
- getSheet() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Retrieve the Sheet with index 0
- getSheet(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Retrieve the Sheet with the requested name
- getSheet(String) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Retrieve the Sheet with the requested index
- getSheetOrCreate(String) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Retrieve the Sheet with the required name otherwise create it
- getSheets() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
The list of Sheets related to the Workbook
- getWorkbook() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Returns the Workbook to which it belongs
H
- HeaderNotPresentException - Exception in io.github.mbenincasa.javaexcelutils.exceptions
-
This exception signals that the file header is missing
- HeaderNotPresentException() - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.HeaderNotPresentException
-
Constructs an
HeaderNotPresentException
withnull
as its error detail message. - HeaderNotPresentException(String) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.HeaderNotPresentException
-
Constructs an
HeaderNotPresentException
with the specified detail message. - HeaderNotPresentException(String, Throwable) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.HeaderNotPresentException
-
Constructs an
HeaderNotPresentException
with the specified detail message and cause. - horizontal() - Element in annotation interface io.github.mbenincasa.javaexcelutils.annotations.ExcelBodyStyle
- horizontal() - Element in annotation interface io.github.mbenincasa.javaexcelutils.annotations.ExcelHeaderStyle
- HORIZONTAL - Enum constant in enum class io.github.mbenincasa.javaexcelutils.model.parser.Direction
-
Horizontal direction
I
- io.github.mbenincasa.javaexcelutils.annotations - package io.github.mbenincasa.javaexcelutils.annotations
- io.github.mbenincasa.javaexcelutils.enums - package io.github.mbenincasa.javaexcelutils.enums
- io.github.mbenincasa.javaexcelutils.exceptions - package io.github.mbenincasa.javaexcelutils.exceptions
- io.github.mbenincasa.javaexcelutils.model.converter - package io.github.mbenincasa.javaexcelutils.model.converter
- io.github.mbenincasa.javaexcelutils.model.excel - package io.github.mbenincasa.javaexcelutils.model.excel
- io.github.mbenincasa.javaexcelutils.model.parser - package io.github.mbenincasa.javaexcelutils.model.parser
- io.github.mbenincasa.javaexcelutils.model.zip - package io.github.mbenincasa.javaexcelutils.model.zip
- io.github.mbenincasa.javaexcelutils.samples.convertCsvFileToExcelFile - package io.github.mbenincasa.javaexcelutils.samples.convertCsvFileToExcelFile
- io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToCsvFile - package io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToCsvFile
- io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToJsonFile - package io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToJsonFile
- io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToObjects - package io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToObjects
- io.github.mbenincasa.javaexcelutils.samples.convertJsonFileToExcelFile - package io.github.mbenincasa.javaexcelutils.samples.convertJsonFileToExcelFile
- io.github.mbenincasa.javaexcelutils.samples.convertObjectsToExcelFile - package io.github.mbenincasa.javaexcelutils.samples.convertObjectsToExcelFile
- io.github.mbenincasa.javaexcelutils.samples.parseSheetToExcel - package io.github.mbenincasa.javaexcelutils.samples.parseSheetToExcel
- io.github.mbenincasa.javaexcelutils.samples.writeExcelSample - package io.github.mbenincasa.javaexcelutils.samples.writeExcelSample
- io.github.mbenincasa.javaexcelutils.tools - package io.github.mbenincasa.javaexcelutils.tools
- isExcelExtension() - Method in enum class io.github.mbenincasa.javaexcelutils.enums.Extension
- isSheetNull(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Check if the sheet is not present
- isSheetNull(String) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Check if the sheet is not present
- isSheetPresent(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Check if the sheet is present
- isSheetPresent(String) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Check if the sheet is present
- isValidExcelExtension(String) - Static method in class io.github.mbenincasa.javaexcelutils.tools.ExcelUtility
-
Check if the extension is that of an Excel file
J
- JSON - Enum constant in enum class io.github.mbenincasa.javaexcelutils.enums.Extension
- JsonToExcel<T> - Class in io.github.mbenincasa.javaexcelutils.model.converter
-
This is a support class that is used by the
Converter
to perform conversions from Json to Excel - JsonToExcel() - Constructor for class io.github.mbenincasa.javaexcelutils.model.converter.JsonToExcel
- jsonToExcelByte(byte[], JsonToExcel<T>, Extension, Boolean) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- jsonToExcelFile(File, JsonToExcel<T>, Extension, String, Boolean) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- jsonToExcelStream(InputStream, JsonToExcel<T>, Extension, Boolean) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
M
- main(String[]) - Static method in class io.github.mbenincasa.javaexcelutils.samples.convertCsvFileToExcelFile.Main
- main(String[]) - Static method in class io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToCsvFile.Main
- main(String[]) - Static method in class io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToJsonFile.Main
- main(String[]) - Static method in class io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToObjects.Main
- main(String[]) - Static method in class io.github.mbenincasa.javaexcelutils.samples.convertJsonFileToExcelFile.Main
- main(String[]) - Static method in class io.github.mbenincasa.javaexcelutils.samples.convertObjectsToExcelFile.Main
- main(String[]) - Static method in class io.github.mbenincasa.javaexcelutils.samples.parseSheetToExcel.Main
- main(String[]) - Static method in class io.github.mbenincasa.javaexcelutils.samples.writeExcelSample.Main
- Main - Class in io.github.mbenincasa.javaexcelutils.samples.convertCsvFileToExcelFile
- Main - Class in io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToCsvFile
- Main - Class in io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToJsonFile
- Main - Class in io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToObjects
- Main - Class in io.github.mbenincasa.javaexcelutils.samples.convertJsonFileToExcelFile
- Main - Class in io.github.mbenincasa.javaexcelutils.samples.convertObjectsToExcelFile
- Main - Class in io.github.mbenincasa.javaexcelutils.samples.parseSheetToExcel
- Main - Class in io.github.mbenincasa.javaexcelutils.samples.writeExcelSample
- Main() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.convertCsvFileToExcelFile.Main
- Main() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToCsvFile.Main
- Main() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToJsonFile.Main
- Main() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToObjects.Main
- Main() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.convertJsonFileToExcelFile.Main
- Main() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.convertObjectsToExcelFile.Main
- Main() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.parseSheetToExcel.Main
- Main() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.writeExcelSample.Main
N
- name() - Element in annotation interface io.github.mbenincasa.javaexcelutils.annotations.ExcelField
O
- objectsToExcelByte(List<ObjectToExcel<?>>, Extension, Boolean) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- objectsToExcelFile(List<ObjectToExcel<?>>, Extension, String, Boolean) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- objectsToExcelStream(List<ObjectToExcel<?>>, Extension, Boolean) - Static method in class io.github.mbenincasa.javaexcelutils.tools.Converter
- ObjectToExcel<T> - Class in io.github.mbenincasa.javaexcelutils.model.converter
-
This is a helper class used by
Converter
to convert objects in an Excel Sheet - ObjectToExcel() - Constructor for class io.github.mbenincasa.javaexcelutils.model.converter.ObjectToExcel
- of(Cell) - Static method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelCell
-
Get to an ExcelCell instance from Apache POI Cell
- of(Row) - Static method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Get to an ExcelRow instance from Apache POI Row
- of(Sheet) - Static method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Get to an ExcelSheet instance from Apache POI Sheet
- of(Workbook) - Static method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Get to an ExcelWorkbook instance from Apache POI Workbook
- Office - Class in io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToObjects
- Office - Class in io.github.mbenincasa.javaexcelutils.samples.convertJsonFileToExcelFile
- Office - Class in io.github.mbenincasa.javaexcelutils.samples.convertObjectsToExcelFile
- Office() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.convertExcelFileToObjects.Office
- Office() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.convertJsonFileToExcelFile.Office
- Office() - Constructor for class io.github.mbenincasa.javaexcelutils.samples.convertObjectsToExcelFile.Office
- open(File) - Static method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Opens the workbook
- open(InputStream) - Static method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Opens the workbook
- OpenWorkbookException - Exception in io.github.mbenincasa.javaexcelutils.exceptions
-
This exception signals that an error occurred while opening an Excel file workbook
- OpenWorkbookException() - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.OpenWorkbookException
-
Constructs an
OpenWorkbookException
withnull
as its error detail message. - OpenWorkbookException(String) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.OpenWorkbookException
-
Constructs an
OpenWorkbookException
with the specified detail message. - OpenWorkbookException(String, Throwable) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.OpenWorkbookException
-
Constructs an
OpenWorkbookException
with the specified detail message and cause.
P
- parseToList(Class<T>, ExcelListParserMapping) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
- parseToObject(Class<T>, String) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
R
- readValue() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelCell
-
Read the value written inside the Cell
- readValue(Class<?>) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelCell
-
Read the value written inside the Cell
- readValueAsString() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelCell
-
Read the value written inside the Cell as String
- ReadValueException - Exception in io.github.mbenincasa.javaexcelutils.exceptions
-
This exception signals that there was an error reading a cell value
- ReadValueException() - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.ReadValueException
-
Constructs an
ReadValueException
withnull
as its error detail message. - ReadValueException(String) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.ReadValueException
-
Constructs an
ReadValueException
with the specified detail message. - ReadValueException(String, Throwable) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.ReadValueException
-
Constructs an
ReadValueException
with the specified detail message and cause. - readValues() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Reads the values of all cells in the row
- readValues(List<Class<?>>) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Reads the values of all cells in the row
- readValuesAsString() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Reads the values of all cells in the row as a String
- remove() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelCell
-
Remove the selected Cell
- remove() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Remove the selected Row
- remove() - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Remove the selected Sheet
- removeCell(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Removes a cell by index
- removeCells(String) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Method used to delete cells based on the selected range, for example: 'A1:B2'
- removeRow(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Removes a row by index
- removeSheet(Integer) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Remove the Sheet
- RowNotFoundException - Exception in io.github.mbenincasa.javaexcelutils.exceptions
-
This exception signals that the Excel row was not found
- RowNotFoundException() - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.RowNotFoundException
-
Constructs an
RowNotFoundException
withnull
as its error detail message. - RowNotFoundException(String) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.RowNotFoundException
-
Constructs an
RowNotFoundException
with the specified detail message. - RowNotFoundException(String, Throwable) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.RowNotFoundException
-
Constructs an
RowNotFoundException
with the specified detail message and cause.
S
- SheetAlreadyExistsException - Exception in io.github.mbenincasa.javaexcelutils.exceptions
-
This exception signals that you are trying to insert a sheet into a workbook that already contains that name
- SheetAlreadyExistsException() - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.SheetAlreadyExistsException
-
Constructs an
SheetAlreadyExistsException
withnull
as its error detail message. - SheetAlreadyExistsException(String) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.SheetAlreadyExistsException
-
Constructs an
SheetAlreadyExistsException
with the specified detail message. - SheetAlreadyExistsException(String, Throwable) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.SheetAlreadyExistsException
-
Constructs an
SheetAlreadyExistsException
with the specified detail message and cause. - SheetNotFoundException - Exception in io.github.mbenincasa.javaexcelutils.exceptions
-
This exception signals that the Excel sheet was not found
- SheetNotFoundException() - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.SheetNotFoundException
-
Constructs an
SheetNotFoundException
withnull
as its error detail message. - SheetNotFoundException(String) - Constructor for exception io.github.mbenincasa.javaexcelutils.exceptions.SheetNotFoundException
-
Constructs an
SheetNotFoundException
with the specified detail message.
V
- valueOf(String) - Static method in enum class io.github.mbenincasa.javaexcelutils.enums.Extension
-
Returns the enum constant of this class with the specified name.
- valueOf(String) - Static method in enum class io.github.mbenincasa.javaexcelutils.model.parser.Direction
-
Returns the enum constant of this class with the specified name.
- values() - Static method in enum class io.github.mbenincasa.javaexcelutils.enums.Extension
-
Returns an array containing the constants of this enum class, in the order they are declared.
- values() - Static method in enum class io.github.mbenincasa.javaexcelutils.model.parser.Direction
-
Returns an array containing the constants of this enum class, in the order they are declared.
- vertical() - Element in annotation interface io.github.mbenincasa.javaexcelutils.annotations.ExcelBodyStyle
- vertical() - Element in annotation interface io.github.mbenincasa.javaexcelutils.annotations.ExcelHeaderStyle
- VERTICAL - Enum constant in enum class io.github.mbenincasa.javaexcelutils.model.parser.Direction
-
Vertical direction
W
- writeAndClose(OutputStream) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelWorkbook
-
Writes the OutputStream to the Workbook and then closes them
- writeCells(String, Stream<Object[]>) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelSheet
-
Method that allows you to write a data matrix starting from a source cell
- writeValue(Object) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelCell
-
Writes inside the cell
- writeValues(List<?>) - Method in class io.github.mbenincasa.javaexcelutils.model.excel.ExcelRow
-
Write the values in the cells of the row
X
- XLS - Enum constant in enum class io.github.mbenincasa.javaexcelutils.enums.Extension
-
This extension is used for a Microsoft Office spreadsheet up to version 2003
- XLSX - Enum constant in enum class io.github.mbenincasa.javaexcelutils.enums.Extension
-
This extension is used for a Microsoft Office spreadsheet from version 2007 onwards
Z
- zipFiles(List<ZipModel>) - Static method in class io.github.mbenincasa.javaexcelutils.tools.ZipUtility
- ZipModel - Class in io.github.mbenincasa.javaexcelutils.model.zip
-
This is a model which contains the data of the file to be zipped which is used in
ZipUtility
- ZipModel() - Constructor for class io.github.mbenincasa.javaexcelutils.model.zip.ZipModel
- ZipUtility - Class in io.github.mbenincasa.javaexcelutils.tools
-
ZipUtility
is a static class that provides utility methods for zipped files - ZipUtility() - Constructor for class io.github.mbenincasa.javaexcelutils.tools.ZipUtility
All Classes and Interfaces|All Packages|Serialized Form