A B C D E F G H I L M N O P R S T U V W

A

allowBlank(boolean) - Method in class org.dhatim.fastexcel.ListDataValidation

whether blank cells should pass the validation

B

bold() - Method in class org.dhatim.fastexcel.StyleSetter

Use bold text.

borderColor(String) - Method in class org.dhatim.fastexcel.StyleSetter

Set cell border color.

borderColor(BorderSide, String) - Method in class org.dhatim.fastexcel.StyleSetter

Set cell border color.

BorderSide - Enum in org.dhatim.fastexcel

Identifies border sides of a cell.

BorderStyle - Enum in org.dhatim.fastexcel

borderStyle(BorderStyle) - Method in class org.dhatim.fastexcel.StyleSetter

Apply cell border style on all sides, except diagonal.

borderStyle(String) - Method in class org.dhatim.fastexcel.StyleSetter

Apply cell border style on all sides, except diagonal.

borderStyle(BorderSide, BorderStyle) - Method in class org.dhatim.fastexcel.StyleSetter

Apply cell border style on a side.

borderStyle(BorderSide, String) - Method in class org.dhatim.fastexcel.StyleSetter

Apply cell border style on a side.

C

Color - Class in org.dhatim.fastexcel

Predefined RGB colors.

colToString(int) - Static method in class org.dhatim.fastexcel.Range

Convert a column index to a column name.

comment(int, int, String) - Method in class org.dhatim.fastexcel.Worksheet

Assign a note/comment to a cell.

contains(int, int) - Method in class org.dhatim.fastexcel.Range

Check if this range contains the given cell coordinates.

convertDate(Date) - Static method in class org.dhatim.fastexcel.TimestampUtil

Convert a Date to a serial number.

convertDate(LocalDate) - Static method in class org.dhatim.fastexcel.TimestampUtil

Convert a LocalDate to a serial number.

convertZonedDateTime(ChronoZonedDateTime<?>) - Static method in class org.dhatim.fastexcel.TimestampUtil

Convert a ChronoZonedDateTime to a serial number.

D

DataValidationErrorStyle - Enum in org.dhatim.fastexcel

DEFAULT_OPTIONS - Static variable in enum org.dhatim.fastexcel.SheetProtectionOption

The options that are true by default AND 'sheet'.

E

equals(Object) - Method in class org.dhatim.fastexcel.Protection

equals(Object) - Method in class org.dhatim.fastexcel.Range

error(String) - Method in class org.dhatim.fastexcel.ListDataValidation

Message text of error alert.

errorStyle(DataValidationErrorStyle) - Method in class org.dhatim.fastexcel.ListDataValidation

The style of error alert used for this data validation.

errorTitle(String) - Method in class org.dhatim.fastexcel.ListDataValidation

Title bar text of error alert.

F

fillColor(String) - Method in class org.dhatim.fastexcel.StyleSetter

Set fill color.

finish() - Method in class org.dhatim.fastexcel.Workbook

Complete workbook generation: this writes worksheets and additional files as zip entries to the output stream.

finish() - Method in class org.dhatim.fastexcel.Worksheet

Finish the construction of this worksheet.

flush() - Method in class org.dhatim.fastexcel.Worksheet

Write all the rows currently in memory to the workbook's output stream.

fontColor(String) - Method in class org.dhatim.fastexcel.StyleSetter

Set font color.

fontName(String) - Method in class org.dhatim.fastexcel.StyleSetter

Set font name.

fontSize(BigDecimal) - Method in class org.dhatim.fastexcel.StyleSetter

Set font size.

fontSize(int) - Method in class org.dhatim.fastexcel.StyleSetter

Set font size.

format(String) - Method in class org.dhatim.fastexcel.StyleSetter

Set numbering format.

formula(int, int, String) - Method in class org.dhatim.fastexcel.Worksheet

Set the cell formula at the given coordinates.

G

getBottom() - Method in class org.dhatim.fastexcel.Range

Get bottom row.

getDefaultValue() - Method in enum org.dhatim.fastexcel.SheetProtectionOption

getLeft() - Method in class org.dhatim.fastexcel.Range

Get left column.

getName() - Method in enum org.dhatim.fastexcel.ProtectionOption

getName() - Method in enum org.dhatim.fastexcel.SheetProtectionOption

getName() - Method in enum org.dhatim.fastexcel.VisibilityState

getName() - Method in class org.dhatim.fastexcel.Worksheet

Get worksheet name.

getRight() - Method in class org.dhatim.fastexcel.Range

Get right column.

getTop() - Method in class org.dhatim.fastexcel.Range

Get top row.

getVisibilityState() - Method in class org.dhatim.fastexcel.Worksheet

getWorkbook() - Method in class org.dhatim.fastexcel.Worksheet

Get parent workbook.

getWorksheet() - Method in class org.dhatim.fastexcel.Range

Get parent worksheet.

GRAY1 - Static variable in class org.dhatim.fastexcel.Color

Light gray.

GRAY10 - Static variable in class org.dhatim.fastexcel.Color

Dark gray.

GRAY2 - Static variable in class org.dhatim.fastexcel.Color

GRAY3 - Static variable in class org.dhatim.fastexcel.Color

GRAY4 - Static variable in class org.dhatim.fastexcel.Color

GRAY5 - Static variable in class org.dhatim.fastexcel.Color

GRAY6 - Static variable in class org.dhatim.fastexcel.Color

GRAY7 - Static variable in class org.dhatim.fastexcel.Color

GRAY8 - Static variable in class org.dhatim.fastexcel.Color

GRAY9 - Static variable in class org.dhatim.fastexcel.Color

H

hashCode() - Method in class org.dhatim.fastexcel.Protection

hashCode() - Method in class org.dhatim.fastexcel.Range

hideColumn(int) - Method in class org.dhatim.fastexcel.Worksheet

Hide the given column.

hideGridLines() - Method in class org.dhatim.fastexcel.Worksheet

Hide grid lines

hideRow(int) - Method in class org.dhatim.fastexcel.Worksheet

Hide the given row.

horizontalAlignment(String) - Method in class org.dhatim.fastexcel.StyleSetter

Define horizontal alignment.

I

italic() - Method in class org.dhatim.fastexcel.StyleSetter

Use italic text.

L

ListDataValidation - Class in org.dhatim.fastexcel

A ListDataValidation defines a DataValidation for a worksheet of type = "list"

M

MAX_COL_WIDTH - Static variable in class org.dhatim.fastexcel.Worksheet

Maximum column width in Excel.

MAX_COLS - Static variable in class org.dhatim.fastexcel.Worksheet

Maximum number of columns in Excel.

MAX_ROWS - Static variable in class org.dhatim.fastexcel.Worksheet

Maximum number of rows in Excel.

merge() - Method in class org.dhatim.fastexcel.Range

Merge cells within this range.

merge() - Method in class org.dhatim.fastexcel.StyleSetter

Merge cells in this style setter's range.

N

newWorksheet(String) - Method in class org.dhatim.fastexcel.Workbook

Create a new worksheet in this workbook.

O

org.dhatim.fastexcel - package org.dhatim.fastexcel

P

protect(String) - Method in class org.dhatim.fastexcel.Worksheet

Protects the sheet with a password.

protect(String, SheetProtectionOption...) - Method in class org.dhatim.fastexcel.Worksheet

Protects the sheet with a password.

protect(String, Set<SheetProtectionOption>) - Method in class org.dhatim.fastexcel.Worksheet

Protects the sheet with a password.

Protection - Class in org.dhatim.fastexcel

Represents the <protection> xml-tag.

Protection(Map<ProtectionOption, Boolean>) - Constructor for class org.dhatim.fastexcel.Protection

ProtectionOption - Enum in org.dhatim.fastexcel

Represents an attribute on the <protection> xml-tag.

protectionOption(ProtectionOption, Boolean) - Method in class org.dhatim.fastexcel.StyleSetter

Sets the value for a protection option.

R

Range - Class in org.dhatim.fastexcel

Definition of a range of cells.

range(int, int, int, int) - Method in class org.dhatim.fastexcel.Worksheet

Create a new range of cells.

RED - Static variable in class org.dhatim.fastexcel.Color

removeAutoFilter() - Method in class org.dhatim.fastexcel.Worksheet

Removes auto filter from sheet.

S

set() - Method in class org.dhatim.fastexcel.StyleSetter

Apply style elements.

setAutoFilter(int, int, int) - Method in class org.dhatim.fastexcel.Worksheet

Adds filter to row

setCompressionLevel(int) - Method in class org.dhatim.fastexcel.Workbook

Sets the compression level of the xlsx.

setVisibilityState(VisibilityState) - Method in class org.dhatim.fastexcel.Worksheet

Sets the visibility state of the sheet

shadeAlternateRows(String) - Method in class org.dhatim.fastexcel.StyleSetter

Shade alternate rows.

SheetProtectionOption - Enum in org.dhatim.fastexcel

Represents an attribute on the <sheetProtection> xml-tag.

showColumn(int) - Method in class org.dhatim.fastexcel.Worksheet

Show the given column.

showDropdown(boolean) - Method in class org.dhatim.fastexcel.ListDataValidation

Whether Excel will show an in-cell dropdown list containing the validation list

showErrorMessage(boolean) - Method in class org.dhatim.fastexcel.ListDataValidation

Whether to display the error alert message when an invalid value has been entered.

showRow(int) - Method in class org.dhatim.fastexcel.Worksheet

Show the given row.

sortWorksheets(Comparator<Worksheet>) - Method in class org.dhatim.fastexcel.Workbook

Sort the current worksheets with the given Comparator

style() - Method in class org.dhatim.fastexcel.Range

Get a new style setter for this range.

style(int, int) - Method in class org.dhatim.fastexcel.Worksheet

Get a new style setter for a cell.

StyleSetter - Class in org.dhatim.fastexcel

Helper class to set style elements on a cell or range of cells.

T

TimestampUtil - Class in org.dhatim.fastexcel

Excel timestamp utility methods.

toAbsoluteString() - Method in class org.dhatim.fastexcel.Range

Get an absolute reference to this Range.

toString() - Method in enum org.dhatim.fastexcel.DataValidationErrorStyle

toString() - Method in class org.dhatim.fastexcel.Range

U

underlined() - Method in class org.dhatim.fastexcel.StyleSetter

Use underlined text.

V

validateWithList(Range) - Method in class org.dhatim.fastexcel.Range

Construct a new ListDataValidation

value(int, int, Object) - Method in class org.dhatim.fastexcel.Worksheet

Set the cell value at the given coordinates.

value(int, int) - Method in class org.dhatim.fastexcel.Worksheet

Get the cell value (or formula) at the given coordinates.

valueOf(String) - Static method in enum org.dhatim.fastexcel.BorderSide

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.dhatim.fastexcel.BorderStyle

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.dhatim.fastexcel.DataValidationErrorStyle

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.dhatim.fastexcel.ProtectionOption

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.dhatim.fastexcel.SheetProtectionOption

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.dhatim.fastexcel.VisibilityState

Returns the enum constant of this type with the specified name.

values() - Static method in enum org.dhatim.fastexcel.BorderSide

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.dhatim.fastexcel.BorderStyle

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.dhatim.fastexcel.DataValidationErrorStyle

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.dhatim.fastexcel.ProtectionOption

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.dhatim.fastexcel.SheetProtectionOption

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.dhatim.fastexcel.VisibilityState

Returns an array containing the constants of this enum type, in the order they are declared.

verticalAlignment(String) - Method in class org.dhatim.fastexcel.StyleSetter

Define vertical alignment.

VisibilityState - Enum in org.dhatim.fastexcel

This simple type defines the possible states for sheet visibility.

W

width(int, double) - Method in class org.dhatim.fastexcel.Worksheet

Specify the width for the given column.

Workbook - Class in org.dhatim.fastexcel

A Workbook contains one or more Worksheet objects.

Workbook(OutputStream, String, String) - Constructor for class org.dhatim.fastexcel.Workbook

Constructor.

Worksheet - Class in org.dhatim.fastexcel

A worksheet is a set of cells.

wrapText(boolean) - Method in class org.dhatim.fastexcel.StyleSetter

Enable or disable text wrapping in cells.

write(Writer) - Method in class org.dhatim.fastexcel.ListDataValidation

Write this dataValidation as an XML element.

A B C D E F G H I L M N O P R S T U V W