Uses of Class
ch.rabanti.nanoxlsx4j.Address

Packages that use Address

Package	Description
ch.rabanti.nanoxlsx4j
ch.rabanti.nanoxlsx4j.lowLevel

Uses of Address in ch.rabanti.nanoxlsx4j

Fields in ch.rabanti.nanoxlsx4j declared as Address

Modifier and Type	Field	Description
final Address	Range.EndAddress	End address of the range
final Address	Range.StartAddress	Start address of the range

Methods in ch.rabanti.nanoxlsx4j that return Address

Modifier and Type	Method	Description
Address	Cell.getCellAddress2()	Gets the combined cell address as class
Address	Worksheet.getFirstCellAddress()	Gets the first existing cell in the current worksheet (bottom right)
Address	Worksheet.getFirstDataCellAddress()	Gets the first existing cell with data in the current worksheet (bottom right)
Address	Worksheet.getLastCellAddress()	Gets the last existing cell in the current worksheet (bottom right)
Address	Worksheet.getLastDataCellAddress()	Gets the last existing cell in the current worksheet (bottom right)
Address	Worksheet.getPaneSplitAddress()	Gets the split address for frozen panes or if pane split was defined in number of columns and / or rows. For vertical splits, only the column component is considered.
Address	Worksheet.getPaneSplitTopLeftCell()	Gets the Top Left cell address of the bottom right pane if applicable and splitting is applied. The column is only relevant for vertical split, whereas the row component is only relevant for a horizontal split. The value is nullable.
static Address	Cell.resolveCellCoordinate(String address)	Gets the column and row number (zero based) of a cell by the address

Methods in ch.rabanti.nanoxlsx4j 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
List<Address>	Range.resolveEnclosedAddresses()	Gets a list of all addresses between the start and end address

Methods in ch.rabanti.nanoxlsx4j 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.
void	Worksheet.addSelectedCells(Address startAddress, Address endAddress)	Adds a range to the selected cells on this worksheet
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.setHorizontalSplit(float topPaneHeight, Address topLeftCell, Worksheet.WorksheetPane activePane)	Sets the horizontal split of the worksheet into two panes.
void	Worksheet.setHorizontalSplit(int numberOfRowsFromTop, boolean freeze, Address topLeftCell, Worksheet.WorksheetPane activePane)	Sets the horizontal split of the worksheet into two panes.
void	Worksheet.setSelectedCells(Address startAddress, Address endAddress)	Deprecated. This method is a deprecated subset of the function AddSelectedCells.
void	Worksheet.setSplit(Float leftPaneWidth, Float topPaneHeight, Address topLeftCell, Worksheet.WorksheetPane activePane)	Sets the horizontal and vertical split of the worksheet into four panes.
void	Worksheet.setSplit(Integer numberOfColumnsFromLeft, Integer numberOfRowsFromTop, boolean freeze, Address topLeftCell, Worksheet.WorksheetPane activePane)	Sets the horizontal and vertical split of the worksheet into four panes.
void	Worksheet.setStyle(Address startAddress, Address endAddress, Style style)	Sets the passed style on the passed cell range, derived from a start and end address.
void	Worksheet.setStyle(Address address, Style style)	Sets the passed style on the passed (singular) cell address.
void	Worksheet.setVerticalSplit(float leftPaneWidth, Address topLeftCell, Worksheet.WorksheetPane activePane)	Sets the vertical split of the worksheet into two panes.
void	Worksheet.setVerticalSplit(int numberOfColumnsFromLeft, boolean freeze, Address topLeftCell, Worksheet.WorksheetPane activePane)	Sets the vertical split of the worksheet into two panes.
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.nanoxlsx4j with parameters of type Address

Modifier	Constructor	Description
	Cell(Object value, Cell.CellType type, Address address)	Constructor with value, cell type and address class.
	Range(Address start, Address end)	Constructor with addresses as arguments.

Uses of Address in ch.rabanti.nanoxlsx4j.lowLevel

Methods in ch.rabanti.nanoxlsx4j.lowLevel that return Address

Modifier and Type	Method	Description
Address	WorksheetReader.PaneDefinition.getTopLeftCell()	Gets the top Left cell address of the bottom right pane