Uses of Class
ch.rabanti.nanoxlsx4j.Worksheet

Packages that use Worksheet

Package	Description
ch.rabanti.nanoxlsx4j

Uses of Worksheet in ch.rabanti.nanoxlsx4j

Methods in ch.rabanti.nanoxlsx4j that return Worksheet

Modifier and Type	Method	Description
Worksheet	Worksheet.copy()	Creates a (dereferenced) deep copy of this worksheet
Worksheet	Workbook.copyWorksheetIntoThis(int sourceWorksheetIndex, String newWorksheetName)	Copies a worksheet of the current workbook by its index
Worksheet	Workbook.copyWorksheetIntoThis(int sourceWorksheetIndex, String newWorksheetName, boolean sanitizeSheetName)	Copies a worksheet of the current workbook by its index
Worksheet	Workbook.copyWorksheetIntoThis(Worksheet sourceWorksheet, String newWorksheetName)
Worksheet	Workbook.copyWorksheetIntoThis(Worksheet sourceWorksheet, String newWorksheetName, boolean sanitizeSheetName)	Copies a worksheet of any workbook into the current workbook
Worksheet	Workbook.copyWorksheetIntoThis(String sourceWorksheetName, String newWorksheetName)	Copies a worksheet of the current workbook by its name
Worksheet	Workbook.copyWorksheetIntoThis(String sourceWorksheetName, String newWorksheetName, boolean sanitizeSheetName)	Copies a worksheet of the current workbook by its name
Worksheet	Workbook.copyWorksheetTo(int sourceWorksheetIndex, String newWorksheetName, Workbook targetWorkbook)	Copies a worksheet of the current workbook by its index into another workbook
Worksheet	Workbook.copyWorksheetTo(int sourceWorksheetIndex, String newWorksheetName, Workbook targetWorkbook, boolean sanitizeSheetName)	Copies a worksheet of the current workbook by its index into another workbook
static Worksheet	Workbook.copyWorksheetTo(Worksheet sourceWorksheet, String newWorksheetName, Workbook targetWorkbook)	Copies a worksheet of any workbook into the another workbook
static Worksheet	Workbook.copyWorksheetTo(Worksheet sourceWorksheet, String newWorksheetName, Workbook targetWorkbook, boolean sanitizeSheetName)	Copies a worksheet of any workbook into the another workbook
Worksheet	Workbook.copyWorksheetTo(String sourceWorksheetName, String newWorksheetName, Workbook targetWorkbook)	Copies a worksheet of the current workbook by its name into another workbook
Worksheet	Workbook.copyWorksheetTo(String sourceWorksheetName, String newWorksheetName, Workbook targetWorkbook, boolean sanitizeSheetName)	Copies a worksheet of the current workbook by its name into another workbook
Worksheet	Workbook.getCurrentWorksheet()	Gets the current worksheet
Worksheet	Workbook.getWorksheet(int index)	Gets a worksheet from this workbook by index
Worksheet	Workbook.getWorksheet(String name)	Gets a worksheet from this workbook by name
Worksheet	Workbook.setCurrentWorksheet(int worksheetIndex)	Sets the current worksheet
Worksheet	Workbook.setCurrentWorksheet(String name)	Sets the current worksheet

Methods in ch.rabanti.nanoxlsx4j 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.nanoxlsx4j with parameters of type Worksheet

Modifier and Type	Method	Description
void	Workbook.addWorksheet(Worksheet worksheet)	Adding a new Worksheet.
void	Workbook.addWorksheet(Worksheet worksheet, boolean sanitizeSheetName)	Adding a new Worksheet.
static Cell	BasicFormulas.Average(Worksheet target, Range range)	Returns a cell with an average formula
static Cell	BasicFormulas.Ceil(Worksheet target, Address address, int decimals)	Returns a cell with a ceil formula
Worksheet	Workbook.copyWorksheetIntoThis(Worksheet sourceWorksheet, String newWorksheetName)
Worksheet	Workbook.copyWorksheetIntoThis(Worksheet sourceWorksheet, String newWorksheetName, boolean sanitizeSheetName)	Copies a worksheet of any workbook into the current workbook
static Worksheet	Workbook.copyWorksheetTo(Worksheet sourceWorksheet, String newWorksheetName, Workbook targetWorkbook)	Copies a worksheet of any workbook into the another workbook
static Worksheet	Workbook.copyWorksheetTo(Worksheet sourceWorksheet, String newWorksheetName, Workbook targetWorkbook, boolean sanitizeSheetName)	Copies a worksheet of any workbook into the another workbook
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.setCurrentWorksheet(Worksheet worksheet)	Sets the current worksheet
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.
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