public interface Worksheet
Modifier and Type | Interface and Description |
---|---|
static class |
Worksheet.Visibility
Visibility attributes that can be applied.
|
Modifier and Type | Method and Description |
---|---|
void |
activate()
Activates the worksheet
|
String |
getBookName()
Returns the workbook name
|
String |
getName()
Returns the sheet name.
|
Range |
getRange(int row,
int column)
Returns the range proxy with the given row and column.
|
Range |
getRange(int row,
int column,
int numRows,
int numColumns)
Returns the range proxy with the given row and column with the given number
of the rows and columns
|
Range |
getRange(String a1Notation)
Returns the range proxy with the given A1 notation or R1C1 notation.
|
Spreadsheet |
getSpreadsheet()
Returns the spreadsheet which holds this worksheet.
|
Worksheet.Visibility |
getVisible()
Returns the visibility of this sheet.
|
CompletableFuture<Workbook> |
loadWorkbook()
Returns the remote workbook which holds this worksheet.
|
void |
rename(String newName)
Renames the sheet name.
|
void |
setVisible(Worksheet.Visibility visibility)
Sets the visibility of this sheet.
|
String getBookName()
Spreadsheet getSpreadsheet()
CompletableFuture<Workbook> loadWorkbook()
Range getRange(String a1Notation)
a1Notation
- Range getRange(int row, int column)
row
- the starting row index of the rangecolumn
- the starting column index of the range.Range getRange(int row, int column, int numRows, int numColumns)
row
- the starting row index of the rangecolumn
- the starting column index of the rangenumRows
- the number of the rowsnumColumns
- the number of the columnsvoid setVisible(Worksheet.Visibility visibility)
visibility
- either Worksheet.Visibility.Visible
, Worksheet.Visibility.Hidden
,
or Worksheet.Visibility.VeryHidden
Worksheet.Visibility getVisible()
String getName()
void rename(String newName)
newName
- void activate()
Copyright © 2017. All rights reserved.