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

G

general - ch.rabanti.picoxlsx4j.style.CellXf.HorizontalAlignValue

General alignment

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

Gets the address as string

getAddress(int, int, String, Cell.AddressType, int, int, String, Cell.AddressType) - Method in class ch.rabanti.picoxlsx4j.AddressTest

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)

getColumn(int, int, String, Cell.AddressType, String) - Method in class ch.rabanti.picoxlsx4j.AddressTest

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

getIdList() - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer.Relationship

Gets the list of IDs (rId...)

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

getKeys() - Method in class ch.rabanti.picoxlsx4j.lowLevel.SortedMap

Gets the keys of the map as list

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

getRootFolder() - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer.Relationship

Gets the root folder of the relationship

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

getTargetList() - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer.Relationship

Gets the list of targets

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

getTypeList() - Method in class ch.rabanti.picoxlsx4j.lowLevel.Packer.Relationship

Gets the list of types

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

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