Index

A C D E F G H I J M N O P R S V W X Z 
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 with null 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 the Cell 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 the Row 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 the Sheet 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 the Workbook 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 with null 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 with null 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 with null 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 with null 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 with null 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 with null 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 with null 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
 
A C D E F G H I J M N O P R S V W X Z 
All Classes and Interfaces|All Packages|Serialized Form