Uses of Class
ch.rabanti.nanoxlsx4j.Range

Packages that use Range

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

Uses of Range in ch.rabanti.nanoxlsx4j

Methods in ch.rabanti.nanoxlsx4j that return Range

Modifier and Type	Method	Description
Range	Worksheet.getAutoFilterRange()	Gets the range of the auto filter.
Range	Worksheet.getSelectedCells()	Deprecated. This method is a deprecated subset of the function SelectedCellRanges.
static Range	Cell.resolveCellRange(String range)	Resolves a cell range from the format like A1:B3 or AAD556:AAD1000

Methods in ch.rabanti.nanoxlsx4j 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
List<Range>	Worksheet.getSelectedCellRanges()	Gets all ranges of selected cells of this worksheet.

Methods in ch.rabanti.nanoxlsx4j with parameters of type Range

Modifier and Type	Method	Description
void	Worksheet.addSelectedCells(Range range)	Adds a range to the selected cells on this worksheet
static Cell	BasicFormulas.Average(Range range)	Returns a cell with an average formula
static Cell	BasicFormulas.Average(Worksheet target, Range range)	Returns a cell with an 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)	Deprecated. This method is a deprecated subset of the function AddSelectedCells.
void	Worksheet.setStyle(Range cellRange, Style style)	Sets the passed style on the passed cell range.
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

Uses of Range in ch.rabanti.nanoxlsx4j.lowLevel

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

Modifier and Type	Method	Description
Range	WorksheetReader.getAutoFilterRange()	gets the auto filter range

Methods in ch.rabanti.nanoxlsx4j.lowLevel that return types with arguments of type Range

Modifier and Type	Method	Description
List<Range>	WorksheetReader.getMergedCells()	Gets a list of merged cells
List<Range>	WorksheetReader.getSelectedCells()	Gets the selected cell ranges (panes are currently not considered)