Index
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 with row and column as arguments.
- Address(int, int, Cell.AddressType) - Constructor for class ch.rabanti.nanoxlsx4j.Address
-
Constructor with 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
- 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 a average formula
- Average(Worksheet, Range) - Static method in class ch.rabanti.nanoxlsx4j.BasicFormulas
-
Returns a cell with a 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
- 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_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 - 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 base line
- 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
- 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). - 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 hyper-link 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)
- 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 meta data 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
- 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 availble 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
- 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
- insertRows - Enum constant in enum class ch.rabanti.nanoxlsx4j.Worksheet.SheetProtectionValue
-
If selected, the user can insert rows if the worksheets is protected
- 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
- 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
- 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 meta data 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)
- 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
- NUMBER - Enum constant in enum class ch.rabanti.nanoxlsx4j.Cell.CellType
-
Type for all numeric types (long, short, 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)
- 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 aDateTimeFormatter
instance - parseTime(String, DateTimeFormatter) - Static method in class ch.rabanti.nanoxlsx4j.Helper
-
Method to parse a
Duration
object from a string and aDateTimeFormatter
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 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
-
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.
- 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 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
- 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
-
Set the current cell 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
- 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 hyper-link 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)
. - 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.
- 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 meta data 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
- 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
- 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.WorksheetPane
-