Index (PicoXLSX4j 2.6.0 API)

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

A

AbstractStyle - Class in ch.rabanti.picoxlsx4j.style: Class represents an abstract style component
AbstractStyle() - Constructor for class ch.rabanti.picoxlsx4j.style.AbstractStyle
addAllowedActionOnSheetProtection(Worksheet.SheetProtectionValue) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Method to add allowed actions if the worksheet is protected.
addCell(Object, int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds an object to the defined cell address.
addCell(Object, int, int, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds an object to the defined cell address.
addCell(Object, String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds an object to the defined cell address.
addCell(Object, String, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds an object to the defined cell address.
addCellFormula(String, int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds a cell formula as string to the defined cell address
addCellFormula(String, int, int, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds a cell formula as string to the defined cell address
addCellFormula(String, String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds a cell formula as string to the defined cell address
addCellFormula(String, String, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds a cell formula as string to the defined cell address
addCellRange(List<Object>, Address, Address) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds a list of object values to a defined cell range.
addCellRange(List<Object>, Address, Address, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds a list of object values to a defined cell range.
addCellRange(List<Object>, String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds a list of object values to a defined cell range.
addCellRange(List<Object>, String, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds a list of object values to a defined cell range.
addHiddenColumn(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the defined column as hidden
addHiddenColumn(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the defined column as hidden
addHiddenRow(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the defined row as hidden
addNextCell(Object) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds an object to the next cell position.
addNextCell(Object, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds an object to the next cell position.
addNextCellFormula(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds a formula as string to the next cell position
addNextCellFormula(String, Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Adds a formula as string to the next cell position
addPart(String, String, Document) - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer: Adds a Part to the file
addPart(String, String, Document, boolean) - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer: Adds a Part to the file
addRelationshipEntry(String, String) - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer.Relationship: Adds a relationship entry to the relationship
Address - Class in ch.rabanti.picoxlsx4j: C class representing a cell address (no getters and setters to simplify handling)
Address(int, int) - Constructor for class ch.rabanti.picoxlsx4j.Address: Constructor with with row and column as arguments
Address(int, int, Cell.AddressType) - Constructor for class ch.rabanti.picoxlsx4j.Address: Constructor with with row, column and address type as arguments
Address(String) - Constructor for class ch.rabanti.picoxlsx4j.Address: Constructor with address as string
Address(String, Cell.AddressType) - Constructor for class ch.rabanti.picoxlsx4j.Address: Constructor with address as string and address type.
addStyle(Style) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Adds a style component to the manager
addStyle(Style) - Method in class ch.rabanti.picoxlsx4j.Workbook: Adds a style to the style manager
addStyleComponent(Style, AbstractStyle) - Method in class ch.rabanti.picoxlsx4j.Workbook: Adds a style component to a style
addWorksheet(Worksheet) - Method in class ch.rabanti.picoxlsx4j.Workbook: Adding a new Worksheet.
addWorksheet(String) - Method in class ch.rabanti.picoxlsx4j.Workbook: Adding a new Worksheet.
addWorksheet(String, boolean) - Method in class ch.rabanti.picoxlsx4j.Workbook: Adding a new Worksheet with a sanitizing option.
append(AbstractStyle) - Method in class ch.rabanti.picoxlsx4j.style.Style: Appends the specified style parts to the current one.
AppendAnnotation - Annotation Type in ch.rabanti.picoxlsx4j.style: Annotation designated to control the copying of style properties
APPLICATIONNAME - Static variable in class ch.rabanti.picoxlsx4j.Version: Application name of the library
autoFilter - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can use auto filters if the worksheets is protected
Average(Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a average formula
Average(Worksheet, Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a average formula

B

backgroundColor - Variable in class ch.rabanti.picoxlsx4j.style.Fill
BasicFormulas - Class in ch.rabanti.picoxlsx4j: Class for handling of basic Excel formulas
BasicFormulas() - Constructor for class ch.rabanti.picoxlsx4j.BasicFormulas
BasicStyles - Class in ch.rabanti.picoxlsx4j.style: Factory class with the most important predefined styles
BasicStyles() - Constructor for class ch.rabanti.picoxlsx4j.style.BasicStyles
Bold() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the bold style
BoldItalic() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the bold and italic style
BOOL - ch.rabanti.picoxlsx4j.Cell.CellType: Type for boolean
Border - Class in ch.rabanti.picoxlsx4j.style: Class representing a Border entry.
Border() - Constructor for class ch.rabanti.picoxlsx4j.style.Border: Default constructor
Border.StyleValue - Enum in ch.rabanti.picoxlsx4j.style: Enum for the border style
BorderFrame() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the border frame style
BorderFrameHeader() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the border style for header cells
bottom - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue: Content will be aligned on the bottom (default)
buildRange(int, int, int, int) - Static method in class ch.rabanti.picoxlsx4j.Range: Method to build a range object from zwo column and two row numbers.
buildRange(Address, Address) - Static method in class ch.rabanti.picoxlsx4j.Range: Method to build a range object from two addresses.

C

calculateInternalRotation() - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Method to calculate the internal text rotation.
Ceil(Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a ceil formula
Ceil(Worksheet, Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a ceil formula
Cell - Class in ch.rabanti.picoxlsx4j: Class representing a cell of a worksheet
Cell() - Constructor for class ch.rabanti.picoxlsx4j.Cell: Default constructor.
Cell(Object, Cell.CellType) - Constructor for class ch.rabanti.picoxlsx4j.Cell: Constructor with value and cell type.
Cell(Object, Cell.CellType, int, int, Worksheet) - Constructor for class ch.rabanti.picoxlsx4j.Cell: Constructor with value, cell type, row number, column number and the link to a worksheet
Cell(Object, Cell.CellType, String) - Constructor for class ch.rabanti.picoxlsx4j.Cell: Constructor with value, cell type and address.
Cell.AddressType - Enum in ch.rabanti.picoxlsx4j: Enum for the referencing style of the address
Cell.CellType - Enum in ch.rabanti.picoxlsx4j: Enum defines the basic data types of a cell
CellXf - Class in ch.rabanti.picoxlsx4j.style: Class representing an XF entry.
CellXf() - Constructor for class ch.rabanti.picoxlsx4j.style.CellXf: Default constructor
CellXf.HorizontalAlignValue - Enum in ch.rabanti.picoxlsx4j.style: Enum for the horizontal alignment of a cell
CellXf.TextBreakValue - Enum in ch.rabanti.picoxlsx4j.style: Enum for text break options
CellXf.TextDirectionValue - Enum in ch.rabanti.picoxlsx4j.style: Enum for the general text alignment direction
CellXf.VerticalAlignValue - Enum in ch.rabanti.picoxlsx4j.style: Enum for the vertical alignment of a cell
center - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue: Content will be aligned in the center
center - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue: Content will be aligned in the center
centerContinuous - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue: Center continuous alignment
ch.rabanti.picoxlsx4j - package ch.rabanti.picoxlsx4j
ch.rabanti.picoxlsx4j.demo - package ch.rabanti.picoxlsx4j.demo
ch.rabanti.picoxlsx4j.demo.testing - package ch.rabanti.picoxlsx4j.demo.testing
ch.rabanti.picoxlsx4j.exception - package ch.rabanti.picoxlsx4j.exception
ch.rabanti.picoxlsx4j.lowLevel - package ch.rabanti.picoxlsx4j.lowLevel
ch.rabanti.picoxlsx4j.style - package ch.rabanti.picoxlsx4j.style
clearActiveStyle() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Clears the active style of the worksheet.
colorizedBackground(String) - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets a style to colorize the background of a cell
colorizedText(String) - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets a style to colorize the text of a cell
Column - Class in ch.rabanti.picoxlsx4j: Class representing a column of a worksheet
Column - Variable in class ch.rabanti.picoxlsx4j.Address: Column of the address (zero-based)
Column() - Constructor for class ch.rabanti.picoxlsx4j.Column: Default constructor
Column(int) - Constructor for class ch.rabanti.picoxlsx4j.Column: Constructor with column number
Column(String) - Constructor for class ch.rabanti.picoxlsx4j.Column: Constructor with column address
ColumnToColumn - ch.rabanti.picoxlsx4j.Worksheet.CellDirection: The next cell will be on the same row (A1,B1,C1...)
compareTo(Address) - Method in class ch.rabanti.picoxlsx4j.Address: Compares two addresses and returns whether the passed one is bigger or not.
compareTo(Cell) - Method in class ch.rabanti.picoxlsx4j.Cell: Implemented compareTo method
compareTo(AbstractStyle) - Method in class ch.rabanti.picoxlsx4j.style.AbstractStyle: Method to compare two objects for sorting purpose
convertArray(List<T>) - Static method in class ch.rabanti.picoxlsx4j.Cell: Converts a List of supported objects into a list of cells
copy() - Method in class ch.rabanti.picoxlsx4j.style.AbstractStyle: Abstract method to copy a component (dereferencing)
copy() - Method in class ch.rabanti.picoxlsx4j.style.Border: Method to copy the current object to a new one
copy() - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Method to copy the current object to a new one
copy() - Method in class ch.rabanti.picoxlsx4j.style.Fill: Method to copy the current object to a new one
copy() - Method in class ch.rabanti.picoxlsx4j.style.Font: Method to copy the current object to a new one
copy() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat: Method to copy the current object to a new one
copy() - Method in class ch.rabanti.picoxlsx4j.style.Style: Method to copy the current object to a new one
copyStyle() - Method in class ch.rabanti.picoxlsx4j.style.Style: Copies the current object as casted style
createBytesFromDocument(Document) - Static method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel: Method to convert an XML document to a byte array
createRelationship(String) - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer: Creates a relationship.
createXMLDocument(String, String) - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel: Creates a XML document from a string
custom - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Custom Format (ID 164 and higher)
CUSTOMFORMAT_START_NUMBER - Static variable in class ch.rabanti.picoxlsx4j.style.NumberFormat: Start ID for custom number formats as constant

D

darkGray - ch.rabanti.picoxlsx4j.style.Fill.PatternValue: Dark gray fill
dashDot - ch.rabanti.picoxlsx4j.style.Border.StyleValue: dash-dotted border
dashDotDot - ch.rabanti.picoxlsx4j.style.Border.StyleValue: dashed border with double-dots
dashed - ch.rabanti.picoxlsx4j.style.Border.StyleValue: dashed border
DATE - ch.rabanti.picoxlsx4j.Cell.CellType: Type for dates and times (Note: Dates before 1900-01-01 and after 9999-12-31 are not allowed)
DateFormat() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the date format style
dateStressTest(String, String, int) - Static method in class ch.rabanti.picoxlsx4j.demo.testing.Performance: Method to test and measure the performance if a huge number of date vales is inserted as new cells.
Default - ch.rabanti.picoxlsx4j.Cell.AddressType: Default behavior (e.g.
DEFAULT - ch.rabanti.picoxlsx4j.Cell.CellType: Default Type, not specified
DEFAULT_COLUMN_WIDTH - Static variable in class ch.rabanti.picoxlsx4j.Worksheet: Default column width as constant
DEFAULT_ROW_HEIGHT - Static variable in class ch.rabanti.picoxlsx4j.Worksheet: Default row height as constant
DEFAULTCOLOR - Static variable in class ch.rabanti.picoxlsx4j.style.Fill
DEFAULTFONT - Static variable in class ch.rabanti.picoxlsx4j.style.Font: Default font family as constant
deleteColumns - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can delete columns if the worksheets is protected
deleteRows - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can delete rows if the worksheets is protected
Disabled - ch.rabanti.picoxlsx4j.Worksheet.CellDirection: The address of the next cell will be not changed when adding a cell (for manual definition of cell addresses)
distributed - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue: Distributed alignment
distributed - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue: Distributed alignment
dotted - ch.rabanti.picoxlsx4j.style.Border.StyleValue: dotted border
DottedFill_0_125() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the special pattern fill style (for compatibility)
DoubleUnderline() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the double underline style
down() - Method in class ch.rabanti.picoxlsx4j.Shortener: Moves the cursor one row down
down(int) - Method in class ch.rabanti.picoxlsx4j.Shortener: Moves the cursor the number of defined rows down

E

EMPTY - ch.rabanti.picoxlsx4j.Cell.CellType: Type for empty cells.
EndAddress - Variable in class ch.rabanti.picoxlsx4j.Range: End address of the range
equals(AbstractStyle) - Method in class ch.rabanti.picoxlsx4j.style.AbstractStyle: Method to compare two objects for sorting purpose
equals(Object) - Method in class ch.rabanti.picoxlsx4j.Address: Compares two addresses whether they are equal.
equals(Object) - Method in class ch.rabanti.picoxlsx4j.Range: Overwritten equals method

F

fill - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue: Content will fill up the cell
Fill - Class in ch.rabanti.picoxlsx4j.style: Class representing a Fill (background) entry.
Fill() - Constructor for class ch.rabanti.picoxlsx4j.style.Fill: Default constructor
Fill(String, Fill.FillType) - Constructor for class ch.rabanti.picoxlsx4j.style.Fill: Constructor with color value and fill type
Fill(String, String) - Constructor for class ch.rabanti.picoxlsx4j.style.Fill: Constructor with foreground and background color
Fill.FillType - Enum in ch.rabanti.picoxlsx4j.style: Enum for the type of the fill
Fill.PatternValue - Enum in ch.rabanti.picoxlsx4j.style: Enum for the type of the fill pattern
fillColor - ch.rabanti.picoxlsx4j.style.Fill.FillType: Color defines a solid fill color
FixedColumn - ch.rabanti.picoxlsx4j.Cell.AddressType: Column of the address is fixed (e.g.
FixedRow - ch.rabanti.picoxlsx4j.Cell.AddressType: Row of the address is fixed (e.g.
FixedRowAndColumn - ch.rabanti.picoxlsx4j.Cell.AddressType: Row and column of the address is fixed (e.g.
Floor(Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a floor formula
Floor(Worksheet, Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a floor formula
font(String) - Static method in class ch.rabanti.picoxlsx4j.style.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, int) - Static method in class ch.rabanti.picoxlsx4j.style.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, int, boolean) - Static method in class ch.rabanti.picoxlsx4j.style.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, int, boolean, boolean) - Static method in class ch.rabanti.picoxlsx4j.style.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.picoxlsx4j.style: Class representing a Font entry.
Font() - Constructor for class ch.rabanti.picoxlsx4j.style.Font: Default constructor
Font.SchemeValue - Enum in ch.rabanti.picoxlsx4j.style: Enum for the font scheme
Font.VerticalAlignValue - Enum in ch.rabanti.picoxlsx4j.style: Enum for the vertical alignment of the text from base line
foregroundColor - Variable in class ch.rabanti.picoxlsx4j.style.Fill
format_1 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: 0
format_10 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: 0.00%
format_11 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: 0.00E+00
format_12 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: # ?
format_13 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: # ??
format_14 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: m/d/yyyy
format_15 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: d-mmm-yy
format_16 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: d-mmm
format_17 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: mmm-yy
format_18 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: mm AM/PM
format_19 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: h:mm:ss AM/PM
format_2 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: 0.00
format_20 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: h:mm
format_21 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: h:mm:ss
format_22 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: m/d/yyyy h:mm
format_3 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: #,##0
format_37 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: #,##0_);(#,##0)
format_38 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: #,##0_);[Red](#,##0)
format_39 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: #,##0.00_);(#,##0.00)
format_4 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: #,##0.00
format_40 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: #,##0.00_);[Red](#,##0.00)
format_45 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: mm:ss
format_46 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: [h]:mm:ss
format_47 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: mm:ss.0
format_48 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: ##0.0E+0
format_49 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: #
format_5 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: $#,##0_);($#,##0)
format_6 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: $#,##0_);[Red]($#,##0)
format_7 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: $#,##0.00_);($#,##0.00)
format_8 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: $#,##0.00_);[Red]($#,##0.00)
format_9 - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Format: 0%
formatCells - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can format cells if the worksheets is protected
formatColumns - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can format columns if the worksheets is protected
FormatException - Exception in ch.rabanti.picoxlsx4j.exception: Class for exceptions regarding format error incidents
FormatException() - Constructor for exception ch.rabanti.picoxlsx4j.exception.FormatException: Default constructor
FormatException(String, String) - Constructor for exception ch.rabanti.picoxlsx4j.exception.FormatException: Constructor with passed message
FormatException(String, String, Exception) - Constructor for exception ch.rabanti.picoxlsx4j.exception.FormatException: Constructor with passed message and inner
formatRows - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can format rows if the worksheets is protected
formula(String) - Method in class ch.rabanti.picoxlsx4j.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.picoxlsx4j.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 - ch.rabanti.picoxlsx4j.Cell.CellType: Type for Formulas (The cell will be handled differently)

G

general - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue: General alignment
getAddress() - Method in class ch.rabanti.picoxlsx4j.Address: Gets the address as string
getAlignment() - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Gets the text break options of the style
getApplication() - Method in class ch.rabanti.picoxlsx4j.Metadata: Gets the application which created the workbook.
getApplicationVersion() - Method in class ch.rabanti.picoxlsx4j.Metadata: Gets the version of the creation application.
getAutoFilterRange() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the range of the auto filter.
getBackgroundColor() - Method in class ch.rabanti.picoxlsx4j.style.Fill: Gets the Background color of the fill.
getBorder() - Method in class ch.rabanti.picoxlsx4j.style.Style: Gets the border component of the style
getBorderByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets a border by its hash
getBorders() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets all borders of the style manager
getBorderStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets the number of borders in the style manager
getBottomColor() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the color code of the bottom border.
getBottomStyle() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the style of bottom cell border
getCategory() - Method in class ch.rabanti.picoxlsx4j.Metadata: Gets the category of the document.
getCell(int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the cell of the specified column and row number (zero-based)
getCell(Address) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the cell of the specified address
getCellAddress() - Method in class ch.rabanti.picoxlsx4j.Cell: Gets the combined cell Address as string in the format A1 - XFD1048576
getCellAddress2() - Method in class ch.rabanti.picoxlsx4j.Cell: Gets the combined cell address as class
getCellRange(int, int, int, int) - Static method in class ch.rabanti.picoxlsx4j.Cell: Get a list of cell addresses from a cell range
getCellRange(Address, Address) - Static method in class ch.rabanti.picoxlsx4j.Cell: Get a list of cell addresses from a cell range
getCellRange(String) - Static method in class ch.rabanti.picoxlsx4j.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.picoxlsx4j.Cell: Get a list of cell addresses from a cell range
getCells() - Method in class ch.rabanti.picoxlsx4j.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.picoxlsx4j.Cell: Gets the assigned style of the cell
getCellXf() - Method in class ch.rabanti.picoxlsx4j.style.Style: Gets the cellXf component of the style
getCellXfByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets a cellXf by its hash
getCellXfs() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets all cellXfs of the style manager
getCellXfStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets the number of cellXfs in the style manager
getCharset() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the charset of the Font (Default is empty)
getColorTheme() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the font color theme (Default is 1)
getColorValue() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the Font color (default is empty)
getColumn() - Method in class ch.rabanti.picoxlsx4j.Address: Gets the column address (A - XFD)
getColumnAddress() - Method in class ch.rabanti.picoxlsx4j.Column: Gets the column address
getColumnNumber() - Method in class ch.rabanti.picoxlsx4j.Cell: Gets the number of the column (zero-based)
getColumns() - Method in class ch.rabanti.picoxlsx4j.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.picoxlsx4j.Metadata: Gets the company owning the document.
getContentStatus() - Method in class ch.rabanti.picoxlsx4j.Metadata: Gets the status of the document.
getCreator() - Method in class ch.rabanti.picoxlsx4j.Metadata: Gets the creator of the workbook.
getCurrentCellDirection() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the direction when using AddNextCell method
getCurrentColumnNumber() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the current column number (zero based)
getCurrentRowNumber() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the current row number (zero based)
getCurrentWorksheet() - Method in class ch.rabanti.picoxlsx4j.Workbook: Gets the current worksheet
getCustomFormatCode() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat: Gets the custom format code in the notation of Excel
getCustomFormatID() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat: Gets the format number of the custom format.
getDataType() - Method in class ch.rabanti.picoxlsx4j.Cell: Gets the type of the cell
getDefaultColumnWidth() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the default column width
getDefaultRowHeight() - Method in class ch.rabanti.picoxlsx4j.Worksheet
getDescription() - Method in class ch.rabanti.picoxlsx4j.Metadata: Gets the description of the document or comment about it
getDiagonalColor() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the color code of the diagonal lines.
getDiagonalStyle() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the style of the diagonal lines
getDocumentInterception() - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel: Gets whether XML documents are intercepted during creation
getExceptionTitle() - Method in exception ch.rabanti.picoxlsx4j.exception.FormatException: Gets the title of the exception
getExceptionTitle() - Method in exception ch.rabanti.picoxlsx4j.exception.IOException: Gets the title of the exception
getExceptionTitle() - Method in exception ch.rabanti.picoxlsx4j.exception.RangeException: Gets the title of the exception
getExceptionTitle() - Method in exception ch.rabanti.picoxlsx4j.exception.StyleException: Gets the title of the exception
getExceptionTitle() - Method in exception ch.rabanti.picoxlsx4j.exception.WorksheetException: Gets the title of the exception
getFamily() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the font family (Default is 2)
getFilename() - Method in class ch.rabanti.picoxlsx4j.Workbook: Gets the filename of the workbook
getFill() - Method in class ch.rabanti.picoxlsx4j.style.Style: Gets the fill component of the style
getFillByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets a font by its hash
getFills() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets all fills of the style manager
getFillStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets the number of fills in the style manager
getFont() - Method in class ch.rabanti.picoxlsx4j.style.Style: Gets the font component of the style
getFontByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets a font by its hash
getFonts() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets all fonts of the style manager
getFontStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets the number of fonts in the style manager
getForegroundColor() - Method in class ch.rabanti.picoxlsx4j.style.Fill: Gets the foreground color of the fill.
getHiddenRows() - Method in class ch.rabanti.picoxlsx4j.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.picoxlsx4j.style.CellXf: Gets the horizontal alignment of the style
getHyperlinkBase() - Method in class ch.rabanti.picoxlsx4j.Metadata: Gets the hyper-link base of the document
getIndexedColor() - Method in class ch.rabanti.picoxlsx4j.style.Fill: Gets the indexed color (Default is 64)
getInnerException() - Method in exception ch.rabanti.picoxlsx4j.exception.FormatException: Gets the inner exception
getInnerException() - Method in exception ch.rabanti.picoxlsx4j.exception.IOException: Gets the inner exception
getInterceptedDocuments() - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel: Gets the intercepted documents if interceptDocuments is set to true
getInternalID() - Method in class ch.rabanti.picoxlsx4j.style.AbstractStyle: Gets the internal ID for sorting purpose in the Excel style document
getKeywords() - Method in class ch.rabanti.picoxlsx4j.Metadata: Gets the keyword for the workbook.
getLastColumnNumber() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the last existing column number in the current worksheet (zero-based)
getLastRowNumber() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the last existing row number in the current worksheet (zero-based)
getLeftColor() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the color code of the left border.
getLeftStyle() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the style of left cell border
getManager() - Method in class ch.rabanti.picoxlsx4j.Metadata: Gets the responsible manager of the document.
getMergedCells() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the merged cells (only references) as map with the cell address as key and the range object as value
getName() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the font name (Default is Calibri)
getName() - Method in class ch.rabanti.picoxlsx4j.style.Style: Gets the name of the style.
getNumber() - Method in class ch.rabanti.picoxlsx4j.Column: Gets the column number
getNumber() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat: Gets the format number.
getNumberFormat() - Method in class ch.rabanti.picoxlsx4j.style.Style: Gets the number format component of the style
getNumberFormatByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets a number format by its hash
getNumberFormats() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets all number formats of the style manager
getNumberFormatStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets the number of number formats in the style manager
getOADateTimeString(Date) - Static method in class ch.rabanti.picoxlsx4j.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)and ends at December 31 9999.
getOATimeString(LocalTime) - Static method in class ch.rabanti.picoxlsx4j.Helper: Method to convert a time into the internal Excel time format (OAdate without days)
getPatternFill() - Method in class ch.rabanti.picoxlsx4j.style.Fill: Gets the pattern type of the fill (Default is none)
getPatternName(Fill.PatternValue) - Static method in class ch.rabanti.picoxlsx4j.style.Fill: Gets the pattern name from the enum
getRightColor() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the color code of the right border.
getRightStyle() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the style of right cell border
getRowHeights() - Method in class ch.rabanti.picoxlsx4j.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.picoxlsx4j.Cell: Gets the number of the row (zero-based)
getScheme() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the font scheme (Default is minor)
getSelectedCells() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the range of selected cells of this worksheet.
getSelectedWorksheet() - Method in class ch.rabanti.picoxlsx4j.Workbook: Gets the selected worksheet.
getSheetID() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the internal ID of the worksheet
getSheetName() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the name of the sheet
getSheetProtectionPassword() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the password used for sheet protection
getSheetProtectionValues() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the list of SheetProtectionValues.
getSize() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the font size.
getStyleByHash(int) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets a style by its hash
getStyleByName(String) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets a style by its name
getStyleManager() - Method in class ch.rabanti.picoxlsx4j.Workbook: Gets the style manager of this workbook
getStyleName(Border.StyleValue) - Static method in class ch.rabanti.picoxlsx4j.style.Border: Gets the border style name from the enum
getStyleNumber() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets the number of styles in the style manager
getStyles() - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Gets all styles of the style manager
getSubject() - Method in class ch.rabanti.picoxlsx4j.Metadata: Gets the subject of the workbook
getTextDirection() - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Gets the direction of the text within the cell
getTextRotation() - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Gets the text rotation in degrees (from +90 to -90)
getTitle() - Method in class ch.rabanti.picoxlsx4j.Metadata: Gets the title of the workbook
getTopColor() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the color code of the top border.
getTopStyle() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the style of top cell border
getValue() - Method in class ch.rabanti.picoxlsx4j.Cell: Gets the value of the cell (generic object type)
getValue() - Method in enum ch.rabanti.picoxlsx4j.style.Border.StyleValue
getValue() - Method in enum ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue
getValue() - Method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue
getValue() - Method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextDirectionValue
getValue() - Method in enum ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue
getValue() - Method in enum ch.rabanti.picoxlsx4j.style.Fill.FillType
getValue() - Method in enum ch.rabanti.picoxlsx4j.style.Fill.PatternValue
getValue() - Method in enum ch.rabanti.picoxlsx4j.style.Font.SchemeValue
getValue() - Method in enum ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue
getValue() - Method in enum ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Gets the numeric value of the enum entry
getVerticalAlign() - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Gets the vertical alignment of the style
getVerticalAlign() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the alignment of the font (Default is none)
getWidth() - Method in class ch.rabanti.picoxlsx4j.Column: Gets the width of the column
getWorkbookMetadata() - Method in class ch.rabanti.picoxlsx4j.Workbook: Gets the meta data object of the workbook
getWorkbookProtectionPassword() - Method in class ch.rabanti.picoxlsx4j.Workbook: Gets the password used for workbook protection
getWorkbookReference() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets the Reference to the parent Workbook
getWorksheetReference() - Method in class ch.rabanti.picoxlsx4j.Cell: Gets or sets the parent worksheet reference
getWorksheets() - Method in class ch.rabanti.picoxlsx4j.Workbook: Gets the list of worksheets in the workbook
goToNextColumn() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Moves the current position to the next column
goToNextColumn(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Moves the current position to the next column with the number of cells to move
goToNextRow() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Moves the current position to the next row (use for a new line)
goToNextRow(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Moves the current position to the next row with the number of cells to move (use for a new line)
gray0625 - ch.rabanti.picoxlsx4j.style.Fill.PatternValue: 6.25% gray fill
gray125 - ch.rabanti.picoxlsx4j.style.Fill.PatternValue: 12.5% gray fill

H

hair - ch.rabanti.picoxlsx4j.style.Border.StyleValue: hair border
hasAutoFilter() - Method in class ch.rabanti.picoxlsx4j.Column: Gets whether auto filter is enabled on the column
hasCell(int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets whether the specified address exists in the worksheet.
hasCell(Address) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets whether the specified address exists in the worksheet.
hashCode() - Method in class ch.rabanti.picoxlsx4j.style.Border: Override method to calculate the hash of this component
hashCode() - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Override method to calculate the hash of this component
hashCode() - Method in class ch.rabanti.picoxlsx4j.style.Fill: Override method to calculate the hash of this component
hashCode() - Method in class ch.rabanti.picoxlsx4j.style.Font: Override method to calculate the hash of this component
hashCode() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat: Override method to calculate the hash of this component
hashCode() - Method in class ch.rabanti.picoxlsx4j.style.Style: Override method to calculate the hash of this component
Helper - Class in ch.rabanti.picoxlsx4j: Class for shared used (static) methods
Helper() - Constructor for class ch.rabanti.picoxlsx4j.Helper
horizontal - ch.rabanti.picoxlsx4j.style.CellXf.TextDirectionValue: Text direction is horizontal (default)

I

ignore() - Method in annotation type ch.rabanti.picoxlsx4j.style.AppendAnnotation: Indicates whether the property annotated with the attribute is ignored during the copying of properties
indexedColor - Variable in class ch.rabanti.picoxlsx4j.style.Fill
insertColumns - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can insert columns if the worksheets is protected
insertHyperlinks - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can insert hyperlinks if the worksheets is protected
insertRows - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can insert rows if the worksheets is protected
IOException - Exception in ch.rabanti.picoxlsx4j.exception: Class for exceptions regarding stream or save error incidents
IOException() - Constructor for exception ch.rabanti.picoxlsx4j.exception.IOException: Default constructor
IOException(String, String) - Constructor for exception ch.rabanti.picoxlsx4j.exception.IOException: Constructor with passed message
IOException(String, String, Exception) - Constructor for exception ch.rabanti.picoxlsx4j.exception.IOException: Constructor with passed message and inner exception
isBold() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the bold parameter of the font
isCustomFormat() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat: Gets whether this object is a custom format
isDefaultFont() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets whether this object is the default font
isDiagonalDown() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the downwards diagonal line
isDiagonalUp() - Method in class ch.rabanti.picoxlsx4j.style.Border: Gets the upwards diagonal line
isDoubleUnderline() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the double-underline parameter of the font
isEmpty() - Method in class ch.rabanti.picoxlsx4j.style.Border: Method to determine whether the object has no values but the default values (means: is empty and must not be processed)
isForceApplyAlignment() - Method in class ch.rabanti.picoxlsx4j.style.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.picoxlsx4j.Column: Gets whether the column is hidden or visible
isHidden() - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Gets whether the hidden property (used for protection or hiding of cells) will be defined in the XF entry of the style.
isInternalStyle() - Method in class ch.rabanti.picoxlsx4j.style.Style: Gets whether the style is system internal
isItalic() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the italic parameter of the font
isLocked() - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Gets whether the locked property (used for locking / protection of cells or worksheets) will be defined in the XF entry of the style.
isNullOrEmpty(String) - Static method in class ch.rabanti.picoxlsx4j.Helper: Method of a string to check whether its reference is null or the content is empty
isStrike() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets whether the font is struck through
isStructureLockedIfProtected() - Method in class ch.rabanti.picoxlsx4j.Workbook: Gets whether the structure are locked if workbook is protected
isUnderline() - Method in class ch.rabanti.picoxlsx4j.style.Font: Gets the underline parameter of the font
isUseColorMRU() - Method in class ch.rabanti.picoxlsx4j.Metadata: If true, custom defined colors (in styles) will be added as recent colors (MRU)
isUseSheetProtection() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Gets whether the worksheet is protected
isWindowsLockedIfProtected() - Method in class ch.rabanti.picoxlsx4j.Workbook: Gets whether the windows are locked if workbook is protected
isWorkbookProtectionUsed() - Method in class ch.rabanti.picoxlsx4j.Workbook: Gets whether the workbook is protected
Italic() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the italic style

J

justify - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue: justify alignment
justify - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue: justify alignment

L

left - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue: Content will be aligned left
lightGray - ch.rabanti.picoxlsx4j.style.Fill.PatternValue: Light gray fill
LowLevel - Class in ch.rabanti.picoxlsx4j.lowLevel: Class for low level handling (XML, formatting, preparing of packing)
This class is only for internal use.
LowLevel(Workbook) - Constructor for class ch.rabanti.picoxlsx4j.lowLevel.LowLevel: Constructor with defined workbook object

M

main(String[]) - Static method in class ch.rabanti.picoxlsx4j.demo.PicoXLSX4j: Method to run all demos
major - ch.rabanti.picoxlsx4j.style.Font.SchemeValue: Font scheme is major
Max(Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a max formula
Max(Worksheet, Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a max formula
MAX_COLUMN_NUMBER - Static variable in class ch.rabanti.picoxlsx4j.Worksheet: Maximum column number (zero-based)
MAX_COLUMN_WIDTH - Static variable in class ch.rabanti.picoxlsx4j.Worksheet: Maximum column width as constant
MAX_OADATE_VALUE - Static variable in class ch.rabanti.picoxlsx4j.Helper: Maximum valid OAdate value (9999-12-31)
MAX_ROW_HEIGHT - Static variable in class ch.rabanti.picoxlsx4j.Worksheet: Maximum row height as constant
MAX_ROW_NUMBER - Static variable in class ch.rabanti.picoxlsx4j.Worksheet: Maximum row number (zero-based)
Median(Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a median formula
Median(Worksheet, Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a median formula
medium - ch.rabanti.picoxlsx4j.style.Border.StyleValue: medium border
mediumDashDot - ch.rabanti.picoxlsx4j.style.Border.StyleValue: medium dash-dotted border
mediumDashDotDot - ch.rabanti.picoxlsx4j.style.Border.StyleValue: medium-dashed border with double-dots
mediumDashed - ch.rabanti.picoxlsx4j.style.Border.StyleValue: medium dashed border
mediumGray - ch.rabanti.picoxlsx4j.style.Fill.PatternValue: Medium gray fill
mergeCells(Address, Address) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Merges the defined cell range
mergeCells(Range) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Merges the defined cell range
mergeCells(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Merges the defined cell range
MergeCellStyle() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the style used when merging cells
Metadata - Class in ch.rabanti.picoxlsx4j: Class representing the meta data of a workbook
Metadata() - Constructor for class ch.rabanti.picoxlsx4j.Metadata: Default constructor
Min(Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a min formula
Min(Worksheet, Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a min formula
MIN_COLUMN_NUMBER - Static variable in class ch.rabanti.picoxlsx4j.Worksheet: Minimum column number (zero-based)
MIN_COLUMN_WIDTH - Static variable in class ch.rabanti.picoxlsx4j.Worksheet: Minimum column width as constant
MIN_OADATE_VALUE - Static variable in class ch.rabanti.picoxlsx4j.Helper: Minimum valid OAdate value (1900-01-01)
MIN_ROW_HEIGHT - Static variable in class ch.rabanti.picoxlsx4j.Worksheet: Minimum row height as constant
MIN_ROW_NUMBER - Static variable in class ch.rabanti.picoxlsx4j.Worksheet: Minimum row number (zero-based)
minor - ch.rabanti.picoxlsx4j.style.Font.SchemeValue: Font scheme is minor (default)

N

nestedProperty() - Method in annotation type ch.rabanti.picoxlsx4j.style.AppendAnnotation: Indicates whether the property annotated with the attribute is a nested property.
none - ch.rabanti.picoxlsx4j.style.Border.StyleValue: no border
none - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue: No alignment.
none - ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue: Text will overflow in cell
none - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue: No alignment.
none - ch.rabanti.picoxlsx4j.style.Fill.PatternValue: No pattern (default)
none - ch.rabanti.picoxlsx4j.style.Font.SchemeValue: No Font scheme is used
none - ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue: Text will be rendered normal
none - ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: No format / Default
NUMBER - ch.rabanti.picoxlsx4j.Cell.CellType: Type for all numeric types (long, integer and float and double)
NumberFormat - Class in ch.rabanti.picoxlsx4j.style: Class representing a NumberFormat entry.
NumberFormat() - Constructor for class ch.rabanti.picoxlsx4j.style.NumberFormat: Default constructor
NumberFormat.FormatNumber - Enum in ch.rabanti.picoxlsx4j.style: Enum for predefined number formats

O

objects - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can edit objects if the worksheets is protected

P

pack(OutputStream) - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer: Method to pack the data into a XLSX file.
Packer - Class in ch.rabanti.picoxlsx4j.lowLevel: Class representing packer to compile XLSX files
Packer(LowLevel) - Constructor for class ch.rabanti.picoxlsx4j.lowLevel.Packer: Default constructor with parameter
Packer.Relationship - Class in ch.rabanti.picoxlsx4j.lowLevel: Nested class representing a relationship (MSXML)
parseVersion(int, int, int, int) - Static method in class ch.rabanti.picoxlsx4j.Metadata: Method to parse a common version (major.minor.revision.build) into the compatible format (major.minor).
patternColor - ch.rabanti.picoxlsx4j.style.Fill.FillType: Color defines a pattern color
patternFill - Variable in class ch.rabanti.picoxlsx4j.style.Fill
Performance - Class in ch.rabanti.picoxlsx4j.demo.testing: Class for performance tests
Performance() - Constructor for class ch.rabanti.picoxlsx4j.demo.testing.Performance
PicoXLSX4j - Class in ch.rabanti.picoxlsx4j.demo: Demo Program for PicoXLSX4j
PicoXLSX4j() - Constructor for class ch.rabanti.picoxlsx4j.demo.PicoXLSX4j
pivotTables - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can use pivot tables if the worksheets is protected

R

Range - Class in ch.rabanti.picoxlsx4j: Class representing a cell range (no getters and setters to simplify handling)
Range(Address, Address) - Constructor for class ch.rabanti.picoxlsx4j.Range: Constructor with with addresses as arguments
Range(String) - Constructor for class ch.rabanti.picoxlsx4j.Range: Constructor with a range string as argument
RangeException - Exception in ch.rabanti.picoxlsx4j.exception: Class for exceptions regarding range incidents (e.g out-of-range)
RangeException() - Constructor for exception ch.rabanti.picoxlsx4j.exception.RangeException: Default constructor
RangeException(String, String) - Constructor for exception ch.rabanti.picoxlsx4j.exception.RangeException: Constructor with passed message
recalculateAutoFilter() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Method to recalculate the auto filter (columns) of this worksheet.
recalculateColumns() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Method to recalculate the collection of columns of this worksheet.
removeAutoFilter() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Removes auto filters from the worksheet
removeCell(int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Removes a previous inserted cell at the defined address
removeCell(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Removes a previous inserted cell at the defined address
removeHiddenColumn(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets a previously defined, hidden column as visible again
removeHiddenColumn(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets a previously defined, hidden column as visible again
removeHiddenRow(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets a previously defined, hidden row as visible again
removeMergedCells(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Removes the defined merged cell range
removeSelectedCells() - Method in class ch.rabanti.picoxlsx4j.Worksheet: Removes the cell selection of this worksheet
removeStyle() - Method in class ch.rabanti.picoxlsx4j.Cell: Removes the assigned style from the cell
removeStyle(Style) - Method in class ch.rabanti.picoxlsx4j.Workbook: Removes the passed style from the style sheet
removeStyle(Style, boolean) - Method in class ch.rabanti.picoxlsx4j.Workbook: Removes the defined style from the style manager of the workbook
removeStyle(String) - Method in class ch.rabanti.picoxlsx4j.style.StyleManager: Removes a style and all its components from the style manager
removeStyle(String) - Method in class ch.rabanti.picoxlsx4j.Workbook: Removes the defined style from the style sheet of the workbook
removeStyle(String, boolean) - Method in class ch.rabanti.picoxlsx4j.Workbook: Removes the defined style from the style manager of the workbook
removeWorksheet(String) - Method in class ch.rabanti.picoxlsx4j.Workbook: Removes the defined worksheet
resolveCellAddress(int, int) - Static method in class ch.rabanti.picoxlsx4j.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.picoxlsx4j.Cell: Gets the address of a cell by the column and row number (zero based)
resolveCellCoordinate(String) - Static method in class ch.rabanti.picoxlsx4j.Cell: Gets the column and row number (zero based) of a cell by the address
resolveCellRange(String) - Static method in class ch.rabanti.picoxlsx4j.Cell: Resolves a cell range from the format like A1:B3 or AAD556:AAD1000
resolveCellType() - Method in class ch.rabanti.picoxlsx4j.Cell: Method resets the Cell type and tries to find the actual type.
resolveColumn(String) - Static method in class ch.rabanti.picoxlsx4j.Cell: Gets the column number from the column address (A - XFD)
resolveColumnAddress(int) - Static method in class ch.rabanti.picoxlsx4j.Cell: Gets the column address (A - XFD)
resolveMergedCells() - Method in class ch.rabanti.picoxlsx4j.Workbook: Method to resolve all merged cells in all worksheets.
right - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue: Content will be aligned right
right() - Method in class ch.rabanti.picoxlsx4j.Shortener: Moves the cursor one column to the right
right(int) - Method in class ch.rabanti.picoxlsx4j.Shortener: Moves the cursor the number of defined columns to the right
Round(Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a round formula
Round(Worksheet, Address, int) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a round formula
RoundFormat() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the round format style
Row - Variable in class ch.rabanti.picoxlsx4j.Address: Row of the address (zero-based)
RowToRow - ch.rabanti.picoxlsx4j.Worksheet.CellDirection: The next cell will be on the same column (A1,A2,A3...)

S

s_double - ch.rabanti.picoxlsx4j.style.Border.StyleValue: double border
sanitizeWorksheetName(String, Workbook) - Static method in class ch.rabanti.picoxlsx4j.Worksheet: Sanitizes a worksheet name
save() - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel: Method to save the workbook
save() - Method in class ch.rabanti.picoxlsx4j.Workbook: Saves the workbook
saveAs(String) - Method in class ch.rabanti.picoxlsx4j.Workbook: Saves the workbook with the defined name
saveAsStream(OutputStream) - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel
saveAsStream(OutputStream) - Method in class ch.rabanti.picoxlsx4j.Workbook: Save the workbook to a output stream
scenarios - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can edit scenarios if the worksheets is protected
selectLockedCells - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can select locked cells if the worksheets is protected
selectUnlockedCells - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can select unlocked cells if the worksheets is protected
setActiveStyle(Style) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the active style of the worksheet.
setAlignment(CellXf.TextBreakValue) - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Sets the text break options of the style
setApplication(String) - Method in class ch.rabanti.picoxlsx4j.Metadata: Sets the application which created the workbook.
setApplicationVersion(String) - Method in class ch.rabanti.picoxlsx4j.Metadata: Sets the version of the creation application.
setAutoFilter(boolean) - Method in class ch.rabanti.picoxlsx4j.Column: Sets whether auto filter is enabled on the column
setAutoFilter(int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the column auto filter within the defined column range
setAutoFilterRange(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the column auto filter within the defined column range
setBackgroundColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Fill: Sets the background color of the fill.
setBold(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the bold parameter of the font
setBorder(Border) - Method in class ch.rabanti.picoxlsx4j.style.Style: Sets the border component of the style
setBottomColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the color code of the bottom border.
setBottomStyle(Border.StyleValue) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the style of bottom cell border
setCategory(String) - Method in class ch.rabanti.picoxlsx4j.Metadata: Sets the category of the document.
setCellAddress(String) - Method in class ch.rabanti.picoxlsx4j.Cell: Sets the combined cell Address as string in the format A1 - XFD1048576
setCellAddress2(Address) - Method in class ch.rabanti.picoxlsx4j.Cell: Sets the combined cell address as class
setCellLockedState(boolean, boolean) - Method in class ch.rabanti.picoxlsx4j.Cell: Sets the lock state of the cell
setCellXf(CellXf) - Method in class ch.rabanti.picoxlsx4j.style.Style: Sets the cellXf component of the style
setCharset(String) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the charset of the Font (Default is empty)
setColor(String, Fill.FillType) - Method in class ch.rabanti.picoxlsx4j.style.Fill: Sets the color and the depending fill type
setColorTheme(int) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the font color theme (Default is 1)
setColorValue(String) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the font color (default is empty)
setColumnAddress(String) - Method in class ch.rabanti.picoxlsx4j.Column: Sets the column address
setColumnNumber(int) - Method in class ch.rabanti.picoxlsx4j.Cell: Sets the number of the column (zero-based)
setColumnWidth(int, float) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the width of the passed column number (zero-based)
setColumnWidth(String, float) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Set the current cell address
setCompany(String) - Method in class ch.rabanti.picoxlsx4j.Metadata: Sets the company owning the document.
setContentStatus(String) - Method in class ch.rabanti.picoxlsx4j.Metadata: Sets the status of the document.
setCreator(String) - Method in class ch.rabanti.picoxlsx4j.Metadata: Sets the creator of the workbook.
setCurrentCellAddress(int, int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Set the current cell address
setCurrentCellAddress(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Set the current cell address
setCurrentCellDirection(Worksheet.CellDirection) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the direction when using AddNextCell method
setCurrentColumnNumber(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the current column number (zero based)
setCurrentRowNumber(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the current row number (zero based)
setCurrentWorksheet(Worksheet) - Method in class ch.rabanti.picoxlsx4j.Shortener: Sets the worksheet accessed by the shortener
setCurrentWorksheet(String) - Method in class ch.rabanti.picoxlsx4j.Workbook: Sets the current worksheet
setCustomFormatCode(String) - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat: Sets the custom format code in the notation of Excel
setCustomFormatID(int) - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat: Sets the format number of the custom format.
setDataType(Cell.CellType) - Method in class ch.rabanti.picoxlsx4j.Cell: Sets the type of the cell
setDefaultColumnWidth(float) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the default column width
setDefaultRowHeight(float) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the default Row height
setDescription(String) - Method in class ch.rabanti.picoxlsx4j.Metadata: Sets the description of the document or comment about it
setDiagonalColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the color code of the diagonal lines.
setDiagonalDown(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the downwards diagonal line
setDiagonalStyle(Border.StyleValue) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the style of the diagonal lines
setDiagonalUp(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the upwards diagonal line
setDocumentInterception(boolean) - Method in class ch.rabanti.picoxlsx4j.lowLevel.LowLevel: Set whether XML documents are intercepted during creation
setDoubleUnderline(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the double-underline parameter of the font
setFamily(String) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the font family (Default is 2)
setFilename(String) - Method in class ch.rabanti.picoxlsx4j.Workbook: Sets the filename of the workbook
setFill(Fill) - Method in class ch.rabanti.picoxlsx4j.style.Style: Sets the fill component of the style
setFont(Font) - Method in class ch.rabanti.picoxlsx4j.style.Style: Sets the font component of the style
setForceApplyAlignment(boolean) - Method in class ch.rabanti.picoxlsx4j.style.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.picoxlsx4j.style.Fill: Sets the foreground color of the fill.
setHidden(boolean) - Method in class ch.rabanti.picoxlsx4j.Column: Sets whether the column is hidden or visible
setHidden(boolean) - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Sets whether the hidden property (used for protection or hiding of cells) will be defined in the XF entry of the style.
setHorizontalAlign(CellXf.HorizontalAlignValue) - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Sets the horizontal alignment of the style
setHyperlinkBase(String) - Method in class ch.rabanti.picoxlsx4j.Metadata: Sets the hyper-link base of the document
setIndexedColor(int) - Method in class ch.rabanti.picoxlsx4j.style.Fill: Sets the indexed color (Default is 64)
setInternalID(Integer) - Method in class ch.rabanti.picoxlsx4j.style.AbstractStyle: Sets the internal ID for sorting purpose in the Excel style document
setItalic(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the italic parameter of the font
setKeywords(String) - Method in class ch.rabanti.picoxlsx4j.Metadata: Sets the keywords for the workbook.
setLeftColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the color code of the left border.
setLeftStyle(Border.StyleValue) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the style of left cell border
setLocked(boolean) - Method in class ch.rabanti.picoxlsx4j.style.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.picoxlsx4j.Metadata: Sets the responsible manager of the document.
setName(String) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the font name (Default is Calibri)
setName(String) - Method in class ch.rabanti.picoxlsx4j.style.Style: Sets the name of the style.
setNumber(int) - Method in class ch.rabanti.picoxlsx4j.Column: Sets the column number
setNumber(NumberFormat.FormatNumber) - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat: Sets the format number.
setNumberFormat(NumberFormat) - Method in class ch.rabanti.picoxlsx4j.style.Style: Sets the number format component of the style
setPatternFill(Fill.PatternValue) - Method in class ch.rabanti.picoxlsx4j.style.Fill: Sets the pattern type of the fill (Default is none)
setRightColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the color code of the right border.
setRightStyle(Border.StyleValue) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the style of right cell border
setRowHeight(int, float) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the height of the passed row number (zero-based)
setRowNumber(int) - Method in class ch.rabanti.picoxlsx4j.Cell: Sets the number of the row (zero-based)
setScheme(Font.SchemeValue) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the Font scheme (Default is minor)
setSelectedCells(Address, Address) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the selected cells on this worksheet
setSelectedCells(Range) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the selected cells on this worksheet
setSelectedCells(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the selected cells on this worksheet
setSelectedWorksheet(int) - Method in class ch.rabanti.picoxlsx4j.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.picoxlsx4j.Workbook: Sets the selected worksheet in the output workbook
Note: This method does not set the current worksheet while design time.
setSheetID(int) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the internal ID of the worksheet
setSheetName(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the name of the sheet
setSheetName(String, boolean) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the name of the sheet
setSheetProtectionPassword(String) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets or removes the password for worksheet protection.
setSize(int) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the Font size.
setStrike(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets whether the font is struck through
setStyle(Style) - Method in class ch.rabanti.picoxlsx4j.Cell: Sets the style of the cell
setStyleManagerReference(StyleManager) - Method in class ch.rabanti.picoxlsx4j.style.Style: Sets the reference of the style manager
setSubject(String) - Method in class ch.rabanti.picoxlsx4j.Metadata: Sets the subject of the workbook
setTextDirection(CellXf.TextDirectionValue) - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Sets the direction of the text within the cell
setTextRotation(int) - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Sets the text rotation in degrees (from +90 to -90)
setTitle(String) - Method in class ch.rabanti.picoxlsx4j.Metadata: Sets the title of the workbook
setTopColor(String) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the color code of the top border.
setTopStyle(Border.StyleValue) - Method in class ch.rabanti.picoxlsx4j.style.Border: Sets the style of top cell border
setUnderline(boolean) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the underline parameter of the font
setUseColorMRU(boolean) - Method in class ch.rabanti.picoxlsx4j.Metadata: If true, custom defined colors (in styles) will be added as recent colors (MRU)
setUseSheetProtection(boolean) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets whether the worksheet is protected
setValue(Object) - Method in class ch.rabanti.picoxlsx4j.Cell: Sets the value of the cell (generic object type)
setVerticalAlign(CellXf.VerticalAlignValue) - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Sets the vertical alignment of the style
setVerticalAlign(Font.VerticalAlignValue) - Method in class ch.rabanti.picoxlsx4j.style.Font: Sets the Alignment of the font (Default is none)
setWidth(float) - Method in class ch.rabanti.picoxlsx4j.Column: Sets the width of the column
setWorkbookMetadata(Metadata) - Method in class ch.rabanti.picoxlsx4j.Workbook: Sets the meta data object of the workbook
setWorkbookProtection(boolean) - Method in class ch.rabanti.picoxlsx4j.Workbook: Sets whether the workbook is protected
setWorkbookProtection(boolean, boolean, boolean, String) - Method in class ch.rabanti.picoxlsx4j.Workbook: Sets or removes the workbook protection.
setWorkbookReference(Workbook) - Method in class ch.rabanti.picoxlsx4j.Worksheet: Sets the Reference to the parent Workbook
setWorksheetReference(Worksheet) - Method in class ch.rabanti.picoxlsx4j.Cell: Sets the parent worksheet reference
Shortener - Class in ch.rabanti.picoxlsx4j: 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() - Constructor for class ch.rabanti.picoxlsx4j.Shortener: Default constructor
shrinkToFit - ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue: Text will be resized to fit the cell
slantDashDot - ch.rabanti.picoxlsx4j.style.Border.StyleValue: slant dash-dotted border
solid - ch.rabanti.picoxlsx4j.style.Fill.PatternValue: Solid fill (for colors)
sort - ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: If selected, the user can sort cells if the worksheets is protected
StartAddress - Variable in class ch.rabanti.picoxlsx4j.Range: Start address of the range
Strike() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the strike style
STRING - ch.rabanti.picoxlsx4j.Cell.CellType: Type for single characters and strings
Style - Class in ch.rabanti.picoxlsx4j.style: Class representing a style which consists of several components
Style() - Constructor for class ch.rabanti.picoxlsx4j.style.Style: Default constructor
Style(String) - Constructor for class ch.rabanti.picoxlsx4j.style.Style: Constructor with parameters
Style(String, int, boolean) - Constructor for class ch.rabanti.picoxlsx4j.style.Style: Constructor with parameters (internal use)
StyleException - Exception in ch.rabanti.picoxlsx4j.exception: Class for exceptions regarding Styles
StyleException() - Constructor for exception ch.rabanti.picoxlsx4j.exception.StyleException: Default constructor
StyleException(String, String) - Constructor for exception ch.rabanti.picoxlsx4j.exception.StyleException: Constructor with passed message
StyleManager - Class in ch.rabanti.picoxlsx4j.style: Class representing a style manager to maintain all styles and its components of a workbook
StyleManager() - Constructor for class ch.rabanti.picoxlsx4j.style.StyleManager: Default constructor
subscript - ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue: Text will be rendered as subscript
Sum(Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a sum formula
Sum(Worksheet, Range) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Returns a cell with a sum formula
superscript - ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue: Text will be rendered as superscript

T

thick - ch.rabanti.picoxlsx4j.style.Border.StyleValue: thick border
thin - ch.rabanti.picoxlsx4j.style.Border.StyleValue: thin border
TIME - ch.rabanti.picoxlsx4j.Cell.CellType: Type for times (Note: Internally handled as OAdate, represented by LocalTime
TimeFormat() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the time format style
top - ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue: Content will be aligned on the top
toString() - Method in class ch.rabanti.picoxlsx4j.Address: Returns the address as string or "Illegal Address" in case of an exception
toString() - Method in class ch.rabanti.picoxlsx4j.Range: Overwritten toString method
toString() - Method in class ch.rabanti.picoxlsx4j.style.Border: Override toString method
toString() - Method in class ch.rabanti.picoxlsx4j.style.CellXf: Override toString method
toString() - Method in class ch.rabanti.picoxlsx4j.style.Fill: Override toString method
toString() - Method in class ch.rabanti.picoxlsx4j.style.Font: Override toString method
toString() - Method in class ch.rabanti.picoxlsx4j.style.NumberFormat: Override toString method
toString() - Method in class ch.rabanti.picoxlsx4j.style.Style: Override toString method
Type - Variable in class ch.rabanti.picoxlsx4j.Address

U

Underline() - Static method in class ch.rabanti.picoxlsx4j.style.BasicStyles: Gets the underline style

V

value(Object) - Method in class ch.rabanti.picoxlsx4j.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.picoxlsx4j.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 ch.rabanti.picoxlsx4j.Cell.AddressType: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.Cell.CellType: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.Border.StyleValue: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextDirectionValue: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.Fill.FillType: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.Fill.PatternValue: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.Font.SchemeValue: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.Worksheet.CellDirection: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: Returns the enum constant of this type with the specified name.
values() - Static method in enum ch.rabanti.picoxlsx4j.Cell.AddressType: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.Cell.CellType: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.style.Border.StyleValue: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.TextDirectionValue: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.style.CellXf.VerticalAlignValue: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.style.Fill.FillType: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.style.Fill.PatternValue: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.style.Font.SchemeValue: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.style.Font.VerticalAlignValue: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.Worksheet.CellDirection: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum ch.rabanti.picoxlsx4j.Worksheet.SheetProtectionValue: Returns an array containing the constants of this enum type, in the order they are declared.
Version - Class in ch.rabanti.picoxlsx4j: Final class to provide meta data for the library
Version() - Constructor for class ch.rabanti.picoxlsx4j.Version
VERSION - Static variable in class ch.rabanti.picoxlsx4j.Version: Version of the library
vertical - ch.rabanti.picoxlsx4j.style.CellXf.TextDirectionValue: Text direction is vertical
VLookup(Address, Range, int, boolean) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Function to generate a Vlookup as Excel function
VLookup(Worksheet, Address, Worksheet, Range, int, boolean) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Function to generate a Vlookup as Excel function
VLookup(Object, Range, int, boolean) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Function to generate a Vlookup as Excel function
VLookup(Object, Worksheet, Range, int, boolean) - Static method in class ch.rabanti.picoxlsx4j.BasicFormulas: Function to generate a Vlookup as Excel function

W

Workbook - Class in ch.rabanti.picoxlsx4j: Class representing a workbook
Workbook(boolean) - Constructor for class ch.rabanti.picoxlsx4j.Workbook: Constructor with additional parameter to create a default worksheet.
Workbook(String) - Constructor for class ch.rabanti.picoxlsx4j.Workbook: Constructor with additional parameter to create a default worksheet with the specified name.
Workbook(String, String) - Constructor for class ch.rabanti.picoxlsx4j.Workbook: Constructor with filename ant the name of the first worksheet
Workbook(String, String, boolean) - Constructor for class ch.rabanti.picoxlsx4j.Workbook: Constructor with filename ant the name of the first worksheet
Worksheet - Class in ch.rabanti.picoxlsx4j: Class representing a worksheet of a workbook
Worksheet() - Constructor for class ch.rabanti.picoxlsx4j.Worksheet: Default constructor.
Worksheet(Workbook) - Constructor for class ch.rabanti.picoxlsx4j.Worksheet: Constructor with workbook reference
Worksheet(String, int, Workbook) - Constructor for class ch.rabanti.picoxlsx4j.Worksheet: Constructor with workbook reference, name and sheet ID
Worksheet.CellDirection - Enum in ch.rabanti.picoxlsx4j: Enum to define the direction when using AddNextCell method
Worksheet.SheetProtectionValue - Enum in ch.rabanti.picoxlsx4j: Enum to define the possible protection types when protecting a worksheet
WorksheetException - Exception in ch.rabanti.picoxlsx4j.exception: Class for exceptions regarding worksheets
WorksheetException() - Constructor for exception ch.rabanti.picoxlsx4j.exception.WorksheetException: Default constructor
WorksheetException(String, String) - Constructor for exception ch.rabanti.picoxlsx4j.exception.WorksheetException: Constructor with passed message
wrapText - ch.rabanti.picoxlsx4j.style.CellXf.TextBreakValue: Word wrap is active
WS - Variable in class ch.rabanti.picoxlsx4j.Workbook: Shortener omits getter and setter to simplify the access (Can throw a WorksheetException if not defined)

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