Index

A B C D E F G H I J L M N O P R S T U V W X
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form

A

AbstractStyle - Class in ch.rabanti.nanoxlsx4j.styles

Class represents an abstract style component

AbstractStyle() - Constructor for class ch.rabanti.nanoxlsx4j.styles.AbstractStyle

add(XmlDocument.XmlAttribute) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlAttributeCollection

Ads an XML attribute to the node list

add(XmlDocument.XmlNode) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNodeList

Adds an XML node to the node list

addAllowedActionOnSheetProtection(Worksheet.SheetProtectionValue) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Method to add allowed actions if the worksheet is protected.

addCell(Object, int, int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds an object to the defined cell address.

addCell(Object, int, int, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds an object to the defined cell address.

addCell(Object, String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds an object to the defined cell address.

addCell(Object, String, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds an object to the defined cell address.

addCellFormula(String, int, int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a cell formula as string to the defined cell address

addCellFormula(String, int, int, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a cell formula as string to the defined cell address

addCellFormula(String, String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a cell formula as string to the defined cell address

addCellFormula(String, String, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a cell formula as string to the defined cell address

addCellRange(List<Object>, Address, Address) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a list of object values to a defined cell range.

addCellRange(List<Object>, Address, Address, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a list of object values to a defined cell range.

addCellRange(List<Object>, String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a list of object values to a defined cell range.

addCellRange(List<Object>, String, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a list of object values to a defined cell range.

addEnforcedColumn(int, ImportOptions.ColumnType) - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Adds a type enforcing rule to the passed column number (zero-based)

addEnforcedColumn(String, ImportOptions.ColumnType) - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Adds a type enforcing rule to the passed column address

addHiddenColumn(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the defined column as hidden

addHiddenColumn(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the defined column as hidden

addHiddenRow(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the defined row as hidden

addMruColor(String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Adds a color value (HEX; 6-digit RGB or 8-digit ARGB) to the MRU list

addNextCell(Object) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds an object to the next cell position.

addNextCell(Object, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds an object to the next cell position.

addNextCellFormula(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a formula as string to the next cell position

addNextCellFormula(String, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a formula as string to the next cell position

addPart(String, String, Document) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.Packer

Adds a Part to the file

addPart(String, String, Document, boolean) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.Packer

Adds a Part to the file

addRange(List<XmlDocument.XmlNode>) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNodeList

Adds a list of XML nodes to the node list

addRelationshipEntry(String, String) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.Packer.Relationship

Adds a relationship entry to the relationship

Address - Class in ch.rabanti.nanoxlsx4j

Class representing a cell address (no getters and setters to simplify handling)

Address(int, int) - Constructor for class ch.rabanti.nanoxlsx4j.Address

Constructor with row and column as arguments.

Address(int, int, Cell.AddressType) - Constructor for class ch.rabanti.nanoxlsx4j.Address

Constructor with row, column and address type as arguments

Address(String) - Constructor for class ch.rabanti.nanoxlsx4j.Address

Constructor with address as string.

Address(String, Cell.AddressType) - Constructor for class ch.rabanti.nanoxlsx4j.Address

Constructor with address as string.

addSelectedCells(Address, Address) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a range to the selected cells on this worksheet

addSelectedCells(Range) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a range to the selected cells on this worksheet

addSelectedCells(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Adds a range to the selected cells on this worksheet.

addStyle(Style) - Method in class ch.rabanti.nanoxlsx4j.styles.StyleManager

Adds a style component to the manager

addStyle(Style) - Method in class ch.rabanti.nanoxlsx4j.styles.StyleRepository

Adds a style to the repository and returns the actual reference

addStyle(Style) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Deprecated.

This method has no direct impact on the generated file and is deprecated

addStyleComponent(AbstractStyle) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Adds a style component and determines the appropriate type of it automatically

addStyleComponent(Style, AbstractStyle) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Deprecated.

This method has no direct impact on the generated file and is deprecated.

addWorksheet(Worksheet) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Adding a new Worksheet.

addWorksheet(Worksheet, boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Adding a new Worksheet.

addWorksheet(String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Adding a new Worksheet.

addWorksheet(String, boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Adding a new Worksheet with a sanitizing option.

AllNumbersToBigDecimal - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.GlobalType

All numbers are cast to BigDecimal

AllNumbersToDouble - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.GlobalType

All numbers are cast to doubles

AllNumbersToInt - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.GlobalType

All numbers are cast to integers.

append(AbstractStyle) - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Appends the specified style parts to the current one.

AppendAnnotation - Annotation Interface in ch.rabanti.nanoxlsx4j.styles

Annotation designated to control the copying of style properties

APPLICATION_NAME - Static variable in class ch.rabanti.nanoxlsx4j.Version

Application name of the library

AUTO_ZOOM_FACTOR - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Automatic zoom factor of a worksheet

autoFilter - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can use auto filters if the worksheets is protected

Average(Range) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with an average formula

Average(Worksheet, Range) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with an average formula

B

backgroundColor - Variable in class ch.rabanti.nanoxlsx4j.styles.Fill

BasicFormulas - Class in ch.rabanti.nanoxlsx4j

Class for handling of basic Excel formulas

BasicFormulas() - Constructor for class ch.rabanti.nanoxlsx4j.BasicFormulas

BasicStyles - Class in ch.rabanti.nanoxlsx4j.styles

Factory class with the most important predefined styles

BasicStyles() - Constructor for class ch.rabanti.nanoxlsx4j.styles.BasicStyles

BigDecimal - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.ColumnType

Cells are tried to be imported as numbers (enforcing BigDecimal)

Bold() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the bold style

BoldItalic() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the bold and italic style

Bool - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.ColumnType

Cells are tried to be imported as booleans

BOOL - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.CellType

Type for boolean

Border - Class in ch.rabanti.nanoxlsx4j.styles

Class representing a Border entry.

Border() - Constructor for class ch.rabanti.nanoxlsx4j.styles.Border

Default constructor

Border.StyleValue - Enum Class in ch.rabanti.nanoxlsx4j.styles

Enum for the border style

BorderFrame() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the border frame style

BorderFrameHeader() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the border style for header cells

bottom - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.VerticalAlignValue

Content will be aligned on the bottom (default)

bottomLeft - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.WorksheetPane

The pane is located in the bottom left of the split worksheet

bottomRight - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.WorksheetPane

The pane is located in the bottom right of the split worksheet

C

calculateInternalRotation() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Method to calculate the internal text rotation.

Ceil(Address, int) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a ceil formula

Ceil(Worksheet, Address, int) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a ceil formula

Cell - Class in ch.rabanti.nanoxlsx4j

Class representing a cell of a worksheet

Cell() - Constructor for class ch.rabanti.nanoxlsx4j.Cell

Default constructor.

Cell(Object, Cell.CellType) - Constructor for class ch.rabanti.nanoxlsx4j.Cell

Constructor with value and cell type.

Cell(Object, Cell.CellType, int, int) - Constructor for class ch.rabanti.nanoxlsx4j.Cell

Constructor with value, cell type, row number and column number

Cell(Object, Cell.CellType, Address) - Constructor for class ch.rabanti.nanoxlsx4j.Cell

Constructor with value, cell type and address class.

Cell(Object, Cell.CellType, String) - Constructor for class ch.rabanti.nanoxlsx4j.Cell

Constructor with value, cell type and address.

Cell.AddressScope - Enum Class in ch.rabanti.nanoxlsx4j

Enum to define the scope of a passed address string (used in static context)

Cell.AddressType - Enum Class in ch.rabanti.nanoxlsx4j

Enum for the referencing style of the address

Cell.CellType - Enum Class in ch.rabanti.nanoxlsx4j

Enum defines the basic data types of a cell

cellsByValue(Object) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Searches for cells that contain the specified value and returns a list of these cells.

CellXf - Class in ch.rabanti.nanoxlsx4j.styles

Class representing an XF entry.

CellXf() - Constructor for class ch.rabanti.nanoxlsx4j.styles.CellXf

Default constructor

CellXf.HorizontalAlignValue - Enum Class in ch.rabanti.nanoxlsx4j.styles

Enum for the horizontal alignment of a cell

CellXf.TextBreakValue - Enum Class in ch.rabanti.nanoxlsx4j.styles

Enum for text break options

CellXf.TextDirectionValue - Enum Class in ch.rabanti.nanoxlsx4j.styles

Enum for the general text alignment direction

CellXf.VerticalAlignValue - Enum Class in ch.rabanti.nanoxlsx4j.styles

Enum for the vertical alignment of a cell

center - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

Content will be aligned in the center

center - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.VerticalAlignValue

Content will be aligned in the center

centerContinuous - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

Center continuous alignment

ch.rabanti.nanoxlsx4j - package ch.rabanti.nanoxlsx4j

ch.rabanti.nanoxlsx4j.exceptions - package ch.rabanti.nanoxlsx4j.exceptions

ch.rabanti.nanoxlsx4j.lowLevel - package ch.rabanti.nanoxlsx4j.lowLevel

ch.rabanti.nanoxlsx4j.styles - package ch.rabanti.nanoxlsx4j.styles

clearActiveStyle() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Clears the active style of the worksheet.

clearMruColors() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Clears the MRU color list

colorizedBackground(String) - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets a style to colorize the background of a cell

colorizedText(String) - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets a style to colorize the text of a cell

Column - Class in ch.rabanti.nanoxlsx4j

Class representing a column of a worksheet

Column - Variable in class ch.rabanti.nanoxlsx4j.Address

Column of the address (zero-based)

Column(int) - Constructor for class ch.rabanti.nanoxlsx4j.Column

Constructor with column number

Column(String) - Constructor for class ch.rabanti.nanoxlsx4j.Column

Constructor with column address

ColumnToColumn - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.CellDirection

The next cell will be on the same row (A1,B1,C1...)

compareTo(Address) - Method in class ch.rabanti.nanoxlsx4j.Address

Compares two addresses and returns whether the passed one is bigger or not.

compareTo(Cell) - Method in class ch.rabanti.nanoxlsx4j.Cell

Implemented compareTo method

compareTo(AbstractStyle) - Method in class ch.rabanti.nanoxlsx4j.styles.AbstractStyle

Method to compare two objects for sorting purpose

convertArray(List<T>) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Converts a List of supported objects into a list of cells

convertDoubleToInt(Object) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

copy() - Method in class ch.rabanti.nanoxlsx4j.styles.AbstractStyle

Abstract method to copy a component (dereferencing)

copy() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Method to copy the current object to a new one

copy() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Method to copy the current object to a new one

copy() - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Method to copy the current object to a new one

copy() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Method to copy the current object to a new one

copy() - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Method to copy the current object to a new one

copy() - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Method to copy the current object to a new one

copy() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Creates a (dereferenced) deep copy of this worksheet

copyStyle() - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Copies the current object as cast style

copyWorksheetIntoThis(int, String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Copies a worksheet of the current workbook by its index

copyWorksheetIntoThis(int, String, boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Copies a worksheet of the current workbook by its index

copyWorksheetIntoThis(Worksheet, String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

copyWorksheetIntoThis(Worksheet, String, boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Copies a worksheet of any workbook into the current workbook

copyWorksheetIntoThis(String, String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Copies a worksheet of the current workbook by its name

copyWorksheetIntoThis(String, String, boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Copies a worksheet of the current workbook by its name

copyWorksheetTo(int, String, Workbook) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Copies a worksheet of the current workbook by its index into another workbook

copyWorksheetTo(int, String, Workbook, boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Copies a worksheet of the current workbook by its index into another workbook

copyWorksheetTo(Worksheet, String, Workbook) - Static method in class ch.rabanti.nanoxlsx4j.Workbook

Copies a worksheet of any workbook into the another workbook

copyWorksheetTo(Worksheet, String, Workbook, boolean) - Static method in class ch.rabanti.nanoxlsx4j.Workbook

Copies a worksheet of any workbook into the another workbook

copyWorksheetTo(String, String, Workbook) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Copies a worksheet of the current workbook by its name into another workbook

copyWorksheetTo(String, String, Workbook, boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Copies a worksheet of the current workbook by its name into another workbook

createBytesFromDocument(Document) - Static method in class ch.rabanti.nanoxlsx4j.lowLevel.XlsxWriter

Method to convert an XML document to a byte array

createDuration(int, int, int) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to create a Duration object form hours, minutes and second

createDuration(int, int, int, int) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to create a Duration object form days, hours, minutes and second

createRelationship(String) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.Packer

Creates a relationship.

createXMLDocument(String) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XlsxWriter

Creates an XML document from a string

custom - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Custom Format (ID 164 and higher)

custom_format - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.NumberFormatEvaluation.FormatRange

Custom defined formats from 165 and higher.

CUSTOMFORMAT_START_NUMBER - Static variable in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Start ID for custom number formats as constant (value 164)

D

darkGray - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Fill.PatternValue

Dark gray fill

dashDot - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

dash-dotted border

dashDotDot - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

dashed border with double-dots

dashed - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

dashed border

Date - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.ColumnType

Cells are tried to be imported as dates (Date).

DATE - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.CellType

Type for dates and times (Note: Dates before 1900-01-01 are not allowed)

DateFormat() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the date format style

Default - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.AddressType

Default behavior (e.g.

Default - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.GlobalType

No global strategy.

DEFAULT - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.CellType

Default Type, not specified

DEFAULT_ALIGNMENT - Static variable in class ch.rabanti.nanoxlsx4j.styles.CellXf

Default text break value as constant

DEFAULT_BORDER_COLOR - Static variable in class ch.rabanti.nanoxlsx4j.styles.Border

Default border color as constant

DEFAULT_BORDER_STYLE - Static variable in class ch.rabanti.nanoxlsx4j.styles.Border

Default border style as constant

DEFAULT_COLOR - Static variable in class ch.rabanti.nanoxlsx4j.styles.Fill

Default Color (foreground or background)

DEFAULT_COLUMN_WIDTH - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Default column width as constant

DEFAULT_DATE_FORMAT - Static variable in class ch.rabanti.nanoxlsx4j.ImportOptions

Default format if Date values are cast to strings

DEFAULT_FONT_FAMILY - Static variable in class ch.rabanti.nanoxlsx4j.styles.Font

Default font family

DEFAULT_FONT_NAME - Static variable in class ch.rabanti.nanoxlsx4j.styles.Font

Default font family as constant

DEFAULT_FONT_SCHEME - Static variable in class ch.rabanti.nanoxlsx4j.styles.Font

Default font scheme

DEFAULT_FONT_SIZE - Static variable in class ch.rabanti.nanoxlsx4j.styles.Font

Default font size

DEFAULT_HORIZONTAL_ALIGNMENT - Static variable in class ch.rabanti.nanoxlsx4j.styles.CellXf

Default horizontal align value as constant

DEFAULT_INDEXED_COLOR - Static variable in class ch.rabanti.nanoxlsx4j.styles.Fill

Default index color

DEFAULT_LOCALE - Static variable in class ch.rabanti.nanoxlsx4j.ImportOptions

Default locale instance (en-US) used for time parsing, if no custom locale is defined

DEFAULT_MAJOR_FONT - Static variable in class ch.rabanti.nanoxlsx4j.styles.Font

The default font name that is declared as Major Font (See Font.SchemeValue)

DEFAULT_MINOR_FONT - Static variable in class ch.rabanti.nanoxlsx4j.styles.Font

The default font name that is declared as Minor Font (See Font.SchemeValue)

DEFAULT_NUMBER - Static variable in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Default format number as constant

DEFAULT_PATTERN_FILL - Static variable in class ch.rabanti.nanoxlsx4j.styles.Fill

Default pattern

DEFAULT_ROW_HEIGHT - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Default row height as constant

DEFAULT_TEXT_DIRECTION - Static variable in class ch.rabanti.nanoxlsx4j.styles.CellXf

Default text direction value as constant

DEFAULT_TIME_FORMAT - Static variable in class ch.rabanti.nanoxlsx4j.ImportOptions

Default format if time (Duration) values are cast to strings

DEFAULT_VERTICAL_ALIGN - Static variable in class ch.rabanti.nanoxlsx4j.styles.Font

Default vertical alignment

DEFAULT_VERTICAL_ALIGNMENT - Static variable in class ch.rabanti.nanoxlsx4j.styles.CellXf

Default vertical align value as constant

defined_format - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.NumberFormatEvaluation.FormatRange

Format from 0 to 164 (with gaps)

deleteColumns - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can delete columns if the worksheets is protected

deleteRows - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can delete rows if the worksheets is protected

Disabled - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.CellDirection

The address of the next cell will be not changed when adding a cell (for manual definition of cell addresses)

distributed - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

Distributed alignment

distributed - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.VerticalAlignValue

Distributed alignment

dotted - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

dotted border

DottedFill_0_125() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the special pattern fill style (for compatibility)

Double - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.ColumnType

Cells are tried to be imported as numbers (enforcing double)

doubleAccounting - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Font.UnderlineValue

Text contains a double, accounting underline

DoubleUnderline() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the double underline style

down() - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor one row down

down(int) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor the number of defined rows down

down(int, boolean) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor the number of defined rows down

E

EMPTY - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.CellType

Type for empty cells.

EndAddress - Variable in class ch.rabanti.nanoxlsx4j.Range

End address of the range

equals(Object) - Method in class ch.rabanti.nanoxlsx4j.Address

Compares two addresses whether they are equal.

equals(Object) - Method in class ch.rabanti.nanoxlsx4j.Cell

equals(Object) - Method in class ch.rabanti.nanoxlsx4j.Range

Overwritten equals method

equals(Object) - Method in class ch.rabanti.nanoxlsx4j.styles.AbstractStyle

Method to compare two objects for sorting purpose

evaluateDateTimeStyle(int) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Returns a whole style by its index.

EverythingToString - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.GlobalType

Every cell is cast to a string.

F

fill - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

Content will fill up the cell

Fill - Class in ch.rabanti.nanoxlsx4j.styles

Class representing a Fill (background) entry.

Fill() - Constructor for class ch.rabanti.nanoxlsx4j.styles.Fill

Default constructor

Fill(String, Fill.FillType) - Constructor for class ch.rabanti.nanoxlsx4j.styles.Fill

Constructor with color value and fill type

Fill(String, String) - Constructor for class ch.rabanti.nanoxlsx4j.styles.Fill

Constructor with foreground and background color

Fill.FillType - Enum Class in ch.rabanti.nanoxlsx4j.styles

Enum for the type of the fill

Fill.PatternValue - Enum Class in ch.rabanti.nanoxlsx4j.styles

Enum for the type of the fill pattern

fillColor - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Fill.FillType

Color defines a solid fill color

FIRST_ALLOWED_EXCEL_DATE - Static variable in class ch.rabanti.nanoxlsx4j.Helper

First date that can be displayed by Excel.

FIRST_VALID_EXCEL_DATE - Static variable in class ch.rabanti.nanoxlsx4j.Helper

All dates before this date are shifted in Excel by -1.0, since Excel assumes wrongly that the year 1900 is a leap year.
See also: https://docs.microsoft.com/en-us/office/troubleshoot/excel/wrongly-assumes-1900-is-leap-year

firstCellByValue(Object) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Searches for the first occurrence of the value.

firstOrDefaultCell(Predicate<Cell>) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Searches for the first occurrence of the expression.

FixedColumn - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.AddressType

Column of the address is fixed (e.g.

FixedRow - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.AddressType

Row of the address is fixed (e.g.

FixedRowAndColumn - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.AddressType

Row and column of the address is fixed (e.g.

Floor(Address, int) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a floor formula

Floor(Worksheet, Address, int) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a floor formula

flushStyles() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleRepository

Empties the static repository

font(String) - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets a style with a user defined Font (Font size 11)
Note: The Font name as well as the availability of bold and italic on the Font cannot be validated by PicoXLSX4j.

font(String, float) - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets a style with a user defined Font
Note: The Font name as well as the availability of bold and italic on the Font cannot be validated by PicoXLSX4j.

font(String, float, boolean) - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets a style with a user defined Font
Note: The Font name as well as the availability of bold and italic on the Font cannot be validated by PicoXLSX4j.

font(String, float, boolean, boolean) - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets a style with a user defined Font
Note: The Font name as well as the availability of bold and italic on the Font cannot be validated by PicoXLSX4j.

Font - Class in ch.rabanti.nanoxlsx4j.styles

Class representing a Font entry.

Font() - Constructor for class ch.rabanti.nanoxlsx4j.styles.Font

Default constructor

Font.SchemeValue - Enum Class in ch.rabanti.nanoxlsx4j.styles

Enum for the font scheme

Font.UnderlineValue - Enum Class in ch.rabanti.nanoxlsx4j.styles

Enum for the style of the underline property of a stylized text

Font.VerticalAlignValue - Enum Class in ch.rabanti.nanoxlsx4j.styles

Enum for the vertical alignment of the text from baseline

forEach(Consumer<? super XmlDocument.XmlAttribute>) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlAttributeCollection

forEach(Consumer<? super XmlDocument.XmlNode>) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNodeList

foregroundColor - Variable in class ch.rabanti.nanoxlsx4j.styles.Fill

format_1 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: 0

format_10 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: 0.00%

format_11 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: 0.00E+00

format_12 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: # ?/?

format_13 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: # ??/??

format_14 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: m/d/yyyy

format_15 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: d-mmm-yy

format_16 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: d-mmm

format_17 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: mmm-yy

format_18 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: mm AM/PM

format_19 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: h:mm:ss AM/PM

format_2 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: 0.00

format_20 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: h:mm

format_21 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: h:mm:ss

format_22 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: m/d/yyyy h:mm

format_3 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: #,##0

format_37 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: #,##0_);(#,##0)

format_38 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: #,##0_);[Red](#,##0)

format_39 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: #,##0.00_);(#,##0.00)

format_4 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: #,##0.00

format_40 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: #,##0.00_);[Red](#,##0.00)

format_45 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: mm:ss

format_46 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: [h]:mm:ss

format_47 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: mm:ss.0

format_48 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: ##0.0E+0

format_49 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: #

format_5 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: $#,##0_);($#,##0)

format_6 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: $#,##0_);[Red]($#,##0)

format_7 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: $#,##0.00_);($#,##0.00)

format_8 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: $#,##0.00_);[Red]($#,##0.00)

format_9 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Format: 0%

formatCells - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can format cells if the worksheets is protected

formatColumns - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can format columns if the worksheets is protected

FormatException - Exception in ch.rabanti.nanoxlsx4j.exceptions

Class for exceptions regarding format error incidents

FormatException() - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.FormatException

Default constructor

FormatException(String) - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.FormatException

Constructor with passed message

FormatException(String, Exception) - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.FormatException

Constructor with passed message and inner

formatRows - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can format rows if the worksheets is protected

formula(String) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Sets a formula into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction)

formula(String, Style) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Sets a formula with style into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction)

FORMULA - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.CellType

Type for Formulas (The cell will be handled differently)

G

general - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

General alignment

generatePasswordHash(String) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to generate an Excel internal password hash to protect workbooks or worksheets
This method is derived from the c++ implementation by Kohei Yoshida (http://kohei.us/2008/01/18/excel-sheet-protection-password-hash/)
WARNING! Do not use this method to encrypt 'real' passwords or data outside from PicoXLSX4j.

get(int) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNodeList

Gets an XML node at the given index

getActivePane() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

Gets the active pane in the split window

getActivePane() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the active Pane is splitting is applied.
The value is nullable.

getActiveStyle() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the active Style of the worksheet.

getAddress() - Method in class ch.rabanti.nanoxlsx4j.Address

Gets the address as string

getAddressScope(String) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Gets the scope of the passed address (string expression).

getAlignment() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Gets the text break options of the style

getApplication() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the application that has created an XLSX file.

getApplication() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the application which created the workbook.

getApplicationVersion() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the version of the application that has created an XLSX file

getApplicationVersion() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the version of the creation application.

getAttribute(String) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNode

Gets the XML attribute of the current node by its name

getAttribute(String, String) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNode

Gets the XML attribute of the current node by its name

getAutoFilterRange() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

gets the auto filter range

getAutoFilterRange() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the range of the auto filter.

getBackgroundColor() - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Gets the Background color of the fill.

getBorder() - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Gets the border component of the style

getBorder(int) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Returns a border component by its index

getBorders() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleManager

Gets all borders of the style manager

getBorderStyleNumber() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleManager

Gets the number of borders in the style manager

getBottomColor() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the color code of the bottom border.

getBottomStyle() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the style of bottom cell border

getByName(String) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlAttributeCollection

Finds the attribute with the defined name (can be null)

getCategory() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the document category of an XLSX file

getCategory() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the category of the document.

getCell(int, int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the cell of the specified column and row number (zero-based)

getCell(Address) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the cell of the specified address

getCell(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the cell of the specified address as String

getCellAddress() - Method in class ch.rabanti.nanoxlsx4j.Cell

Gets the combined cell Address as string in the format A1 - XFD1048576

getCellAddress2() - Method in class ch.rabanti.nanoxlsx4j.Cell

Gets the combined cell address as class

getCellAddressType() - Method in class ch.rabanti.nanoxlsx4j.Cell

Gets the optional address type that can be part of the cell address.

getCellRange(int, int, int, int) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Get a list of cell addresses from a cell range

getCellRange(Address, Address) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Get a list of cell addresses from a cell range

getCellRange(String) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Gets a list of cell addresses from a cell range (format A1:B3 or AAD556:AAD1000)

getCellRange(String, String) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Get a list of cell addresses from a cell range

getCells() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the cells of the worksheet as map with the cell address as key and the cell object as value

getCellStyle() - Method in class ch.rabanti.nanoxlsx4j.Cell

Gets the assigned style of the cell

getCellXf() - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Gets the cellXf component of the style

getCharset() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets the charset of the Font (Default is empty)

getChildNodes() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNode

Gets the child nodes of this node

getColorTheme() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets the font color theme (Default is 1 = Light)

getColorValue() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets the Font color (default is empty)

getColumn() - Method in class ch.rabanti.nanoxlsx4j.Address

Gets the column address (A - XFD)

getColumn(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets a column as list of cell objects

getColumn(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets a column as list of cell objects

getColumnAddress() - Method in class ch.rabanti.nanoxlsx4j.Column

Gets the column address

getColumnNumber() - Method in class ch.rabanti.nanoxlsx4j.Cell

Gets the number of the column (zero-based)

getColumns() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets a list of defined Columns

getColumns() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets all columns with non-standard properties, like auto filter applied or a special width as map with the zero-based column index as key and the column object as value

getCompany() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the responsible company of an XLSX file

getCompany() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the company owning the document.

getContentStatus() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the content status of an XLSX file

getContentStatus() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the status of the document.

getCreator() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the creator of an XLSX file

getCreator() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the creator of the workbook.

getCurrentCellDirection() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the direction when using AddNextCell method

getCurrentColumnNumber() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the current column number (zero based)

getCurrentRowNumber() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the current row number (zero based)

getCurrentWorksheet() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets the current worksheet

getCurrentZoomScale() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets the zoom factor of the current view type

getCustomFormatCode() - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Gets the custom format code in the notation of Excel

getCustomFormatID() - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Gets the format number of the custom format.

getData() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets the data of the worksheet as Hashmap of cell address-cell object tuples

getDataType() - Method in class ch.rabanti.nanoxlsx4j.Cell

Gets the type of the cell

getDateFormat() - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Gets the format if Date values are cast to Strings

getDateFormatter() - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Gets the Date formatter, set by the string of ImportOptions.setDateFormat(String)

getDateFromOA(double) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to calculate a common Date from the OA date (OLE automation) format
OA Date format starts at January 1st 1900 (actually 00.01.1900).

getDefaultColumnStyle() - Method in class ch.rabanti.nanoxlsx4j.Column

Gets the default style of the column

getDefaultColumnWidth() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets the default column width

getDefaultColumnWidth() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the default column width

getDefaultRowHeight() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets the default row height

getDefaultRowHeight() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the default Row height

getDescription() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the description of an XLSX file

getDescription() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the description of the document or comment about it

getDiagonalColor() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the color code of the diagonal lines.

getDiagonalStyle() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the style of the diagonal lines

getDocumentElement() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument

Gets the root node of the XML document

getElementsByTagName(String, boolean) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNode

Gets a list of sub-nodes with the defined name

getEnforcedColumnTypes() - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

gets the type enforcing rules during import for particular columns

getEnforcingStartRowNumber() - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

gets the row number (zero-based) where enforcing rules are started to be applied.

getFamily() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets the font family (Default is 2)

getFilename() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets the filename of the workbook

getFill() - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Gets the fill component of the style

getFill(int) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Returns a fill component by its index

getFills() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleManager

Gets all fills of the style manager

getFillStyleNumber() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleManager

Gets the number of fills in the style manager

getFirstCellAddress() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the first existing cell in the current worksheet (bottom right)

getFirstColumnNumber() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the first existing column number in the current worksheet (zero-based)

getFirstDataCellAddress() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the first existing cell with data in the current worksheet (bottom right)

getFirstDataColumnNumber() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the first existing column number with data in the current worksheet (zero-based)

getFirstDataRowNumber() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the first existing row number with data in the current worksheet (zero-based)

getFirstRowNumber() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the first existing row number in the current worksheet (zero-based)

getFont() - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Gets the font component of the style

getFont(int) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Returns a font component by its index

getFonts() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleManager

Gets all fonts of the style manager

getFontStyleNumber() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleManager

Gets the number of fonts in the style manager

getForegroundColor() - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Gets the foreground color of the fill.

getFormatNumber() - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat.NumberFormatEvaluation

Gets the evaluated Format

getFreezeSplitPanes() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets whether split panes are frozen.
The value is nullable.

getFrozenState() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

Gets the frozen state of the split window

getGlobalEnforcingType() - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Gets the global strategy to handle cell values.

getHiddenRows() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the hidden rows as map with the zero-based row number as key and a boolean as value.

getHorizontalAlign() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Gets the horizontal alignment of the style

getHyperlinkBase() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the hyperlink base of an XLSX file

getHyperlinkBase() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the hyperlink base of the document

getIndent() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Gets the indentation in case of left, right or distributed alignment.

getIndexedColor() - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Gets the indexed color (Default is 64)

getInnerException() - Method in exception ch.rabanti.nanoxlsx4j.exceptions.FormatException

Gets the inner exception

getInnerException() - Method in exception ch.rabanti.nanoxlsx4j.exceptions.IOException

Gets the inner exception

getInnerText() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNode

Gets the inner plain text of the node, if available

getInstance() - Static method in class ch.rabanti.nanoxlsx4j.styles.StyleRepository

Gets the singleton instance of the repository

getInternalColumnWidth(float) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Calculates the internal width of a column in characters.

getInternalColumnWidth(float, float, float) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Calculates the internal width of a column in characters.

getInternalID() - Method in class ch.rabanti.nanoxlsx4j.styles.AbstractStyle

Gets the internal ID for sorting purpose in the Excel style document

getInternalPaneSplitHeight(float) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Calculates the internal height of a split pane in a worksheet.

getInternalPaneSplitWidth(float) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Calculates the internal width of a split pane in a worksheet.

getInternalPaneSplitWidth(float, float, float) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Calculates the internal width of a split pane in a worksheet.

getInternalRowHeight(float) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Calculates the internal height of a row.

getKeywords() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the keywords of an XLSX file

getKeywords() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the keyword for the workbook.

getLastCellAddress() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the last existing cell in the current worksheet (bottom right)

getLastColumnNumber() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the last existing column number in the current worksheet (zero-based)

getLastDataCellAddress() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the last existing cell in the current worksheet (bottom right)

getLastDataColumnNumber() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the last existing column number with data in the current worksheet (zero-based)

getLastDataRowNumber() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the last existing row number with data in the current worksheet (zero-based)

getLastRowNumber() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the last existing row number in the current worksheet (zero-based)

getLeftColor() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the color code of the left border.

getLeftStyle() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the style of left cell border

getManagedStyles(Workbook) - Static method in class ch.rabanti.nanoxlsx4j.styles.StyleManager

Method to gather all styles of the cells in all worksheets

getManager() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the manager (responsible) of an XLSX file

getManager() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the responsible manager of the document.

getMergedCells() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets a list of merged cells

getMergedCells() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the merged cells (only references) as map with the cell address as key and the range object as value

getMruColors() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets the MRU color list

getName() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNode

Gets the (tag) name of the XML node

getName() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets the font name (Default is Calibri)

getName() - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Gets the informal name of the style.

getNextBorderId() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Gets the next internal id of a border component.
The method is currently not used but prepared for usage when the style reader is fully implemented

getNextCellXFId() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Gets the next internal id of a cell XF component.
The method is currently not used but prepared for usage when the style reader is fully implemented

getNextFillId() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Gets the next internal id of a fill component.
The method is currently not used but prepared for usage when the style reader is fully implemented

getNextFontId() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Gets the next internal id of a font component.
The method is currently not used but prepared for usage when the style reader is fully implemented

getNextNumberFormatId() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Gets the next internal id of a number format component

getNextStyleId() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Gets the next internal id of a style

getNumber() - Method in class ch.rabanti.nanoxlsx4j.Column

Gets the column number

getNumber() - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Gets the format number.

getNumberFormat() - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Gets the number format component of the style

getNumberFormat(int) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Returns a number format component by its index

getNumberFormats() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleManager

Gets all number formats of the style manager

getOADate(Date) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to calculate the OA date (OLE automation) of the passed date.
OA Date format starts at January 1st 1900 (actually 00.01.1900).

getOADate(Date, boolean) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to calculate the OA date (OLE automation) of the passed date.
OA Date format starts at January 1st 1900 (actually 00.01.1900).

getOADateString(Date) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to calculate the OA date (OLE automation) of the passed date.
OA Date format starts at January 1st 1900 (actually 00.01.1900).

getOATime(Duration) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to convert a duration into the internal Excel time format (OAdate without days).
The time is represented by a OAdate without the date component but a possible number of total days

getOATimeString(Duration) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to convert a duration into the internal Excel time format (OAdate without days).
The time is represented by a OAdate without the date component but a possible number of total days

getPaneSplitAddress() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the split address for frozen panes or if pane split was defined in number of columns and / or rows.
For vertical splits, only the column component is considered.

getPaneSplitColumnIndex() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

Gets the column index of a worksheet split

getPaneSplitHeight() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

Gets the pane split height of a worksheet split

getPaneSplitHeight(float) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Calculates the height of a split pane in a worksheet, based on the internal value (calculated by Helper.getInternalPaneSplitHeight(float))

getPaneSplitLeftWidth() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the width of the left, vertical split pane, measured from the left of the window.
The value is nullable.

getPaneSplitRowIndex() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

Gets the row index of a worksheet split

getPaneSplitTopHeight() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the height of the upper, horizontal split pane, measured from the top of the window.
The value is nullable.

getPaneSplitTopLeftCell() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the Top Left cell address of the bottom right pane if applicable and splitting is applied.
The column is only relevant for vertical split, whereas the row component is only relevant for a horizontal split.
The value is nullable.

getPaneSplitValue() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets the definition of pane split-related information

getPaneSplitWidth() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

Gets the pane split width of a worksheet split

getPaneSplitWidth(float) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Calculates the width of a split pane in a worksheet, based on the internal value (calculated by Helper.getInternalPaneSplitWidth(float, float, float))

getPaneSplitWidth(float, float, float) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Calculates the width of a split pane in a worksheet, based on the internal value (calculated by Helper.getInternalPaneSplitWidth(float, float, float))

getPasswordHash() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader

Password hash if available

getPatternFill() - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Gets the pattern type of the fill (Default is none)

getPatternName(Fill.PatternValue) - Static method in class ch.rabanti.nanoxlsx4j.styles.Fill

Gets the pattern name from the enum

getRange() - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat.NumberFormatEvaluation

Gets the range of the evaluated number format

getRelationships() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.RelationshipReader

Gets the list of workbook relationship entries

getRelId() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader.WorksheetDefinition

Gets the reference ID

getResult() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer.StyleResult

Gets the style as result

getRightColor() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the color code of the right border.

getRightStyle() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the style of right cell border

getRow(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets a row as list of cell objects

getRowHeights() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets defined row heights as map with the zero-based row number as key and the height (float from 0 to 409.5) as value

getRowNumber() - Method in class ch.rabanti.nanoxlsx4j.Cell

Gets the number of the row (zero-based)

getRows() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets a map of row definitions

getScheme() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets the font scheme (Default is minor)

getSelectedCellRanges() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets all ranges of selected cells of this worksheet.

getSelectedCells() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets the selected cell ranges (panes are currently not considered)

getSelectedCells() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Deprecated.

This method is a deprecated subset of the function SelectedCellRanges. SelectedCellRanges will get this function name in a future version. Therefore, the type will change

getSelectedWorksheet() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader

Selected worksheet of the workbook

getSelectedWorksheet() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets the selected worksheet.

getSheetId() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader.WorksheetDefinition

Internal worksheet ID

getSheetID() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the internal ID of the worksheet

getSheetName() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the name of the sheet

getSheetProtectionPassword() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the password used for sheet protection

getSheetProtectionPasswordHash() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

gets the encryption hash of the password, defined with Worksheet.setSheetProtectionPassword(String).

getSheetProtectionValues() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the list of SheetProtectionValues.

getSize() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets the font size.

getString(int) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.SharedStringsReader

Gets the value of the shared string table by its index

getStyle(String) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Returns a whole style by its index

getStyleAssignment() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets the assignment of resolved styles to cell addresses

getStyleCount() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

Gets the number of resolved styles

getStyleName(Border.StyleValue) - Static method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the border style name from the enum

getStyleNumber() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleManager

Gets the number of styles in the style manager

getStyleReaderContainer() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReader

Gets the container for raw style components of the reader.

getStyles() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleManager

Gets all styles of the style manager

getStyles() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleRepository

Gets the currently managed styles of the repository

getSubject() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the subject of an XLSX file

getSubject() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the subject of the workbook

getTemporalLocale() - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Gets the Locale instance, used to parse Duration objects from strings.

getTextDirection() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Gets the direction of the text within the cell

getTextRotation() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Gets the text rotation in degrees (from +90 to -90)

getTimeFormat() - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Gets the format if Duration (time) values are cast to Strings

getTimeFormatter() - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Gets the formatter to parse a Duration (time), set by the string of ImportOptions.setTimeFormat(String)

getTitle() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Gets the title of an XLSX file

getTitle() - Method in class ch.rabanti.nanoxlsx4j.Metadata

Gets the title of the workbook

getTopColor() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the color code of the top border.

getTopLeftCell() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

Gets the top Left cell address of the bottom right pane

getTopStyle() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the style of top cell border

getUnderline() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets the underline style of the font

getValue() - Method in class ch.rabanti.nanoxlsx4j.Cell

Gets the value of the cell (generic object type)

getValue() - Method in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

getValue() - Method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

getValue() - Method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.TextBreakValue

getValue() - Method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.TextDirectionValue

getValue() - Method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.VerticalAlignValue

getValue() - Method in enum class ch.rabanti.nanoxlsx4j.styles.Fill.FillType

getValue() - Method in enum class ch.rabanti.nanoxlsx4j.styles.Fill.PatternValue

getValue() - Method in enum class ch.rabanti.nanoxlsx4j.styles.Font.VerticalAlignValue

getValue() - Method in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

Gets the numeric value of the enum entry

getVersion() - Static method in class ch.rabanti.nanoxlsx4j.Version

Gets the library version

getVerticalAlign() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Gets the vertical alignment of the style

getVerticalAlign() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets the alignment of the font (Default is none)

getViewType() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets the sheet view type of the current worksheet

getViewType() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets how the current worksheet is displayed in the spreadsheet application (Excel)

getWidth() - Method in class ch.rabanti.nanoxlsx4j.Column

Gets the width of the column

getWorkbook() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XlsxReader

Resolves the workbook with all worksheets from the loaded file

getWorkbookMetadata() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets the metadata object of the workbook

getWorkbookProtectionPassword() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets the password used for workbook protection

getWorkbookProtectionPasswordHash() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Hash of the protected workbook, originated from Workbook.getWorkbookProtectionPassword()

getWorkbookReference() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the Reference to the parent Workbook

getWorksheet(int) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets a worksheet from this workbook by index

getWorksheet(String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets a worksheet from this workbook by name

getWorksheetDefinitions() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader

Hashmap of worksheet definitions.

getWorksheetName() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader.WorksheetDefinition

Gets the worksheet name

getWorksheetProtection() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets the applicable worksheet protection values

getWorksheetProtectionHash() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets the (legacy) password hash of a worksheet if protection values are applied with a password

getWorksheets() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets the list of worksheets in the workbook

getZoomFactor() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets the zoom factor of the Worksheet.setViewType(SheetViewType) of the current worksheet.

getZoomFactors() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets all preserved zoom factors of the worksheet

getZoomFactors() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets all defined zoom factors per Worksheet.SheetViewType of the current worksheet.

goToNextColumn() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Moves the current position to the next column

goToNextColumn(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Moves the current position to the next column with the number of cells to move

goToNextColumn(int, boolean) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Moves the current position to the next column with the number of cells to move and the option to keep the row position

goToNextRow() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Moves the current position to the next row (use for a new line)

goToNextRow(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Moves the current position to the next row with the number of cells to move (use for a new line)

goToNextRow(int, boolean) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Moves the current position to the next row with the number of cells to move and the option to keep the row position (use for a new line)

gray0625 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Fill.PatternValue

6.25% gray fill

gray125 - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Fill.PatternValue

12.5% gray fill

H

hair - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

hair border

hasAutoFilter() - Method in class ch.rabanti.nanoxlsx4j.Column

Gets whether auto filter is enabled on the column

hasCell(int, int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets whether the specified address exists in the worksheet.

hasCell(Address) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets whether the specified address exists in the worksheet.

hasChildNodes() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNode

Gets whether child nodes are available in this node

hasElements() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.SharedStringsReader

Gets whether the workbook contains shared strings

hashCode() - Method in class ch.rabanti.nanoxlsx4j.Address

Gets the hash code of the address based on its string representation

hashCode() - Method in class ch.rabanti.nanoxlsx4j.Range

Gets the hash code of the range based on its string representation.

hashCode() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Override method to calculate the hash of this component

hashCode() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Override method to calculate the hash of this component

hashCode() - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Override method to calculate the hash of this component

hashCode() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Override method to calculate the hash of this component

hashCode() - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Override method to calculate the hash of this component

hashCode() - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Override method to calculate the hash of this component

hasNext() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlAttributeCollection

hasNext() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNodeList

hasValue - Variable in class ch.rabanti.nanoxlsx4j.lowLevel.ReaderUtils.IntParser

Helper - Class in ch.rabanti.nanoxlsx4j

Class for shared used (static) methods

horizontal - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.TextDirectionValue

Text direction is horizontal (default)

I

ignore() - Element in annotation interface ch.rabanti.nanoxlsx4j.styles.AppendAnnotation

Indicates whether the property annotated with the attribute is ignored during the copying of properties

ImportOptions - Class in ch.rabanti.nanoxlsx4j

The import options define global rules to import worksheets.

ImportOptions() - Constructor for class ch.rabanti.nanoxlsx4j.ImportOptions

ImportOptions.ColumnType - Enum Class in ch.rabanti.nanoxlsx4j

Column types to enforce during the import

ImportOptions.GlobalType - Enum Class in ch.rabanti.nanoxlsx4j

Global conversion types to enforce during the import.

indexedColor - Variable in class ch.rabanti.nanoxlsx4j.styles.Fill

insertColumn(int, int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Inserts 'count' columns right of the specified 'columnNumber'.

insertColumns - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can insert columns if the worksheets is protected

insertHyperlinks - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can insert hyperlinks if the worksheets is protected

insertRow(int, int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Inserts 'count' rows below the specified 'rowNumber'.

insertRows - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can insert rows if the worksheets is protected

IntParser() - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.ReaderUtils.IntParser

IntParser(String) - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.ReaderUtils.IntParser

invalid - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.NumberFormatEvaluation.FormatRange

Probably invalid format numbers (e.g.

Invalid - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.AddressScope

The address expression is invalid

IOException - Exception in ch.rabanti.nanoxlsx4j.exceptions

Class for exceptions regarding stream or save error incidents

IOException() - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.IOException

Default constructor

IOException(String) - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.IOException

Constructor with passed message

IOException(String, Exception) - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.IOException

Constructor with passed message and inner exception

isBold() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets the bold parameter of the font

isCustomFormat() - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Gets whether this object is a custom format

isDateFormat(NumberFormat.FormatNumber) - Static method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Determines whether a defined style format number represents a date (or date and time).
Note: Custom number formats (higher than 164), as well as not officially defined numbers (below 164) are currently not considered during the check and will return false

isDateStyle() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer.StyleResult

Gets whether the style is to describe a date

isDefaultFont() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets whether this object is the default font

isDiagonalDown() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the downwards diagonal line

isDiagonalUp() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Gets the upwards diagonal line

isEmpty() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Method to determine whether the object has no values but the default values (means: is empty and must not be processed)

isEnforceDateTimesAsNumbers() - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Gets whether date or time values in the workbook are interpreted as numbers

isEnforceEmptyValuesAsString() - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Gets whether empty cells are of the type Empty or String

isEnforcePhoneticCharacterImport() - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Gets whether phonetic characters (like ruby characters / Furigana / Zhuyin fuhao) in strings are added in brackets after the transcribed symbols.

isForceApplyAlignment() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Gets whether the applyAlignment property (used to merge cells) will be defined in the XF entry of the style.

isHidden() - Method in class ch.rabanti.nanoxlsx4j.Column

Gets whether the column is hidden or visible

isHidden() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader

Hidden state of the workbook

isHidden() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader.WorksheetDefinition

Gets the hidden state of the worksheet

isHidden() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Gets whether the hidden property (used for protection or hiding of cells) will be defined in the XF entry of the style.

isHidden() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets whether the workbook is hidden

isHidden() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets whether the worksheet is hidden

isImportInProgress() - Method in class ch.rabanti.nanoxlsx4j.styles.StyleRepository

Gets the import state of the repository

isInternalStyle() - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Gets whether the style is system internal

isItalic() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets the italic parameter of the font

isLocked() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Gets whether the locked property (used for locking / protection of cells or worksheets) will be defined in the XF entry of the style.

isLockStructure() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader

Lock state of the structural elements

isLockWindows() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader

Lock state of the windows

isNullOrEmpty(String) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to check a string whether its reference is null or the content is empty

isProtected() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader

Protection state of the workbook

isShowingGridLines() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets whether grid lines are shown

isShowingGridLines() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets whether grid lines are visible on the current worksheet.

isShowingRowColHeaders() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets whether column and row headers are shown

isShowingRowColumnHeaders() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets whether the column and row headers are visible on the current worksheet.

isShowingRuler() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Gets whether rulers are shown in view type: pageLayout

isShowingRuler() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets whether a ruler is displayed over the column headers.

isStrike() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Gets whether the font is struck through

isStructureLockedIfProtected() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets whether the structure are locked if workbook is protected

isTimeFormat(NumberFormat.FormatNumber) - Static method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Determines whether a defined style format number represents a time.
Note: Custom number formats (higher than 164), as well as not officially defined numbers (below 164) are currently not considered during the check and will return false

isTimeStyle() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer.StyleResult

Gets whether the style is to describe a time

isUseSheetProtection() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Gets whether the worksheet is protected

isWindowsLockedIfProtected() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets whether the windows are locked if workbook is protected

isWorkbookProtectionUsed() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Gets whether the workbook is protected

isXSplitDefined() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

Gets whether an Y split was defined

isYSplitDefined() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

Gets whether an X split was defined

Italic() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the italic style

iterator() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlAttributeCollection

iterator() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNodeList

J

justify - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

justify alignment

justify - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.VerticalAlignValue

justify alignment

L

LAST_ALLOWED_EXCEL_DATE - Static variable in class ch.rabanti.nanoxlsx4j.Helper

Last date that can be displayed by Excel.

left - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

Content will be aligned left

left() - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor one column to the left

left(int) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor the number of defined columns to the left

left(int, boolean) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor the number of defined columns to the left

lightGray - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Fill.PatternValue

Light gray fill

load(InputStream) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument

Loads an XML document from a stream

load(InputStream) - Static method in class ch.rabanti.nanoxlsx4j.Workbook

Loads a workbook from an input stream

load(InputStream, ImportOptions) - Static method in class ch.rabanti.nanoxlsx4j.Workbook

Loads a workbook from an input stream with import options

load(String) - Static method in class ch.rabanti.nanoxlsx4j.Workbook

Loads a workbook from a file

load(String, ImportOptions) - Static method in class ch.rabanti.nanoxlsx4j.Workbook

Loads a workbook from a file with import options

loadXmlNode(XMLStreamReader) - Static method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNode

Static method to resolve attributes and sub-nodes recursively

M

major - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Font.SchemeValue

Font scheme is major

Max(Range) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a max formula

Max(Worksheet, Range) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a max formula

MAX_COLUMN_NUMBER - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Maximum column number (zero-based)

MAX_COLUMN_WIDTH - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Maximum column width as constant

MAX_FONT_SIZE - Static variable in class ch.rabanti.nanoxlsx4j.styles.Font

Minimum possible font size

MAX_OADATE_VALUE - Static variable in class ch.rabanti.nanoxlsx4j.Helper

Maximum valid OAdate value (9999-12-31)

MAX_OADATE_VALUE - Static variable in class ch.rabanti.nanoxlsx4j.lowLevel.XlsxWriter

Maximum valid OAdate value (9999-12-31)

MAX_ROW_HEIGHT - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Maximum row height as constant

MAX_ROW_NUMBER - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Maximum row number (zero-based)

MAX_WORKSHEET_NAME_LENGTH - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Maximum number of characters a worksheet name can have

MAX_ZOOM_FACTOR - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Maximum zoom factor of a worksheet

Median(Range) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a median formula

Median(Worksheet, Range) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a median formula

medium - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

medium border

mediumDashDot - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

medium dash-dotted border

mediumDashDotDot - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

medium-dashed border with double-dots

mediumDashed - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

medium dashed border

mediumGray - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Fill.PatternValue

Medium gray fill

mergeCells(Address, Address) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Merges the defined cell range

mergeCells(Range) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Merges the defined cell range

mergeCells(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Merges the defined cell range

MergeCellStyle() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the style used when merging cells

Metadata - Class in ch.rabanti.nanoxlsx4j

Class representing the metadata of a workbook

Metadata() - Constructor for class ch.rabanti.nanoxlsx4j.Metadata

Default constructor

MetaDataReader - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing a reader for the metadata files (docProps) of XLSX files

MetaDataReader() - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Min(Range) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a min formula

Min(Worksheet, Range) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a min formula

MIN_COLUMN_NUMBER - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Minimum column number (zero-based)

MIN_COLUMN_WIDTH - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Minimum column width as constant

MIN_FONT_SIZE - Static variable in class ch.rabanti.nanoxlsx4j.styles.Font

Maximum possible font size

MIN_OADATE_VALUE - Static variable in class ch.rabanti.nanoxlsx4j.Helper

Minimum valid OAdate value (1900-01-01).

MIN_OADATE_VALUE - Static variable in class ch.rabanti.nanoxlsx4j.lowLevel.XlsxWriter

Minimum valid OAdate value (1900-01-01)

MIN_ROW_HEIGHT - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Minimum row height as constant

MIN_ROW_NUMBER - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Minimum row number (zero-based)

MIN_ZOOM_FACTOR - Static variable in class ch.rabanti.nanoxlsx4j.Worksheet

Minimum zoom factor of a worksheet.

minor - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Font.SchemeValue

Font scheme is minor (default)

N

nestedProperty() - Element in annotation interface ch.rabanti.nanoxlsx4j.styles.AppendAnnotation

Indicates whether the property annotated with the attribute is a nested property.

next() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlAttributeCollection

next() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNodeList

none - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

no border

none - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

No alignment.

none - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.TextBreakValue

Text will overflow in cell

none - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.VerticalAlignValue

No alignment.

none - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Fill.PatternValue

No pattern (default)

none - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Font.SchemeValue

No Font scheme is used

none - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Font.UnderlineValue

Text contains no underline (default)

none - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Font.VerticalAlignValue

Text will be rendered normal

none - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

No format / Default

normal - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetViewType

The worksheet is displayed without pagination (default)

NUMBER - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.CellType

Type for all numeric types (long, short, byte, integer, float, double and BigDecimal)

NumberFormat - Class in ch.rabanti.nanoxlsx4j.styles

Class representing a NumberFormat entry.

NumberFormat() - Constructor for class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Default constructor

NumberFormat.FormatNumber - Enum Class in ch.rabanti.nanoxlsx4j.styles

Enum for the defined number formats

NumberFormat.NumberFormatEvaluation - Class in ch.rabanti.nanoxlsx4j.styles

Class represents the evaluation of a number format (number) and its purpose

NumberFormat.NumberFormatEvaluation.FormatRange - Enum Class in ch.rabanti.nanoxlsx4j.styles

Range or validity of the format number

NumberFormatEvaluation() - Constructor for class ch.rabanti.nanoxlsx4j.styles.NumberFormat.NumberFormatEvaluation

Numeric - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.ColumnType

Cells are tried to be imported as numbers (automatic determination of numeric type)

O

objects - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can edit objects if the worksheets is protected

P

pack(OutputStream) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.Packer

Method to pack the data into a XLSX file.

Packer - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing a packer to compile XLSX files

Packer(XlsxWriter) - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.Packer

Default constructor with parameter

Packer.Relationship - Class in ch.rabanti.nanoxlsx4j.lowLevel

Nested class representing a relationship (MSXML)

pageBreakPreview - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetViewType

The worksheet is displayed with indicators where the page would break if it were printed

pageLayout - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetViewType

The worksheet is displayed like it would be printed

PaneDefinition() - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

parseBinaryBoolean(String) - Static method in class ch.rabanti.nanoxlsx4j.lowLevel.ReaderUtils

Parses a bool as a binary number either based on an int (0/1) or a string expression (true/ false), independent of the culture info of the host

parseTime(String, String, Locale) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to parse a Duration object from a string and a pattern that is allied to a DateTimeFormatter instance

parseTime(String, DateTimeFormatter) - Static method in class ch.rabanti.nanoxlsx4j.Helper

Method to parse a Duration object from a string and a DateTimeFormatter instance

parseVersion(int, int, int, int) - Static method in class ch.rabanti.nanoxlsx4j.Metadata

Method to parse a common version (major.minor.revision.build) into the compatible format (major.minor).

patternColor - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Fill.FillType

Color defines a pattern color

patternFill - Variable in class ch.rabanti.nanoxlsx4j.styles.Fill

pivotTables - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can use pivot tables if the worksheets is protected

R

Range - Class in ch.rabanti.nanoxlsx4j

Class representing a cell range (no getters and setters to simplify handling)

Range - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.AddressScope

The address represents a range of cells

Range(Address, Address) - Constructor for class ch.rabanti.nanoxlsx4j.Range

Constructor with addresses as arguments.

Range(String) - Constructor for class ch.rabanti.nanoxlsx4j.Range

Constructor with a range string as argument.

RangeException - Exception in ch.rabanti.nanoxlsx4j.exceptions

Class for exceptions regarding range incidents (e.g out-of-range)

RangeException() - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.RangeException

Default constructor

RangeException(String) - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.RangeException

Constructor with passed message

read() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XlsxReader

Reads the XLSX file from a file path or a file stream

read(InputStream) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.RelationshipReader

Reads the XML file form the passed stream and processes the relationship declaration table

read(InputStream) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.SharedStringsReader

Reads the XML file form the passed stream and processes the shared strings table

read(InputStream) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReader

Reads the XML file form the passed stream and processes the style information

read(InputStream) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader

Reads the XML file form the passed stream and processes the workbook information

read(InputStream) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Reads the XML file form the passed stream and processes the worksheet data

readAppData(InputStream) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Reads the XML file form the passed stream and processes the AppData section

readCoreData(InputStream) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.MetaDataReader

Reads the XML file form the passed stream and processes the Core section

ReaderUtils - Class in ch.rabanti.nanoxlsx4j.lowLevel

Static class with common util methods, used during reading XLSX files

ReaderUtils.IntParser - Class in ch.rabanti.nanoxlsx4j.lowLevel

Low-level parser class to handle nullable integers

recalculateAutoFilter() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Method to recalculate the auto filter (columns) of this worksheet.

recalculateColumns() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Method to recalculate the collection of columns of this worksheet.

RelationshipReader - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing a reader for relationship of XLSX files

RelationshipReader() - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.RelationshipReader

Default constructor

removeAllowedActionOnSheetProtection(Worksheet.SheetProtectionValue) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Removes an allowed action on the current worksheet or its cells

removeAutoFilter() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Removes auto filters from the worksheet

removeCell(int, int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Removes a previous inserted cell at the defined address

removeCell(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Removes a previous inserted cell at the defined address

removeHiddenColumn(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets a previously defined, hidden column as visible again

removeHiddenColumn(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets a previously defined, hidden column as visible again

removeHiddenRow(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets a previously defined, hidden row as visible again

removeMergedCells(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Removes the defined merged cell range

removeRowHeight(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Removes the defined, non-standard row height

removeSelectedCells() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Removes the cell selection of this worksheet

removeStyle() - Method in class ch.rabanti.nanoxlsx4j.Cell

Removes the assigned style from the cell

removeStyle(Style) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Deprecated.

This method has no direct impact on the generated file and is deprecated.

removeStyle(Style, boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Deprecated.

This method has no direct impact on the generated file and is deprecated.

removeStyle(String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Deprecated.

This method has no direct impact on the generated file and is deprecated.

removeStyle(String, boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Deprecated.

This method has no direct impact on the generated file and is deprecated.

removeWorksheet(int) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Removes the defined worksheet based on its index.

removeWorksheet(String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Removes the defined worksheet based on its name.

replaceCellValue(Object, Object) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Replaces all occurrences of 'oldValue' with 'newValue' and returns the number of replacements.

resetColumn(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Resets the defined column, if existing.

resetSplit() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Resets splitting of the worksheet into panes, as well as their freezing

resolveCellAddress(int, int) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Gets the address of a cell by the column and row number (zero based)

resolveCellAddress(int, int, Cell.AddressType) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Gets the address of a cell by the column and row number (zero based)

resolveCellCoordinate(String) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Gets the column and row number (zero based) of a cell by the address

resolveCellRange(String) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Resolves a cell range from the format like A1:B3 or AAD556:AAD1000

resolveCellType() - Method in class ch.rabanti.nanoxlsx4j.Cell

Method resets the Cell type and tries to find the actual type.

resolveColumn(String) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Gets the column number from the column address (A - XFD)

resolveColumnAddress(int) - Static method in class ch.rabanti.nanoxlsx4j.Cell

Gets the column address (A - XFD)

resolveEnclosedAddresses() - Method in class ch.rabanti.nanoxlsx4j.Range

Gets a list of all addresses between the start and end address

resolveMergedCells() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Method to resolve all merged cells in all worksheets.

resolveMergedCells() - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Method to resolve all merged cells of the worksheet.

right - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

Content will be aligned right

right() - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor one column to the right

right(int) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor the number of defined columns to the right

right(int, boolean) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor the number of defined columns to the right

Round(Address, int) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a round formula

Round(Worksheet, Address, int) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a round formula

RoundFormat() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the round format style

Row - Variable in class ch.rabanti.nanoxlsx4j.Address

Row of the address (zero-based)

RowToRow - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.CellDirection

The next cell will be on the same column (A1,A2,A3...)

S

s_double - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

double border

sanitizeWorksheetName(String, Workbook) - Static method in class ch.rabanti.nanoxlsx4j.Worksheet

Sanitizes a worksheet name

save() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XlsxWriter

Method to save the workbook

save() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Saves the workbook

saveAs(String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Saves the workbook with the defined name

saveAsStream(OutputStream) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XlsxWriter

saveAsStream(OutputStream) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Save the workbook to an output stream

scenarios - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can edit scenarios if the worksheets is protected

selectLockedCells - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can select locked cells if the worksheets is protected

selectUnlockedCells - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can select unlocked cells if the worksheets is protected

setActivePane(String) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

Parses and sets the active pane from a string value

setActiveStyle(Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the active style of the worksheet.

setAlignment(CellXf.TextBreakValue) - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Sets the text break options of the style

setApplication(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the application which created the workbook.

setApplicationVersion(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the version of the creation application.

setAutoFilter(boolean) - Method in class ch.rabanti.nanoxlsx4j.Column

Sets whether auto filter is enabled on the column

setAutoFilter(int, int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the column auto filter within the defined column range

setAutoFilter(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the column auto filter within the defined column range

setAutoFilterRange(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the column auto filter within the defined column range

setBackgroundColor(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Sets the background color of the fill.

setBold(boolean) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets the bold parameter of the font

setBorder(Border) - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Sets the border component of the style

setBottomColor(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the color code of the bottom border.

setBottomStyle(Border.StyleValue) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the style of bottom cell border

setCategory(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the category of the document.

setCellAddress(String) - Method in class ch.rabanti.nanoxlsx4j.Cell

Sets the combined cell Address as string in the format A1 - XFD1048576

setCellAddress2(Address) - Method in class ch.rabanti.nanoxlsx4j.Cell

Sets the combined cell address as class

setCellAddressType(Cell.AddressType) - Method in class ch.rabanti.nanoxlsx4j.Cell

Sets the optional address type that can be part of the cell address.

setCellLockedState(boolean, boolean) - Method in class ch.rabanti.nanoxlsx4j.Cell

Sets the lock state of the cell

setCellXf(CellXf) - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Sets the cellXf component of the style

setCharset(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets the charset of the Font (Default is empty)

setColor(String, Fill.FillType) - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Sets the color and the depending on fill type

setColorTheme(int) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets the font color theme (Default is 1)

setColorValue(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets the color code of the font color.

setColumnAddress(String) - Method in class ch.rabanti.nanoxlsx4j.Column

Sets the column address

setColumnDefaultStyle(int, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the default column style of the passed column number (zero-based)

setColumnDefaultStyle(String, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the default column style of the passed column address

setColumnNumber(int) - Method in class ch.rabanti.nanoxlsx4j.Cell

Sets the number of the column (zero-based)

setColumnWidth(int, float) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the width of the passed column number (zero-based)

setColumnWidth(String, float) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the width of the passed column address

setCompany(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the company owning the document.

setContentStatus(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the status of the document.

setCreator(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the creator of the workbook.

setCurrentCellAddress(int, int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Set the current cell address

setCurrentCellAddress(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Set the current cell address

setCurrentCellDirection(Worksheet.CellDirection) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the direction when using AddNextCell method

setCurrentColumnNumber(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the current column number (zero based)

setCurrentRowNumber(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the current row number (zero based)

setCurrentWorksheet(int) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets the current worksheet

setCurrentWorksheet(Worksheet) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Sets the worksheet accessed by the shortener

setCurrentWorksheet(Worksheet) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets the current worksheet

setCurrentWorksheet(String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets the current worksheet

setCustomFormatCode(String) - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Sets the raw custom format code in the notation of Excel.

setCustomFormatID(int) - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Sets the format number of the custom format.

setDataType(Cell.CellType) - Method in class ch.rabanti.nanoxlsx4j.Cell

Sets the type of the cell

setDateFormat(String) - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Sets the format if Date values are cast to Strings

setDateStyle(boolean) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer.StyleResult

Sets whether the style is to describe a date

setDefaultColumnStyle(Style) - Method in class ch.rabanti.nanoxlsx4j.Column

Sets the default style of the column

setDefaultColumnStyle(Style, boolean) - Method in class ch.rabanti.nanoxlsx4j.Column

Sets the default style of the column

setDefaultColumnWidth(float) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the default column width

setDefaultRowHeight(float) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the default Row height

setDescription(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the description of the document or comment about it

setDiagonalColor(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the color code of the diagonal lines.

setDiagonalDown(boolean) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the downwards diagonal line

setDiagonalStyle(Border.StyleValue) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the style of the diagonal lines

setDiagonalUp(boolean) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the upwards diagonal line

setEnforceDateTimesAsNumbers(boolean) - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Sets whether date or time values in the workbook are interpreted as numbers

setEnforceEmptyValuesAsString(boolean) - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Sets whether empty cells are of the type Empty or String

setEnforcePhoneticCharacterImport(boolean) - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Sets whether phonetic characters (like ruby characters / Furigana / Zhuyin fuhao) in strings are added in brackets after the transcribed symbols.

setEnforcingStartRowNumber(int) - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Sets the row number (zero-based) where enforcing rules are started to be applied.

setFamily(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets the font family (Default is 2 = Swiss)

setFilename(String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets the filename of the workbook

setFill(Fill) - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Sets the fill component of the style

setFont(Font) - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Sets the font component of the style

setForceApplyAlignment(boolean) - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Sets whether the applyAlignment property (used to merge cells) will be defined in the XF entry of the style.

setForegroundColor(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Sets the foreground color of the fill.

setFormat(NumberFormat.FormatNumber) - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat.NumberFormatEvaluation

Sets the evaluated Format

setFrozenState(String) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader.PaneDefinition

Sets the frozen state of the split window if defined

setGlobalEnforcingType(ImportOptions.GlobalType) - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Sets the global strategy to handle cell values.

setHidden(boolean) - Method in class ch.rabanti.nanoxlsx4j.Column

Sets whether the column is hidden or visible

setHidden(boolean) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader.WorksheetDefinition

Sets the hidden state of the worksheet

setHidden(boolean) - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Sets whether the hidden property (used for protection or hiding of cells) will be defined in the XF entry of the style.

setHidden(boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets whether the workbook is hidden

setHidden(boolean) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets whether the worksheet is hidden
If the worksheet is not part of a workbook, or the only one in the workbook, an exception will be thrown If the worksheet is the selected one, and attempted to set hidden, an exception will be thrown.

setHorizontalAlign(CellXf.HorizontalAlignValue) - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Sets the horizontal alignment of the style

setHorizontalSplit(float, Address, Worksheet.WorksheetPane) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the horizontal split of the worksheet into two panes.

setHorizontalSplit(int, boolean, Address, Worksheet.WorksheetPane) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the horizontal split of the worksheet into two panes.

setHyperlinkBase(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the hyperlink base of the document

setImportInProgress(boolean) - Method in class ch.rabanti.nanoxlsx4j.styles.StyleRepository

Sets the import state of the repository

setImportState(boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets the import state.

setIndent(int) - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Sets the indentation in case of left, right or distributed alignment.

setIndexedColor(int) - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Sets the indexed color (Default is 64)

setInternalID(Integer) - Method in class ch.rabanti.nanoxlsx4j.styles.AbstractStyle

Sets the internal ID for sorting purpose in the Excel style document

setItalic(boolean) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets the italic parameter of the font

setKeywords(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the keywords for the workbook.

setLeftColor(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the color code of the left border.

setLeftStyle(Border.StyleValue) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the style of left cell border

setLocked(boolean) - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Sets whether the locked property (used for locking / protection of cells or worksheets) will be defined in the XF entry of the style.

setManager(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the responsible manager of the document.

setName(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets the font name (Default is Calibri)

setName(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Sets the name of the style.

setNumber(int) - Method in class ch.rabanti.nanoxlsx4j.Column

Sets the column number

setNumber(NumberFormat.FormatNumber) - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Sets the format number.

setNumberFormat(NumberFormat) - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Sets the number format component of the style

setPatternFill(Fill.PatternValue) - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Sets the pattern type of the fill (Default is none)

setRange(NumberFormat.NumberFormatEvaluation.FormatRange) - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat.NumberFormatEvaluation

Sets the range of the evaluated number format

setRightColor(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the color code of the right border.

setRightStyle(Border.StyleValue) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the style of right cell border

setRowHeight(int, float) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the height of the passed row number (zero-based)

setRowNumber(int) - Method in class ch.rabanti.nanoxlsx4j.Cell

Sets the number of the row (zero-based)

setScheme(Font.SchemeValue) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets the Font scheme (Default is minor)

setSelectedCells(Address, Address) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Deprecated.

This method is a deprecated subset of the function AddSelectedCells. It will be removed in a future version

setSelectedCells(Range) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Deprecated.

This method is a deprecated subset of the function AddSelectedCells. It will be removed in a future version

setSelectedCells(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Deprecated.

This method is a deprecated subset of the function AddSelectedCells. It will be removed in a future version

setSelectedWorksheet(int) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets the selected worksheet in the output workbook
Note: This method does not set the current worksheet while design time.

setSelectedWorksheet(Worksheet) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets the selected worksheet in the output workbook
Note: This method does not set the current worksheet while design time.

setSelectedWorksheet(String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets the selected worksheet in the output workbook

setSheetID(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the internal ID of the worksheet

setSheetName(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the name of the sheet

setSheetName(String, boolean) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the name of the sheet

setSheetProtectionPassword(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets or removes the password for worksheet protection.

setSheetProtectionPasswordHash(String) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the encryption hash of the password, defined with Worksheet.setSheetProtectionPassword(String).

setShowingGridLines(boolean) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets whether grid lines are visible on the current worksheet.

setShowingRowColumnHeaders(boolean) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets whether the column and row headers are visible on the current worksheet.

setShowingRuler(boolean) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets whether a ruler is displayed over the column headers.

setSize(float) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets the Font size.

setSplit(Float, Float, Address, Worksheet.WorksheetPane) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the horizontal and vertical split of the worksheet into four panes.

setSplit(Integer, Integer, boolean, Address, Worksheet.WorksheetPane) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the horizontal and vertical split of the worksheet into four panes.

setStrike(boolean) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets whether the font is struck through

setStyle(Address, Address, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the passed style on the passed cell range, derived from a start and end address.

setStyle(Address, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the passed style on the passed (singular) cell address.

setStyle(Range, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the passed style on the passed cell range.

setStyle(Style) - Method in class ch.rabanti.nanoxlsx4j.Cell

Sets the style of the cell

setStyle(Style, boolean) - Method in class ch.rabanti.nanoxlsx4j.Cell

Sets the style of the cell

setStyle(String, Style) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the passed style on the passed address expression.

setSubject(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the subject of the workbook

setTemporalLocale(Locale) - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Sets the Locale instance, used to parse Duration objects from strings.

setTextDirection(CellXf.TextDirectionValue) - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Sets the direction of the text within the cell

setTextRotation(int) - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Sets the text rotation in degrees (from +90 to -90)

setTimeFormat(String) - Method in class ch.rabanti.nanoxlsx4j.ImportOptions

Sets the format if LocalTime values are cast to Strings.
Note that the parameter 'n' in a pattern is used to parse the number of days since 1900-01-01

setTimeStyle(boolean) - Method in class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer.StyleResult

Sets whether the style is to describe a time

setTitle(String) - Method in class ch.rabanti.nanoxlsx4j.Metadata

Sets the title of the workbook

setTopColor(String) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the color code of the top border.

setTopStyle(Border.StyleValue) - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Sets the style of top cell border

setUnderline(Font.UnderlineValue) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets the underline style of the font

setUseSheetProtection(boolean) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets whether the worksheet is protected

setValue(Object) - Method in class ch.rabanti.nanoxlsx4j.Cell

Sets the value of the cell (generic object type).

setVerticalAlign(CellXf.VerticalAlignValue) - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Sets the vertical alignment of the style

setVerticalAlign(Font.VerticalAlignValue) - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Sets the Alignment of the font (Default is none)

setVerticalSplit(float, Address, Worksheet.WorksheetPane) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the vertical split of the worksheet into two panes.

setVerticalSplit(int, boolean, Address, Worksheet.WorksheetPane) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the vertical split of the worksheet into two panes.

setViewType(Worksheet.SheetViewType) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets how the current worksheet is displayed in the spreadsheet application (Excel)

setWidth(float) - Method in class ch.rabanti.nanoxlsx4j.Column

Sets the width of the column

setWorkbookMetadata(Metadata) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets the metadata object of the workbook

setWorkbookProtection(boolean) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets whether the workbook is protected

setWorkbookProtection(boolean, boolean, boolean, String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets or removes the workbook protection.

setWorkbookProtectionPasswordHash(String) - Method in class ch.rabanti.nanoxlsx4j.Workbook

Sets the password hash for the protection, generated by Helper.generatePasswordHash(String)

setWorkbookReference(Workbook) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the Reference to the parent Workbook

setZoomFactor(int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets the zoom factor of the Worksheet.setViewType(SheetViewType) of the current worksheet.

setZoomFactor(Worksheet.SheetViewType, int) - Method in class ch.rabanti.nanoxlsx4j.Worksheet

Sets a zoom factor for a given Worksheet.SheetViewType.

SharedStringsReader - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing a reader for the shared strings table of XLSX files

SharedStringsReader(ImportOptions) - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.SharedStringsReader

Constructor with parameters

Shortener - Class in ch.rabanti.nanoxlsx4j

Class to provide access to the current worksheet with a shortened syntax
Note: The WS object can be null if the workbook was created without a worksheet.

Shortener(Workbook) - Constructor for class ch.rabanti.nanoxlsx4j.Shortener

Constructor with workbook reference

shrinkToFit - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.TextBreakValue

Text will be resized to fit the cell

singleAccounting - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Font.UnderlineValue

Text contains a single, accounting underline

SingleAddress - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.AddressScope

The address represents a single cell

size() - Method in class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNodeList

Gets the size of XML node list

slantDashDot - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

slant dash-dotted border

solid - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Fill.PatternValue

Solid fill (for colors)

sort - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

If selected, the user can sort cells if the worksheets is protected

StartAddress - Variable in class ch.rabanti.nanoxlsx4j.Range

Start address of the range

Strike() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the strike style

String - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.ColumnType

Cells are all imported as strings, using the ToString() method

STRING - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.CellType

Type for single characters and strings

Style - Class in ch.rabanti.nanoxlsx4j.styles

Class representing a style which consists of several components

Style() - Constructor for class ch.rabanti.nanoxlsx4j.styles.Style

Default constructor

Style(String) - Constructor for class ch.rabanti.nanoxlsx4j.styles.Style

Constructor with parameters

Style(String, int, boolean) - Constructor for class ch.rabanti.nanoxlsx4j.styles.Style

Constructor with parameters (internal use)

StyleException - Exception in ch.rabanti.nanoxlsx4j.exceptions

Class for exceptions regarding Styles

StyleException() - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.StyleException

Default constructor

StyleException(String) - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.StyleException

Constructor with passed message

StyleException(String, Exception) - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.StyleException

Constructor with passed message

StyleManager - Class in ch.rabanti.nanoxlsx4j.styles

Class representing a style manager to maintain all styles and its components of a workbook.
This class is only internally used to compose the style environment right before saving an XLSX file

StyleManager() - Constructor for class ch.rabanti.nanoxlsx4j.styles.StyleManager

Default constructor

StyleReader - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing a reader for style definitions of XLSX files

StyleReader() - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.StyleReader

Default constructor

StyleReaderContainer - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing a collection of pre-processed styles and their components.

StyleReaderContainer() - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer

StyleReaderContainer.StyleResult - Class in ch.rabanti.nanoxlsx4j.lowLevel

Result class regarding date and time styles

StyleRepository - Class in ch.rabanti.nanoxlsx4j.styles

Class to manage all styles at runtime, before writing XLSX files.

StyleResult(Style) - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.StyleReaderContainer.StyleResult

Constructor with definition of the result

subscript - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Font.VerticalAlignValue

Text will be rendered as subscript

Sum(Range) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a sum formula

Sum(Worksheet, Range) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Returns a cell with a sum formula

superscript - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Font.VerticalAlignValue

Text will be rendered as superscript

T

thick - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

thick border

thin - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

thin border

Time - Enum constant in enum class ch.rabanti.nanoxlsx4j.ImportOptions.ColumnType

Cells are tried to be imported as times (LocalTime)

TIME - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.CellType

Type for times (Note: Internally handled as OAdate, represented by LocalTime

TimeFormat() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the time format style

top - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.VerticalAlignValue

Content will be aligned on the top

topLeft - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.WorksheetPane

The pane is located in the top left of the split worksheet

topRight - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.WorksheetPane

The pane is located in the top right of the split worksheet

toString() - Method in class ch.rabanti.nanoxlsx4j.Address

Returns the address as string or "Illegal Address" in case of an exception

toString() - Method in class ch.rabanti.nanoxlsx4j.Range

Overwritten toString method

toString() - Method in class ch.rabanti.nanoxlsx4j.styles.Border

Override toString method

toString() - Method in class ch.rabanti.nanoxlsx4j.styles.CellXf

Override toString method

toString() - Method in class ch.rabanti.nanoxlsx4j.styles.Fill

Override toString method

toString() - Method in class ch.rabanti.nanoxlsx4j.styles.Font

Override toString method

toString() - Method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Override toString method

toString() - Method in class ch.rabanti.nanoxlsx4j.styles.Style

Override toString method

tryParse(String) - Static method in class ch.rabanti.nanoxlsx4j.lowLevel.ReaderUtils.IntParser

tryParseDecimal(String) - Static method in class ch.rabanti.nanoxlsx4j.lowLevel.ReaderUtils.IntParser

tryParseFormatNumber(int) - Static method in class ch.rabanti.nanoxlsx4j.styles.NumberFormat

Tries to parse registered format numbers.

Type - Variable in class ch.rabanti.nanoxlsx4j.Address

U

u_double - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Font.UnderlineValue

Text contains a double underline

u_single - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.Font.UnderlineValue

Text contains a single underline

undefined - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.NumberFormatEvaluation.FormatRange

Values between 0 and 164 that are not defined as enum value.

Underline() - Static method in class ch.rabanti.nanoxlsx4j.styles.BasicStyles

Gets the underline style

up() - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor one row up

up(int) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor the number of defined rows up

up(int, boolean) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Moves the cursor the number of defined rows up

V

validateColor(String, boolean) - Static method in class ch.rabanti.nanoxlsx4j.styles.Fill

Validates the passed string, whether it is a valid RGB value that can be used for Fills or Fonts

validateColor(String, boolean, boolean) - Static method in class ch.rabanti.nanoxlsx4j.styles.Fill

Validates the passed string, whether it is a valid RGB value that can be used for Fills or Fonts

validateWorksheets() - Method in class ch.rabanti.nanoxlsx4j.Workbook

Validates the worksheets regarding several conditions that must be met:
- At least one worksheet must be defined
- A hidden worksheet cannot be the selected one
- At least one worksheet must be visible
If one of the conditions is not met, an exception is thrown

value - Variable in class ch.rabanti.nanoxlsx4j.lowLevel.ReaderUtils.IntParser

value(Object) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Sets a value into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction)

value(Object, Style) - Method in class ch.rabanti.nanoxlsx4j.Shortener

Sets a value with style into the current cell and moves the cursor to the next cell (column or row depending on the defined cell direction)

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.Cell.AddressScope

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.Cell.AddressType

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.Cell.CellType

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.ImportOptions.ColumnType

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.ImportOptions.GlobalType

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.TextBreakValue

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.TextDirectionValue

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.VerticalAlignValue

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Fill.FillType

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Fill.PatternValue

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Font.SchemeValue

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Font.UnderlineValue

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Font.VerticalAlignValue

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.NumberFormatEvaluation.FormatRange

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.Worksheet.CellDirection

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetViewType

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

valueOf(String) - Static method in enum class ch.rabanti.nanoxlsx4j.Worksheet.WorksheetPane

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.Cell.AddressScope

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.Cell.AddressType

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.Cell.CellType

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.ImportOptions.ColumnType

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.ImportOptions.GlobalType

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Border.StyleValue

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.HorizontalAlignValue

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.TextBreakValue

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.TextDirectionValue

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.VerticalAlignValue

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Fill.FillType

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Fill.PatternValue

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Font.SchemeValue

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Font.UnderlineValue

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.Font.VerticalAlignValue

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.FormatNumber

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.styles.NumberFormat.NumberFormatEvaluation.FormatRange

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.Worksheet.CellDirection

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetViewType

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

values() - Static method in enum class ch.rabanti.nanoxlsx4j.Worksheet.WorksheetPane

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

Version - Class in ch.rabanti.nanoxlsx4j

Final class to provide metadata for the library

vertical - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.TextDirectionValue

Text direction is vertical

VLookup(Address, Range, int, boolean) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Function to generate a Vlookup as Excel function

VLookup(Worksheet, Address, Worksheet, Range, int, boolean) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Function to generate a Vlookup as Excel function

VLookup(Object, Range, int, boolean) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Function to generate a Vlookup as Excel function

VLookup(Object, Worksheet, Range, int, boolean) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas

Function to generate a Vlookup as Excel function

W

Workbook - Class in ch.rabanti.nanoxlsx4j

Class representing a workbook

Workbook() - Constructor for class ch.rabanti.nanoxlsx4j.Workbook

Default constructor.

Workbook(boolean) - Constructor for class ch.rabanti.nanoxlsx4j.Workbook

Constructor with additional parameter to create a default worksheet.

Workbook(String) - Constructor for class ch.rabanti.nanoxlsx4j.Workbook

Constructor with additional parameter to create a default worksheet with the specified name.

Workbook(String, String) - Constructor for class ch.rabanti.nanoxlsx4j.Workbook

Constructor with filename ant the name of the first worksheet.

Workbook(String, String, boolean) - Constructor for class ch.rabanti.nanoxlsx4j.Workbook

Constructor with filename ant the name of the first worksheet

WorkbookReader - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing a reader to decompile a workbook in an XLSX files

WorkbookReader() - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader

Default constructor

WorkbookReader.WorksheetDefinition - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class for worksheet Mata-data on import

Worksheet - Class in ch.rabanti.nanoxlsx4j

Class representing a worksheet of a workbook

Worksheet() - Constructor for class ch.rabanti.nanoxlsx4j.Worksheet

Default constructor.

Worksheet(String) - Constructor for class ch.rabanti.nanoxlsx4j.Worksheet

Constructor with worksheet name

Worksheet(String, int, Workbook) - Constructor for class ch.rabanti.nanoxlsx4j.Worksheet

Constructor with workbook reference, name and sheet ID

Worksheet.CellDirection - Enum Class in ch.rabanti.nanoxlsx4j

Enum to define the direction when using AddNextCell method

Worksheet.SheetProtectionValue - Enum Class in ch.rabanti.nanoxlsx4j

Enum to define the possible protection types when protecting a worksheet

Worksheet.SheetViewType - Enum Class in ch.rabanti.nanoxlsx4j

Enum to define how a worksheet is displayed in the spreadsheet application (Excel)

Worksheet.WorksheetPane - Enum Class in ch.rabanti.nanoxlsx4j

Enum to define the pane position or active pane in a slip worksheet

WorksheetDefinition(int, String, String) - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.WorkbookReader.WorksheetDefinition

Default constructor with parameters

WorksheetException - Exception in ch.rabanti.nanoxlsx4j.exceptions

Class for exceptions regarding worksheets

WorksheetException() - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.WorksheetException

Default constructor

WorksheetException(String) - Constructor for exception ch.rabanti.nanoxlsx4j.exceptions.WorksheetException

Constructor with passed message

WorksheetReader - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing a reader for worksheets of XLSX files

WorksheetReader(SharedStringsReader, StyleReaderContainer, ImportOptions) - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.WorksheetReader

Constructor with parameters and import options

WorksheetReader.PaneDefinition - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class represents information about pane splitting

wrapText - Enum constant in enum class ch.rabanti.nanoxlsx4j.styles.CellXf.TextBreakValue

Word wrap is active

WS - Variable in class ch.rabanti.nanoxlsx4j.Workbook

Shortener omits getter and setter to simplify the access (Can throw a WorksheetException if not defined)

X

XlsxReader - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing a reader to decompile XLSX files

XlsxReader(InputStream, ImportOptions) - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.XlsxReader

Constructor with stream and import options as parameter

XlsxReader(String, ImportOptions) - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.XlsxReader

Constructor with file path and import options as parameter

XlsxWriter - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class for low level handling (XML, formatting, preparing of packing)
This class is only for internal use.

XlsxWriter(Workbook) - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.XlsxWriter

Constructor with defined workbook object

XmlAttribute(String, String) - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlAttribute

Constructor with full declaration

XmlAttributeCollection() - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlAttributeCollection

XmlDocument - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class for simplified XML access without dealing with start and end elements or streams.

XmlDocument() - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument

XmlDocument.XmlAttribute - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing an XML attribute

XmlDocument.XmlAttributeCollection - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing an iterable list of XML attributes

XmlDocument.XmlNode - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing a single XML node with possible attributes and sub-nodes

XmlDocument.XmlNodeList - Class in ch.rabanti.nanoxlsx4j.lowLevel

Class representing an iterable list of XML nodes

XmlNode(String) - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNode

Constructor with definition of the node (tag) name

XmlNodeList() - Constructor for class ch.rabanti.nanoxlsx4j.lowLevel.XmlDocument.XmlNodeList

A B C D E F G H I J L M N O P R S T U V W X
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form