Uses of Class ch.rabanti.picoxlsx4j.Address (PicoXLSX4j 2.6.0 API)

Packages that use Address
Package Description

ch.rabanti.picoxlsx4j

Uses of Address in ch.rabanti.picoxlsx4j

Fields in ch.rabanti.picoxlsx4j declared as Address
Modifier and Type	Field	Description
`Address`	Range.`EndAddress`	End address of the range
`Address`	Range.`StartAddress`	Start address of the range

Methods in ch.rabanti.picoxlsx4j that return Address
Modifier and Type	Method	Description
`Address`	Cell.`getCellAddress2()`	Gets the combined cell address as class
`static Address`	Cell.`resolveCellCoordinate(String address)`	Gets the column and row number (zero based) of a cell by the address

Methods in ch.rabanti.picoxlsx4j that return types with arguments of type Address
Modifier and Type	Method	Description
`static List<Address>`	Cell.`getCellRange(int startColumn, int startRow, int endColumn, int endRow)`	Get a list of cell addresses from a cell range
`static List<Address>`	Cell.`getCellRange(Address startAddress, Address endAddress)`	Get a list of cell addresses from a cell range
`static List<Address>`	Cell.`getCellRange(String range)`	Gets a list of cell addresses from a cell range (format A1:B3 or AAD556:AAD1000)
`static List<Address>`	Cell.`getCellRange(String startAddress, String endAddress)`	Get a list of cell addresses from a cell range

Methods in ch.rabanti.picoxlsx4j with parameters of type Address
Modifier and Type	Method	Description
`void`	Worksheet.`addCellRange(List<Object> values, Address startAddress, Address endAddress)`	Adds a list of object values to a defined cell range.
`void`	Worksheet.`addCellRange(List<Object> values, Address startAddress, Address endAddress, Style style)`	Adds a list of object values to a defined cell range.
`static Range`	Range.`buildRange(Address startAddress, Address endAddress)`	Method to build a range object from two addresses.
`static Cell`	BasicFormulas.`Ceil(Address address, int decimals)`	Returns a cell with a ceil formula
`static Cell`	BasicFormulas.`Ceil(Worksheet target, Address address, int decimals)`	Returns a cell with a ceil formula
`int`	Address.`compareTo(Address other)`	Compares two addresses and returns whether the passed one is bigger or not.
`static Cell`	BasicFormulas.`Floor(Address address, int decimals)`	Returns a cell with a floor formula
`static Cell`	BasicFormulas.`Floor(Worksheet target, Address address, int decimals)`	Returns a cell with a floor formula
`Cell`	Worksheet.`getCell(Address address)`	Gets the cell of the specified address
`static List<Address>`	Cell.`getCellRange(Address startAddress, Address endAddress)`	Get a list of cell addresses from a cell range
`boolean`	Worksheet.`hasCell(Address address)`	Gets whether the specified address exists in the worksheet.
`String`	Worksheet.`mergeCells(Address startAddress, Address endAddress)`	Merges the defined cell range
`static Cell`	BasicFormulas.`Round(Address address, int decimals)`	Returns a cell with a round formula
`static Cell`	BasicFormulas.`Round(Worksheet target, Address address, int decimals)`	Returns a cell with a round formula
`void`	Cell.`setCellAddress2(Address address)`	Sets the combined cell address as class
`void`	Worksheet.`setSelectedCells(Address startAddress, Address endAddress)`	Sets the selected cells on this worksheet
`static Cell`	BasicFormulas.`VLookup(Address address, Range range, int columnIndex, boolean exactMatch)`	Function to generate a Vlookup as Excel function
`static Cell`	BasicFormulas.`VLookup(Worksheet queryTarget, Address address, Worksheet rangeTarget, Range range, int columnIndex, boolean exactMatch)`	Function to generate a Vlookup as Excel function

Constructors in ch.rabanti.picoxlsx4j with parameters of type Address
Constructor	Description
`Range(Address start, Address end)`	Constructor with with addresses as arguments