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

Packages that use Worksheet
Package Description

ch.rabanti.picoxlsx4j

Uses of Worksheet in ch.rabanti.picoxlsx4j

Methods in ch.rabanti.picoxlsx4j that return Worksheet
Modifier and Type	Method	Description
`Worksheet`	Workbook.`getCurrentWorksheet()`	Gets the current worksheet
`Worksheet`	Cell.`getWorksheetReference()`	Gets or sets the parent worksheet reference
`Worksheet`	Workbook.`setCurrentWorksheet(String name)`	Sets the current worksheet

Methods in ch.rabanti.picoxlsx4j that return types with arguments of type Worksheet
Modifier and Type	Method	Description
`List<Worksheet>`	Workbook.`getWorksheets()`	Gets the list of worksheets in the workbook

Methods in ch.rabanti.picoxlsx4j with parameters of type Worksheet
Modifier and Type	Method	Description
`void`	Workbook.`addWorksheet(Worksheet worksheet)`	Adding a new Worksheet.
`static Cell`	BasicFormulas.`Average(Worksheet target, Range range)`	Returns a cell with a average formula
`static Cell`	BasicFormulas.`Ceil(Worksheet target, Address address, int decimals)`	Returns a cell with a ceil formula
`static Cell`	BasicFormulas.`Floor(Worksheet target, Address address, int decimals)`	Returns a cell with a floor formula
`static Cell`	BasicFormulas.`Max(Worksheet target, Range range)`	Returns a cell with a max formula
`static Cell`	BasicFormulas.`Median(Worksheet target, Range range)`	Returns a cell with a median formula
`static Cell`	BasicFormulas.`Min(Worksheet target, Range range)`	Returns a cell with a min formula
`static Cell`	BasicFormulas.`Round(Worksheet target, Address address, int decimals)`	Returns a cell with a round formula
`void`	Shortener.`setCurrentWorksheet(Worksheet worksheet)`	Sets the worksheet accessed by the shortener
`void`	Workbook.`setSelectedWorksheet(Worksheet worksheet)`	Sets the selected worksheet in the output workbook Note: This method does not set the current worksheet while design time.
`void`	Cell.`setWorksheetReference(Worksheet reference)`	Sets the parent worksheet reference
`static Cell`	BasicFormulas.`Sum(Worksheet target, Range range)`	Returns a cell with a sum formula
`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, 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 Worksheet
Constructor	Description
`Cell(Object value, Cell.CellType type, int column, int row, Worksheet reference)`	Constructor with value, cell type, row number, column number and the link to a worksheet