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

A

addNamedRange(Range, String) - Method in class org.dhatim.fastexcel.Worksheet

Add the given range to this sheet's list of named ranges under the provided name.

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

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

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

whether blank cells should pass the validation

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

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

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

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

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

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

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

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

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

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

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

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

B

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

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

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

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

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

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

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.

bottomMargin(float) - Method in class org.dhatim.fastexcel.Worksheet

Set bottom margin.

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

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

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

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

C

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

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

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

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

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

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

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

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

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

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.

ConditionalFormatting - Class in org.dhatim.fastexcel

ConditionalFormattingExpressionRule - Class in org.dhatim.fastexcel

A ConditionalFormattingExpressionRule defines a conditional formatting rule for a worksheet of type = "expression"

ConditionalFormattingExpressionRule(String, boolean) - Constructor for class org.dhatim.fastexcel.ConditionalFormattingExpressionRule

Constructor

ConditionalFormattingRule - Class in org.dhatim.fastexcel

A ConditionalFormattingRule defines a base class of conditional formatting rule for a worksheet

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.

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

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

D

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

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

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

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

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

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

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

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

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'.

DifferentialFormat - Class in org.dhatim.fastexcel

E

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

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.

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

fitToHeight(Short) - Method in class org.dhatim.fastexcel.Worksheet

fitToWidth(Short) - Method in class org.dhatim.fastexcel.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.

footer(String, Position) - Method in class org.dhatim.fastexcel.Worksheet

Set footer text.

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

Set footer text with specified font size.

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

Set footer text with specified font and size.

footerMargin(float) - Method in class org.dhatim.fastexcel.Worksheet

Set footer margin.

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.

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

Set freeze pane (rows and columns that remain when scrolling).

G

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

Get cell range that autofilter is applied to.

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.

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

Get a list of named ranges.

getPos() - Method in enum org.dhatim.fastexcel.Position

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

Get repeating cols defined for the print setup.

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

Get repeating rows defined for the print setup.

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

Get right column.

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

Get top row.

getValueFormatting() - Method in class org.dhatim.fastexcel.DifferentialFormat

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.

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

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

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

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

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

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

H

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

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

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

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

Set header text.

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

Set header text with specified font size.

header(String, Position) - Method in class org.dhatim.fastexcel.Worksheet

Set header text with specified font and size.

headerMargin(float) - Method in class org.dhatim.fastexcel.Worksheet

Set header margin.

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

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

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

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

Use italic text.

K

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

Keep this sheet in active tab.

L

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

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

leftMargin(float) - Method in class org.dhatim.fastexcel.Worksheet

Set left margin.

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

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

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

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

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

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

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

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

ListDataValidation - Class in org.dhatim.fastexcel

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

M

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

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_ROW_HEIGHT - Static variable in class org.dhatim.fastexcel.Worksheet

Maximum row height in Excel.

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

Maximum number of rows in Excel.

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

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

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

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

Create a new worksheet in this workbook.

O

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

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

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

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

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

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

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

P

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

Set the page orientation.

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

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

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

PaperSize - Enum in org.dhatim.fastexcel

paperSize(PaperSize) - Method in class org.dhatim.fastexcel.Worksheet

Set the paper size.

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

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

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

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

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

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

Position - Enum in org.dhatim.fastexcel

Predefined header/footer positions.

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

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

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.

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

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

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

Removes auto filter from sheet.

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

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

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

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

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

rightMargin(float) - Method in class org.dhatim.fastexcel.Worksheet

Set right margin.

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

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

Specify the custom row height for a row

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

S

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

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

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

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

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

Apply style elements.

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

Apply style elements conditionally

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

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

Applies autofilter specifically to the given cell range

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

Applies autofilter automatically based on provided header cells

setAutoPageBreaks(Boolean) - Method in class org.dhatim.fastexcel.Worksheet

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

Sets the compression level of the xlsx.

setFitToPage(Boolean) - Method in class org.dhatim.fastexcel.Worksheet

setName(String) - Method in class org.dhatim.fastexcel.Range

Specifically define this range by assigning it a name.

setNumFmtId(int) - Method in class org.dhatim.fastexcel.DifferentialFormat

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

Sets the visibility state of the sheet

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

Set sheet view zoom level in percent.

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

Shade alternate rows.

shadeRows(String, int) - Method in class org.dhatim.fastexcel.StyleSetter

Shade Nth 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.

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

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

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

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

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

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

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.

topMargin(float) - Method in class org.dhatim.fastexcel.Worksheet

Set top margin.

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

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

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

U

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

Use underlined text.

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

Unfreeze any frozen rows, or columns.

V

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

Construct a new ListDataValidation

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

Set the cell value at the given coordinates.

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

Set the cell value at the given coordinates.

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

Set the cell value at the given coordinates.

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

Set the cell value at the given coordinates.

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

Set the cell value at the given coordinates.

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

Set the cell value at the given coordinates.

value(int, int, ZonedDateTime) - 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.PaperSize

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

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

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.PaperSize

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

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

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.

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

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

Define vertical alignment.

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

VisibilityState - Enum in org.dhatim.fastexcel

This simple type defines the possible states for sheet visibility.

W

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

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.ConditionalFormattingExpressionRule

Write this conditionalFormatting as an XML element.

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

Write this dataValidation as an XML element.

Y

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

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