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

Packages that use Range
Package Description

ch.rabanti.picoxlsx4j

Uses of Range in ch.rabanti.picoxlsx4j

Methods in ch.rabanti.picoxlsx4j that return Range
Modifier and Type	Method	Description
`static Range`	Range.`buildRange(int startColumn, int startRow, int endColumn, int endRow)`	Method to build a range object from zwo column and two row numbers.
`static Range`	Range.`buildRange(Address startAddress, Address endAddress)`	Method to build a range object from two addresses.
`Range`	Worksheet.`getAutoFilterRange()`	Gets the range of the auto filter.
`Range`	Worksheet.`getSelectedCells()`	Gets the range of selected cells of this worksheet.
`static Range`	Cell.`resolveCellRange(String range)`	Resolves a cell range from the format like A1:B3 or AAD556:AAD1000

Methods in ch.rabanti.picoxlsx4j that return types with arguments of type Range
Modifier and Type	Method	Description
`Map<String,Range>`	Worksheet.`getMergedCells()`	Gets the merged cells (only references) as map with the cell address as key and the range object as value

Methods in ch.rabanti.picoxlsx4j with parameters of type Range
Modifier and Type	Method	Description
`static Cell`	BasicFormulas.`Average(Range range)`	Returns a cell with a average formula
`static Cell`	BasicFormulas.`Average(Worksheet target, Range range)`	Returns a cell with a average formula
`static Cell`	BasicFormulas.`Max(Range range)`	Returns a cell with a max formula
`static Cell`	BasicFormulas.`Max(Worksheet target, Range range)`	Returns a cell with a max formula
`static Cell`	BasicFormulas.`Median(Range range)`	Returns a cell with a median formula
`static Cell`	BasicFormulas.`Median(Worksheet target, Range range)`	Returns a cell with a median formula
`String`	Worksheet.`mergeCells(Range cellRange)`	Merges the defined cell range
`static Cell`	BasicFormulas.`Min(Range range)`	Returns a cell with a min formula
`static Cell`	BasicFormulas.`Min(Worksheet target, Range range)`	Returns a cell with a min formula
`void`	Worksheet.`setSelectedCells(Range range)`	Sets the selected cells on this worksheet
`static Cell`	BasicFormulas.`Sum(Range range)`	Returns a cell with a sum formula
`static Cell`	BasicFormulas.`Sum(Worksheet target, Range range)`	Returns a cell with a sum formula
`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
`static Cell`	BasicFormulas.`VLookup(Object number, Range range, int columnIndex, boolean exactMatch)`	Function to generate a Vlookup as Excel function
`static Cell`	BasicFormulas.`VLookup(Object number, Worksheet rangeTarget, Range range, int columnIndex, boolean exactMatch)`	Function to generate a Vlookup as Excel function