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
All Classes All Packages
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)
All Classes All Packages


|
||||||||||
| PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |
See:
Description
| Interface Summary | |
|---|---|
| Attribute | Tags that are attached to the class file, field, method, or method body should implement this interface. |
| Host | A "taggable" object. |
| Tag | Represents a tag; these get attached to implementations of Host. |
| TagPrinter | Interface to allow display of tags. |
| Class Summary | |
|---|---|
| AbstractHost | This class is the reference implementation for the Host interface, which allows arbitrary taggable data to be stored with Soot objects. |
| AnnotationAnnotationElem | Represents the base class of annotation elements each annotation can have several elements for Java 1.5. |
| AnnotationArrayElem | Represents the base class of annotation elements each annotation can have several elements for Java 1.5. |
| AnnotationBooleanElem | |
| AnnotationClassElem | Represents the base class of annotation elements each annotation can have several elements for Java 1.5. |
| AnnotationConstants | Represents the annotation constants for Java 1.5. |
| AnnotationDefaultTag | Represents the annotation default attribute attatched method - could have at most one annotation default each for Java 1.5. |
| AnnotationDoubleElem | Represents the int annotation element each annotation can have several elements for Java 1.5. |
| AnnotationElem | Represents the base class of annotation elements each annotation can have several elements for Java 1.5. |
| AnnotationEnumElem | Represents the base class of annotation elements each annotation can have several elements for Java 1.5. |
| AnnotationFloatElem | Represents the int annotation element each annotation can have several elements for Java 1.5. |
| AnnotationIntElem | Represents the int annotation element each annotation can have several elements for Java 1.5. |
| AnnotationLongElem | Represents the int annotation element each annotation can have several elements for Java 1.5. |
| AnnotationStringElem | Represents the base class of annotation elements each annotation can have several elements for Java 1.5. |
| AnnotationTag | Represents the annotation attribute attatched to a class, method, field, method param - they could have many annotations each for Java 1.5. |
| Base64 | Provides encoding of raw bytes to base64-encoded characters, and decoding of base64 characters to raw bytes. |
| BytecodeOffsetTag | This class represents a tag for byte-code offset of instructions that correspond to Jimple statements. |
| CodeAttribute | A CodeAttribute object holds PC -> Tag pairs. |
| ColorTag | |
| ConstantValueTag | |
| DebugTypeTag | Represents the signature attribute used by fields, methods and classes for dealing with generics in Java 1.5. |
| DeprecatedTag | Represents the deprecated attribute used by fields, methods and classes |
| DoubleConstantValueTag | |
| EnclosingMethodTag | Represents the enclosing method attribute attatched to anon and inner classes to indicate the class and method it is declared in for Java 1.5. |
| EnclosingTag | Represents the synthetic attribute. |
| FirstTagAggregator | A tag aggregator that associates a tag with the first instruction that is tagged with it. |
| FloatConstantValueTag | |
| GenericAttribute | Represents a general attribute which can be attached to implementations of Host. |
| ImportantTagAggregator | A tag aggregator that associates a tag with the most important instruction that is tagged with it. |
| InnerClassAttribute | Represents an inner class attribute which can be attatched to implementations of Host. |
| InnerClassTag | |
| InnerClassTagAggregator | The aggregator for LineNumberTable attribute. |
| IntegerConstantValueTag | |
| JasminAttribute | This class must be extended by Attributes that can be emitted in Jasmin. |
| JimpleLineNumberTag | |
| KeyTag | |
| LineNumberTag | |
| LineNumberTagAggregator | The aggregator for LineNumberTable attribute. |
| LinkTag | Represents a tag that just has a string to be printed with the code. |
| LongConstantValueTag | |
| LoopInvariantTag | Represents a tag that just has a string to be printed with the code. |
| OuterClassTag | |
| ParamNamesTag | Represents a tag that just has a string to be printed with the code. |
| PositionTag | |
| QualifyingTag | Represents the synthetic attribute. |
| SignatureTag | Represents the signature attribute used by fields, methods and classes for dealing with generics in Java 1.5. |
| SourceFileTag | |
| SourceLineNumberTag | |
| SourceLnNamePosTag | |
| SourceLnPosTag | |
| SourcePositionTag | |
| StdTagPrinter | Default tag printer. |
| StringConstantValueTag | |
| StringTag | Represents a tag that just has a string to be printed with the code. |
| SyntheticParamTag | Represents the synthetic attribute. |
| SyntheticTag | Represents the synthetic attribute. |
| TagAggregator | Interface to aggregate tags of units. |
| TagManager | Utility functions for tags. |
| ThrowCreatedByCompilerTag | Represents a tag that just has a string to be printed with the code. |
| VisibilityAnnotationTag | Represents the visibility of an annotation attribute attatched to a class, field, method or method param (only one of these each) has one or more annotations for Java 1.5. |
| VisibilityParameterAnnotationTag | Represents the visibility of an annotation attribute attatched to a class, field, method or method param (only one of these each) has one or more annotations for Java 1.5. |
| Exception Summary | |
|---|---|
| AttributeValueException |
Classes supporting classfile annotation in Soot.
|
||||||||||
| PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |


Share a ride or get a ride to and from work with fellow Wiproites
Earn green points for redeemable benefits
Get Push Alerts and subscribe to events
Subscribe to alerts for rides created for your destinations. Get notified when someone is ready
to leave or is delayed. Create notifications to notify passengers with any messages.


Menu
Data Files
Visualization Options
Upload Shape files:
Select naming scheme:
Upload network data:
Upload network flow data:
Visualize
Colour & stroke Options:
Set base colour of the map:
Set the colour of the propagating line segments:
Stroke Options
Width of line segments (px):
2
Length of line segments (px):
50
Animation Options:
Total duration (s):
30
Duration of a single segment (s):
5
PropNets Visualizer
+


Share values
(Max shares per player: {{allowedLocomotivesByNumberOfPlayers[numPlayers]}})
Reset
Number of players ({{numPlayers}})
{{num}}
{{ playerRank(player) }}
{{player.name}}
{{ playerTotalScore(player) }} pts


Only fragments of this page (primarily the menu) are extracted and injected into other pages.
More content here.


{% extends 'base.html' %} {% block content %}
| School | # of placements | avg placement overall | avg placement of medals | placement score (# of placements / avg placement of medals) |
overall | rank |
|---|---|---|---|---|---|---|
| {{key}} | {% for v in value %}{{v}} | {% endfor %}
Average rank: {{student.avgRank.getAverage() | roundNum }}


Hi
Kim,
Your subscription is currently in
trial.
Do you want to upgrade your subscription to take full advantage of all our features?
Click on
"Upgrade"
to enter your credit card details and upgrade to a paid subscription.


Testcase for issue #XXX
Skin:
Fancytree project home
Link to this page
Example Browser
View source code


---
layout: post
title: 5/24 progress
date: '2014-05-24T22:11:00.000-06:00'
author: Jacob .
tags:
modified_time: '2014-05-24T22:11:26.397-06:00'
blogger_id: tag:blogger.com,1999:blog-6400085873105072120.post-5361241881951926112
blogger_orig_url: http://www.svlark.com/2014/05/524-progress.html
---
We made an offer and it was accepted on Friday for the Ericson 36C in Ft. Pierce. I don't guess she'll be the boat we take across an ocean, but she'd be a great boat to learn to cruise on and I think we'll have a great time with her.
We packed our kitchen box today which was the last of the boxes we hadn't at least started already. Tomorrow we'll move into suitcases and take all the clothes boxes and finish off the book and school boxes, and from there out, anything that's not against the east wall of the garage or in a suitcase upstairs, or in the safe cabinet in the kitchen is dumpster-eligible. Can you feel the freedom of it all?
24 days


We belive students learn by doing, so, our focus is to help students make practical use of their skills by building actual solutions
Resources
Our training experts have put together a cache of the best curated resources that could get you started while taking into account your individual learning needs and have you building cool projects in no time.
Hackathons
We encourage and organize hackathons in schools so students can learn more by doing from being a competitive driven space to being one where individuals irrespective of their educational background can come together learn and hack solutions in a welcoming and conducive environment.
Jobs
Get access to a suite of tools, APIs and resources when you attend our Hackathons. Jobs and Internship are also available for members. T&C applies.


The most Googled question about Hong Kong is whether or not it is in China. While officially it is, because it was leased to Britain in a 99-year deal that ended in 1997, it has its own money, passport and immigration channels, as well as its own legal system. In many ways, Hong Kong is its own entity. It's called the "world's most vertical city," because the 50,000-acre city has more buildings taller than 500 feet than any other city in the world.
OlaTravels is very easy-to-use. Just choose Destination, activities, date, enter your name and then click on search button to know the flight availabilty
OlaTravels is 100% reliable offering world class services to passenger on nice flight ranging boeing 200- boeing K800 C
OlaTravels can be accessed 247 all-round with our real time responsive costumer care to provide assistance always.
You can make payment via numerous channels including: PayPal, Credit Card, Interswitch, Wire transfers and cryptocurrencies like Bitcoin and Eutherium
Our success is to provide our Customers with 100% satisfactory services ranging hotel resevations, tours and cheap & reliable flight bokings.
Be the first to know about our new updates.


--- layout: archive title: Zulip Chat Archive permalink: /stream/113488-general/topic/cast.html ---
theorem cast_eq_of_heq : ∀ {α β : Sort u} {a : α} {b : β} (H : a == b), cast (type_eq_of_heq H) a = b | α _ a _ heq.rfl := rfl
I feel like cast
isn't used enough
here's a theorem I proved with cast
cast is used exactly as often as it should be, which is almost never
it's also not much different from eq.rec
@Mario Carneiro I run into cast
s all the time, but I would like to not use them, in accordance with your "almost never". However, I don't see any way to do that. For example, as soon as I define a few simple things, cast
s seem to become necessary really quickly:
variable vector: ℕ → Type variable mk_vec: Π n: ℕ, vector n variable consume_vec: Π x y, vector (x+y) → ℕ -- Of course, I could just swap the x,y arguments to consume_vec here but this -- doesn't seem to be possible very often with more complicated types. def something_useful := λ x y, consume_vec x y $ cast (by simp) (mk_vec (y + x)) -- At what point does this go wrong? To me, it seems like -- it goes wrong as soon as `vector` is defined the way it is here.
you are right... it goes wrong as soon as you state the problem like that
{% endraw %}Last updated: Apr 24 2020 at 19:02 UTC


All About Ben
Click my face to play a superfun quiz!
Education Summary
- HS: O'Fallon Township High School
- Undergrad: Saint Louis University
- Master's: Air Force Institute of Technology
Top Ten Fav things about Seattle
- Seafood
- Live Music
- Da Needle, Yo
- Rain
- Proximity To Nature
- Mt. Rainier looks like a mountain from a Star Wars planet
- Easy escape to Canada in case Trump starts nuclear war
- Hipster stuff
- Code Fellows
- The inability to come to terms with the loss of the Super Sonics


I am a development engineer at Amadeus S.A.S. - Sophia Antipolis, France.
I work on maintaining and improving efficient combinatorial algorithms for the company's main search engine.
As a researcher, I've always pursued novel directions by combining the theoretical work with the development of ad-hoc software prototypes and experimental toolsets.
My main interests are:


--- title: Initializing a new project keywords: fastai sidebar: home_sidebar nb_path: "nbs/00_Create Project.ipynb" ---
Assumes the following folder structure. It is important that logger files are named record_NN.h5
or record_NNN.h5
Note that, because the data format to communicate parameters used is a Pickle file, the filenames MUST be indexed at 0
SIMULATION_NAME/
parameter_grid.json #Describes each run
record_00.h5
record_01.h5
...
record_NN.h5 # Each logger run
sites.geojson # Polygons of the regions
From this information, you can specify an output_directory
where summaries will automatically be available for frontend analysis.
public/demo/projects/SIMULATION_NAME/
metadata.json
summary_000.csv
summary_001.csv
...
summary_NNN.csv
We are provided a parameter_grid.json
file that looks like the following:
{
"pub": [
0.0953169,
0.521456,
0.40569099999999997,
0.484659,
0.138482
],
"grocery": [
0.387384,
0.452953,
0.548852,
0.042028699999999995,
0.21261799999999997
], ...
}
(In this case, there are 5 runs and each run takes the parameter listed. This makes it tricky to do a grid search in the interface since many values will be distinct...)
We want to convert the provided parameter_grid.json
file into a metadata.json
file (e.g., below) that also includes some basic summary statistics from the project. This has the format:
{
"description": "Learning center comparison",
"parameters_varied": [
"indoor_beta",
"outdoor_beta",
"household_beta",
"learning_centers"
],
"run_parameters": {
"1": {
"learning_centers": false,
"household_beta": 0.2,
"indoor_beta": 0.45,
"outdoor_beta": 0.05
},
"2": {
"learning_centers": false,
"household_beta": 0.2,
"indoor_beta": 0.55,
"outdoor_beta": 0.05
}, ...
},
"all_regions": [
"CXB-201",
"CXB-202", ...
],
"all_timestamps": [
"2020-05-01",
"2020-05-02", ...
],
"all_fields": [
"currently_dead",
"currently_in_hospital_0_12", ...
],
"field_statistics": {
"n_infections_in_communal": {
"max": 132.0,
"min": 0.0
},
"recovered": {
"max": 1937.0,
"min": 0.0
}, ...
}
This involves restructuring the provided parameter grids and parsing the new summary_**.csvs
for extents of each field.
sites.geojson
This part is a bit simpler. We need to copy the sites.geojson
file from the provided records to the output directory.
Note: some geojson files may be very large. This is the place to reduce the size to something more reasonable yet still functional.
Also, some geojson files for this project have been annotated with SSID
as the 'property' that describes each region. Others are annotated with the region
key. We need to unify this interface


Growth and Inspiration through Volunteering and Education (GIVE), is a non-profit organization founded and run by high school students serving the Washington D.C. metropolitan area. Our mission is to cultivate leadership among youth, primarily through a free tutoring program, as well as other activities. GIVE invests in the next generation of change-makers by providing opportunities in the fields of education, empowerment, and leadership.
We work with different public facilities across the DC Metropolitan area to hold tutoring sessions, join our family!