Index (Fastexcel Writer 0.19.0 API)

A B C D E F G H I J K L M N O P Q R S T U V W X Y
All Classes All Packages

A

A2_PAPER - org.dhatim.fastexcel.PaperSize
A3_EXTRA_PAPER - org.dhatim.fastexcel.PaperSize
A3_EXTRA_TRANSVERSE_PAPER - org.dhatim.fastexcel.PaperSize
A3_PAPER - org.dhatim.fastexcel.PaperSize
A3_TRANSVERSE_PAPER - org.dhatim.fastexcel.PaperSize
A4_EXTRA_PAPER - org.dhatim.fastexcel.PaperSize
A4_PAPER - org.dhatim.fastexcel.PaperSize
A4_PLUS_PAPER - org.dhatim.fastexcel.PaperSize
A4_SMALL_PAPER - org.dhatim.fastexcel.PaperSize
A4_TRANSVERSE_PAPER - org.dhatim.fastexcel.PaperSize
A5_EXTRA_PAPER - org.dhatim.fastexcel.PaperSize
A5_PAPER - org.dhatim.fastexcel.PaperSize
A5_TRANSVERSE_PAPER - org.dhatim.fastexcel.PaperSize
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.CustomDataValidation: whether blank cells should pass the validation
allowBlank(boolean) - Method in class org.dhatim.fastexcel.ListDataValidation: whether blank cells should pass the validation
allowBlank(boolean) - Method in class org.dhatim.fastexcel.ListFormulaDataValidation: 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
AUTO_FILTER - org.dhatim.fastexcel.SheetProtectionOption: Autofilters are locked when the sheet is protected.
AZURE - Static variable in class org.dhatim.fastexcel.Color

B

B4 - org.dhatim.fastexcel.PaperSize
B4_ENVELOPE - org.dhatim.fastexcel.PaperSize
B4_PAPER - org.dhatim.fastexcel.PaperSize
B5_ENVELOPE - org.dhatim.fastexcel.PaperSize
B5_EXTRA_PAPER - org.dhatim.fastexcel.PaperSize
B5_PAPER - org.dhatim.fastexcel.PaperSize
B6_ENVELOPE - org.dhatim.fastexcel.PaperSize
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
BitMatrix - Class in org.dhatim.fastexcel: Represents a 2D matrix of bits.
BitMatrix(int) - Constructor for class org.dhatim.fastexcel.BitMatrix: Creates an empty square BitMatrix.
BitMatrix(int, int) - Constructor for class org.dhatim.fastexcel.BitMatrix: Creates an empty BitMatrix.
BLACK - Static variable in class org.dhatim.fastexcel.Color
BLUE_GRAY - Static variable in class org.dhatim.fastexcel.Color
BorderSide - Enum in org.dhatim.fastexcel: Identifies border sides of a cell.
BorderStyle - Enum in org.dhatim.fastexcel
BOTTOM - org.dhatim.fastexcel.BorderSide
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
buildToString(String) - Method in class org.dhatim.fastexcel.DynamicByteArray
buildToString(String, String, String, String) - Method in class org.dhatim.fastexcel.DynamicBitMatrix
BURGUNDY - Static variable in class org.dhatim.fastexcel.Color

C

C_PAPER - org.dhatim.fastexcel.PaperSize
C3_ENVELOPE - org.dhatim.fastexcel.PaperSize
C4_ENVELOPE - org.dhatim.fastexcel.PaperSize
C5_ENVELOPE - org.dhatim.fastexcel.PaperSize
C6_ENVELOPE - org.dhatim.fastexcel.PaperSize
C65_ENVELOPE - org.dhatim.fastexcel.PaperSize
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
CENTER - org.dhatim.fastexcel.Position
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
clear() - Method in class org.dhatim.fastexcel.BitMatrix: Clears all bits (sets to false).
clone() - Method in class org.dhatim.fastexcel.BitMatrix
close() - Method in class org.dhatim.fastexcel.Workbook
close() - Method in class org.dhatim.fastexcel.Worksheet
Color - Class in org.dhatim.fastexcel: Predefined RGB colors.
colToString(int) - Method in interface org.dhatim.fastexcel.Ref
ColumnStyleSetter - Class in org.dhatim.fastexcel: Helper class to set style elements on a column.
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(LocalDate) - Static method in class org.dhatim.fastexcel.TimestampUtil: Convert a LocalDate to a serial number.
convertDate(LocalDateTime) - Static method in class org.dhatim.fastexcel.TimestampUtil
convertDate(Date) - Static method in class org.dhatim.fastexcel.TimestampUtil: Convert a Date to a serial number.
convertZonedDateTime(ZonedDateTime) - 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
createTable() - Method in class org.dhatim.fastexcel.Range
createTable(String...) - Method in class org.dhatim.fastexcel.Range
CustomDataValidation - Class in org.dhatim.fastexcel: A CustomDataValidation defines a DataValidation for a worksheet of type = "custom"

D

D_PAPER - org.dhatim.fastexcel.PaperSize
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
DASH_DOT - org.dhatim.fastexcel.BorderStyle
DASH_DOT_DOT - org.dhatim.fastexcel.BorderStyle
DASHED - org.dhatim.fastexcel.BorderStyle
DataValidationErrorStyle - Enum in org.dhatim.fastexcel
DAY_MILLISECONDS - Static variable in class org.dhatim.fastexcel.TimestampUtil
DEFAULT_COL_WIDTH - Static variable in class org.dhatim.fastexcel.Worksheet: Default column width in Excel.
DEFAULT_OPTIONS - Static variable in enum org.dhatim.fastexcel.SheetProtectionOption: The options that are true by default AND 'sheet'.
DELETE_COLUMNS - org.dhatim.fastexcel.SheetProtectionOption: Deleting columns is locked when the sheet is protected.
DELETE_ROWS - org.dhatim.fastexcel.SheetProtectionOption: Deleting rows is locked when the sheet is protected.
DIAGONAL - org.dhatim.fastexcel.BorderSide
DIAGONAL_DOWN - org.dhatim.fastexcel.DiagonalProperty
DIAGONAL_UP - org.dhatim.fastexcel.DiagonalProperty
DiagonalProperty - Enum in org.dhatim.fastexcel: Identifies diagonal border of a cell.
DifferentialFormat - Class in org.dhatim.fastexcel
DL_ENVELOPE - org.dhatim.fastexcel.PaperSize
DOTTED - org.dhatim.fastexcel.BorderStyle
DOUBLE - org.dhatim.fastexcel.BorderStyle
DynamicBitMatrix - Class in org.dhatim.fastexcel: This is a dynamically expanding matrix structure that saves space and has good performance
DynamicBitMatrix(int, int) - Constructor for class org.dhatim.fastexcel.DynamicBitMatrix
DynamicByteArray - Class in org.dhatim.fastexcel
DynamicByteArray(int) - Constructor for class org.dhatim.fastexcel.DynamicByteArray

E

E_PAPER - org.dhatim.fastexcel.PaperSize
equals(Object) - Method in class org.dhatim.fastexcel.BitMatrix
equals(Object) - Method in class org.dhatim.fastexcel.DifferentialFormat
equals(Object) - Method in class org.dhatim.fastexcel.HyperLink
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.CustomDataValidation: Message text of error alert.
error(String) - Method in class org.dhatim.fastexcel.ListDataValidation: Message text of error alert.
error(String) - Method in class org.dhatim.fastexcel.ListFormulaDataValidation: Message text of error alert.
errorStyle(DataValidationErrorStyle) - Method in class org.dhatim.fastexcel.CustomDataValidation: The style of error alert used for this data validation.
errorStyle(DataValidationErrorStyle) - Method in class org.dhatim.fastexcel.ListDataValidation: The style of error alert used for this data validation.
errorStyle(DataValidationErrorStyle) - Method in class org.dhatim.fastexcel.ListFormulaDataValidation: The style of error alert used for this data validation.
errorTitle(String) - Method in class org.dhatim.fastexcel.CustomDataValidation: Title bar text of error alert.
errorTitle(String) - Method in class org.dhatim.fastexcel.ListDataValidation: Title bar text of error alert.
errorTitle(String) - Method in class org.dhatim.fastexcel.ListFormulaDataValidation: Title bar text of error alert.
escape(String) - Static method in class org.dhatim.fastexcel.XmlEscapeHelper: Apply XML escaping to a String.
EXECUTIVE_PAPER - org.dhatim.fastexcel.PaperSize
external(String, String) - Static method in class org.dhatim.fastexcel.HyperLink: Static factory method which allows to create external HyperLink

F

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
flip() - Method in class org.dhatim.fastexcel.BitMatrix: Flips every bit in the matrix.
flip(int, int) - Method in class org.dhatim.fastexcel.BitMatrix: Flips the given bit.
flush() - Method in class org.dhatim.fastexcel.Worksheet: Write all the rows currently in memory to the workbook's output stream.
FOLIO_PAPER - org.dhatim.fastexcel.PaperSize
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_CELLS - org.dhatim.fastexcel.SheetProtectionOption: Formatting cells is locked when the sheet is protected.
FORMAT_COLUMNS - org.dhatim.fastexcel.SheetProtectionOption: Formatting columns is locked when the sheet is protected.
FORMAT_ROWS - org.dhatim.fastexcel.SheetProtectionOption: Formatting rows is locked when the sheet is protected.
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

GERMAN_LEGAL_FANFOLD - org.dhatim.fastexcel.PaperSize
GERMAN_STANDARD_FANFOLD - org.dhatim.fastexcel.PaperSize
get(int, int) - Method in class org.dhatim.fastexcel.BitMatrix: Gets the requested bit, where true means black.
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.
getContent() - Method in class org.dhatim.fastexcel.MarginalInformation
getDefaultValue() - Method in enum org.dhatim.fastexcel.SheetProtectionOption
getDisplayStr() - Method in class org.dhatim.fastexcel.HyperLink
getHeight() - Method in class org.dhatim.fastexcel.BitMatrix
getLeft() - Method in class org.dhatim.fastexcel.Range: Get left column.
getLinkStr() - Method in class org.dhatim.fastexcel.HyperLink
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.
getRowSize() - Method in class org.dhatim.fastexcel.BitMatrix
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
getWidth() - Method in class org.dhatim.fastexcel.BitMatrix
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
groupCols(int, int) - Method in class org.dhatim.fastexcel.Worksheet
groupRows(int, int) - Method in class org.dhatim.fastexcel.Worksheet

H

HAIR - org.dhatim.fastexcel.BorderStyle
hasCustomProperties() - Method in class org.dhatim.fastexcel.Properties
hashCode() - Method in class org.dhatim.fastexcel.BitMatrix
hashCode() - Method in class org.dhatim.fastexcel.DifferentialFormat
hashCode() - Method in class org.dhatim.fastexcel.HyperLink
hashCode() - Method in class org.dhatim.fastexcel.Protection
hashCode() - Method in class org.dhatim.fastexcel.Range
header(String, Position) - Method in class org.dhatim.fastexcel.Worksheet: Set header text with specified font and size.
header(String, Position, int) - Method in class org.dhatim.fastexcel.Worksheet: Set header text with specified font size.
header(String, Position, String, int) - Method in class org.dhatim.fastexcel.Worksheet: Set header text.
headerMargin(float) - Method in class org.dhatim.fastexcel.Worksheet: Set header margin.
HIDDEN - org.dhatim.fastexcel.ProtectionOption: A boolean value indicating if the cell is hidden.
HIDDEN - org.dhatim.fastexcel.VisibilityState: Indicates the book window is hidden, but can be shown by the user via the user interface.
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.
HOURS_PER_DAY - Static variable in class org.dhatim.fastexcel.TimestampUtil
hyperlink(int, int, HyperLink) - Method in class org.dhatim.fastexcel.Worksheet
HyperLink - Class in org.dhatim.fastexcel
HyperLink(String) - Constructor for class org.dhatim.fastexcel.HyperLink
HyperLink(String, String) - Constructor for class org.dhatim.fastexcel.HyperLink: Default Constructor By default, the HyperLink will be marked as an external

I

INDIAN_RED - Static variable in class org.dhatim.fastexcel.Color
INDIGO - Static variable in class org.dhatim.fastexcel.Color
INFORMATION - org.dhatim.fastexcel.DataValidationErrorStyle
inlineString(int, int, String) - Method in class org.dhatim.fastexcel.Worksheet: Set the cell value at the given coordinates.
INSERT_COLUMNS - org.dhatim.fastexcel.SheetProtectionOption: Inserting columns is locked when the sheet is protected.
INSERT_HYPERLINKS - org.dhatim.fastexcel.SheetProtectionOption: Inserting hyperlinks is locked when the sheet is protected.
INSERT_ROWS - org.dhatim.fastexcel.SheetProtectionOption: Inserting rows is locked when the sheet is protected.
internal(String, String) - Static method in class org.dhatim.fastexcel.HyperLink: Static factory method which allows to create internal HyperLink
INVITE_ENVELOPE - org.dhatim.fastexcel.PaperSize
isFolderScope() - Method in class org.dhatim.fastexcel.Range: Check if this range has a folder scope.
ITALY_ENVELOPE - org.dhatim.fastexcel.PaperSize

J

JAPANESE_DOUBLE_POSTCARD - org.dhatim.fastexcel.PaperSize
JIS_B5_TRANSVERSE_PAPER - org.dhatim.fastexcel.PaperSize

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
LEDGER_PAPER - org.dhatim.fastexcel.PaperSize
LEFT - org.dhatim.fastexcel.BorderSide
LEFT - org.dhatim.fastexcel.Position
leftMargin(float) - Method in class org.dhatim.fastexcel.Worksheet: Set left margin.
LEGAL_EXTRA_PAPER - org.dhatim.fastexcel.PaperSize
LEGAL_PAPER - org.dhatim.fastexcel.PaperSize
LEMON_CHIFFON - Static variable in class org.dhatim.fastexcel.Color
LETTER_EXTRA_PAPER - org.dhatim.fastexcel.PaperSize
LETTER_EXTRA_TRANSVERSE_PAPER - org.dhatim.fastexcel.PaperSize
LETTER_PAPER - org.dhatim.fastexcel.PaperSize
LETTER_PLUS_PAPER - org.dhatim.fastexcel.PaperSize
LETTER_SMALL_PAPER - org.dhatim.fastexcel.PaperSize
LETTER_TRANSVERSE_PAPER - org.dhatim.fastexcel.PaperSize
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"
ListFormulaDataValidation - Class in org.dhatim.fastexcel: A ListDataValidation defines a DataValidation for a worksheet of type = "list"
LOCKED - org.dhatim.fastexcel.ProtectionOption: A boolean value indicating if the cell is locked.

M

MarginalInformation - Class in org.dhatim.fastexcel: Marginal Information, represents a header or footer in an Excel file.
MarginalInformation(String, Position) - Constructor for class org.dhatim.fastexcel.MarginalInformation
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 - org.dhatim.fastexcel.BorderStyle
MEDIUM_DASH_DOT - org.dhatim.fastexcel.BorderStyle
MEDIUM_DASH_DOT_DOT - org.dhatim.fastexcel.BorderStyle
MEDIUM_DASHED - org.dhatim.fastexcel.BorderStyle
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.
MINUTES_PER_HOUR - Static variable in class org.dhatim.fastexcel.TimestampUtil
MONARCH_ENVELOPE - org.dhatim.fastexcel.PaperSize

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.
NONE - org.dhatim.fastexcel.BorderStyle
NOTE_PAPER - org.dhatim.fastexcel.PaperSize
NUM10_ENVELOPE - org.dhatim.fastexcel.PaperSize
NUM11_ENVELOPE - org.dhatim.fastexcel.PaperSize
NUM12_ENVELOPE - org.dhatim.fastexcel.PaperSize
NUM14_ENVELOPE - org.dhatim.fastexcel.PaperSize
NUM6_3_4_ENVELOPE - org.dhatim.fastexcel.PaperSize
NUM9_ENVELOPE - org.dhatim.fastexcel.PaperSize

O

OBJECTS - org.dhatim.fastexcel.SheetProtectionOption: Objects are locked when the sheet is protected.
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 - module org.dhatim.fastexcel
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(PaperSize) - Method in class org.dhatim.fastexcel.Worksheet: Set the paper size.
PaperSize - Enum in org.dhatim.fastexcel: PaperSize.
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
PIVOT_TABLES - org.dhatim.fastexcel.SheetProtectionOption: Pivot tables are locked when the sheet is protected.
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
properties() - Method in class org.dhatim.fastexcel.Workbook
Properties - Class in org.dhatim.fastexcel
Properties() - Constructor for class org.dhatim.fastexcel.Properties
protect(String) - 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.
protect(String, 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.

Q

QUARTO_PAPER - org.dhatim.fastexcel.PaperSize

R

range(int, int, int, int) - Method in class org.dhatim.fastexcel.Worksheet: Create a new range of cells.
Range - Class in org.dhatim.fastexcel: Definition of a range of cells.
RASPBERRY - Static variable in class org.dhatim.fastexcel.Color
RED - Static variable in class org.dhatim.fastexcel.Color
Ref - Interface in org.dhatim.fastexcel
Relationships - Class in org.dhatim.fastexcel
Relationships(Worksheet) - Constructor for class org.dhatim.fastexcel.Relationships
removeAutoFilter() - Method in class org.dhatim.fastexcel.Worksheet: Removes auto filter from sheet.
repeatCols(int) - Method in class org.dhatim.fastexcel.Worksheet
repeatCols(int, int) - Method in class org.dhatim.fastexcel.Worksheet
repeatRows(int) - Method in class org.dhatim.fastexcel.Worksheet
repeatRows(int, int) - Method in class org.dhatim.fastexcel.Worksheet
RICH_LILAC - Static variable in class org.dhatim.fastexcel.Color
RIGHT - org.dhatim.fastexcel.BorderSide
RIGHT - org.dhatim.fastexcel.Position
rightMargin(float) - Method in class org.dhatim.fastexcel.Worksheet: Set right margin.
rightToLeft() - Method in class org.dhatim.fastexcel.Worksheet: Display the worksheet from right to left
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
rowSumsBelow(boolean) - Method in class org.dhatim.fastexcel.Worksheet
rowSumsRight(boolean) - Method in class org.dhatim.fastexcel.Worksheet
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
SCENARIOS - org.dhatim.fastexcel.SheetProtectionOption: Scenarios are locked when the sheet is protected.
SEA_BLUE - Static variable in class org.dhatim.fastexcel.Color
SEA_GREEN - Static variable in class org.dhatim.fastexcel.Color
SECONDS_PER_DAY - Static variable in class org.dhatim.fastexcel.TimestampUtil
SECONDS_PER_MINUTE - Static variable in class org.dhatim.fastexcel.TimestampUtil
SELECT_LOCKED_CELLS - org.dhatim.fastexcel.SheetProtectionOption: Selection of locked cells is locked when the sheet is protected.
SELECT_UNLOCKED_CELLS - org.dhatim.fastexcel.SheetProtectionOption: Selection of unlocked cells is locked when the sheet is protected.
set() - Method in class org.dhatim.fastexcel.ColumnStyleSetter: Apply style elements.
set() - Method in class org.dhatim.fastexcel.StyleSetter: Apply style elements.
set(int, int) - Method in class org.dhatim.fastexcel.BitMatrix: Sets the given bit to true.
setActiveTab(int) - Method in class org.dhatim.fastexcel.Workbook
setAutoFilter(int, int, int) - Method in class org.dhatim.fastexcel.Worksheet: Applies autofilter automatically based on provided header cells
setAutoFilter(int, int, int, int) - Method in class org.dhatim.fastexcel.Worksheet: Applies autofilter specifically to the given cell range
setAutoPageBreaks(Boolean) - Method in class org.dhatim.fastexcel.Worksheet
setBoolProperty(String, Boolean) - Method in class org.dhatim.fastexcel.Properties
setCategory(String) - Method in class org.dhatim.fastexcel.Properties
setCompany(String) - Method in class org.dhatim.fastexcel.Properties
setCompressionLevel(int) - Method in class org.dhatim.fastexcel.Workbook: Sets the compression level of the xlsx.
setDateProperty(String, Instant) - Method in class org.dhatim.fastexcel.Properties
setDescription(String) - Method in class org.dhatim.fastexcel.Properties
setDisplayName(String) - Method in class org.dhatim.fastexcel.Table
setFitToPage(Boolean) - Method in class org.dhatim.fastexcel.Worksheet
setFolderScope(boolean) - Method in class org.dhatim.fastexcel.Range: Set the visibility of this range
setGlobalDefaultFont(String, double) - Method in class org.dhatim.fastexcel.Workbook
setGlobalDefaultFont(Font) - Method in class org.dhatim.fastexcel.Workbook
setHyperlink(HyperLink) - Method in class org.dhatim.fastexcel.Range
setHyperlinkBase(String) - Method in class org.dhatim.fastexcel.Properties
setKeywords(String) - Method in class org.dhatim.fastexcel.Properties
setManager(String) - Method in class org.dhatim.fastexcel.Properties
setName(String) - Method in class org.dhatim.fastexcel.Range: Specifically define this range by assigning it a name.
setName(String) - Method in class org.dhatim.fastexcel.Table
setNumberProperty(String, BigDecimal) - Method in class org.dhatim.fastexcel.Properties
setNumFmtId(int) - Method in class org.dhatim.fastexcel.DifferentialFormat
setRegion(int, int, int, int) - Method in class org.dhatim.fastexcel.BitMatrix: Sets a square region of the bit matrix to true.
setShowColumnStripes(boolean) - Method in class org.dhatim.fastexcel.Table.TableStyleInfo
setShowFirstColumn(boolean) - Method in class org.dhatim.fastexcel.Table.TableStyleInfo
setShowLastColumn(boolean) - Method in class org.dhatim.fastexcel.Table.TableStyleInfo
setShowRowStripes(boolean) - Method in class org.dhatim.fastexcel.Table.TableStyleInfo
setStyleName(String) - Method in class org.dhatim.fastexcel.Table.TableStyleInfo
setSubject(String) - Method in class org.dhatim.fastexcel.Properties
setTabColor(String) - Method in class org.dhatim.fastexcel.Worksheet
setTextProperty(String, String) - Method in class org.dhatim.fastexcel.Properties
setTitle(String) - Method in class org.dhatim.fastexcel.Properties
setTotalsRowShown(boolean) - Method in class org.dhatim.fastexcel.Table
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.
SHEET - org.dhatim.fastexcel.SheetProtectionOption: Sheet is locked when the sheet is protected.
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.CustomDataValidation: Whether Excel will show an in-cell dropdown list containing the validation list
showDropdown(boolean) - Method in class org.dhatim.fastexcel.ListDataValidation: Whether Excel will show an in-cell dropdown list containing the validation list
showDropdown(boolean) - Method in class org.dhatim.fastexcel.ListFormulaDataValidation: Whether Excel will show an in-cell dropdown list containing the validation list
showErrorMessage(boolean) - Method in class org.dhatim.fastexcel.CustomDataValidation: Whether to display the error alert message when an invalid value has been entered.
showErrorMessage(boolean) - Method in class org.dhatim.fastexcel.ListDataValidation: Whether to display the error alert message when an invalid value has been entered.
showErrorMessage(boolean) - Method in class org.dhatim.fastexcel.ListFormulaDataValidation: 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
SLANT_DASH_DOT - org.dhatim.fastexcel.BorderStyle
SMOKY_BLACK - Static variable in class org.dhatim.fastexcel.Color
SORT - org.dhatim.fastexcel.SheetProtectionOption: Sorting is locked when the sheet is protected.
sortWorksheets(Comparator<Worksheet>) - Method in class org.dhatim.fastexcel.Workbook: Sort the current worksheets with the given Comparator
STANDARD_PAPER_10_11 - org.dhatim.fastexcel.PaperSize
STANDARD_PAPER_10_14 - org.dhatim.fastexcel.PaperSize
STANDARD_PAPER_11_17 - org.dhatim.fastexcel.PaperSize
STANDARD_PAPER_15_11 - org.dhatim.fastexcel.PaperSize
STANDARD_PAPER_9_11 - org.dhatim.fastexcel.PaperSize
STATEMENT_PAPER - org.dhatim.fastexcel.PaperSize
STOP - org.dhatim.fastexcel.DataValidationErrorStyle
style() - Method in class org.dhatim.fastexcel.Range: Get a new style setter for this range.
style(int) - Method in class org.dhatim.fastexcel.Worksheet: Get a new style setter for a column.
style(int, int) - Method in class org.dhatim.fastexcel.Worksheet: Get a new style setter for a cell.
styleInfo() - Method in class org.dhatim.fastexcel.Table
StyleSetter - Class in org.dhatim.fastexcel: Helper class to set style elements on a cell or range of cells.
SUPERA_SUPERA_A4_PAPER - org.dhatim.fastexcel.PaperSize
SUPERB_SUPERB_A3_PAPER - org.dhatim.fastexcel.PaperSize

T

Table - Class in org.dhatim.fastexcel
Table.TableStyleInfo - Class in org.dhatim.fastexcel
TABLOID_EXTRA_PAPER - org.dhatim.fastexcel.PaperSize
TABLOID_PAPER - org.dhatim.fastexcel.PaperSize
TAN - Static variable in class org.dhatim.fastexcel.Color
TEAL - Static variable in class org.dhatim.fastexcel.Color
THICK - org.dhatim.fastexcel.BorderStyle
THIN - org.dhatim.fastexcel.BorderStyle
THISTLE - Static variable in class org.dhatim.fastexcel.Color
TimestampUtil - Class in org.dhatim.fastexcel: Excel timestamp utility methods.
TimestampUtil() - Constructor for class org.dhatim.fastexcel.TimestampUtil
toAbsoluteString() - Method in class org.dhatim.fastexcel.Range: Get an absolute reference to this Range.
TOP - org.dhatim.fastexcel.BorderSide
topMargin(float) - Method in class org.dhatim.fastexcel.Worksheet: Set top margin.
toString() - Method in class org.dhatim.fastexcel.BitMatrix
toString() - Method in enum org.dhatim.fastexcel.DataValidationErrorStyle
toString() - Method in class org.dhatim.fastexcel.DynamicBitMatrix
toString() - Method in class org.dhatim.fastexcel.DynamicByteArray
toString() - Method in class org.dhatim.fastexcel.Range
toString(String, String) - Method in class org.dhatim.fastexcel.BitMatrix
toString(String, String, String) - Method in class org.dhatim.fastexcel.BitMatrix: Deprecated.
call BitMatrix.toString(String,String) only, which uses \n line separator always
TURQUOISE - Static variable in class org.dhatim.fastexcel.Color

U

unfreeze() - Method in class org.dhatim.fastexcel.Worksheet: Unfreeze any frozen rows, or columns.
unset(int, int) - Method in class org.dhatim.fastexcel.BitMatrix
US_STANDARD_FANFOLD - org.dhatim.fastexcel.PaperSize

V

validateWithFormula(String) - Method in class org.dhatim.fastexcel.Range: Construct a new ListDataValidation
validateWithList(Range) - Method in class org.dhatim.fastexcel.Range: Construct a new ListDataValidation
validateWithListByFormula(String) - Method in class org.dhatim.fastexcel.Range: Construct a new ListDataValidation
value(int, int) - Method in class org.dhatim.fastexcel.Worksheet: Get the cell value (or formula) 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, Number) - Method in class org.dhatim.fastexcel.Worksheet: Set the cell value at the given coordinates.
value(int, int, String) - 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, LocalDateTime) - 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, Date) - Method in class org.dhatim.fastexcel.Worksheet: Set the cell value 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.DiagonalProperty: 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.DiagonalProperty: 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
VERY_HIDDEN - org.dhatim.fastexcel.VisibilityState: Indicates the sheet is hidden and cannot be shown in the user interface (UI).
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.
VISIBLE - org.dhatim.fastexcel.VisibilityState: Indicates the sheet is visible.

W

WARNING - org.dhatim.fastexcel.DataValidationErrorStyle
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.
withFont(String) - Method in class org.dhatim.fastexcel.MarginalInformation
withFontSize(int) - Method in class org.dhatim.fastexcel.MarginalInformation
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.
write(Writer) - Method in class org.dhatim.fastexcel.ConditionalFormattingExpressionRule: Write this conditionalFormatting as an XML element.
write(Writer) - Method in class org.dhatim.fastexcel.CustomDataValidation: Write this dataValidation as an XML element.
write(Writer) - Method in class org.dhatim.fastexcel.ListDataValidation: Write this dataValidation as an XML element.
write(Writer) - Method in class org.dhatim.fastexcel.ListFormulaDataValidation: Write this dataValidation as an XML element.
write(Writer) - Method in class org.dhatim.fastexcel.MarginalInformation
write(Writer) - Method in class org.dhatim.fastexcel.Table.TableStyleInfo

X

XmlEscapeHelper - Class in org.dhatim.fastexcel: Helper which can apply XML escaping to a string
XmlEscapeHelper() - Constructor for class org.dhatim.fastexcel.XmlEscapeHelper

Y

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

A B C D E F G H I J K L M N O P Q R S T U V W X Y
All Classes All Packages