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

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

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

Gets the size of the map

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

SortedMap - Class in ch.rabanti.picoxlsx4j.lowLevel

Class representing a reduced sorted map (key / value).

SortedMap() - Constructor for class ch.rabanti.picoxlsx4j.lowLevel.SortedMap

Default constructor

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

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