public interface Workbook
Modifier and Type | Method and Description |
---|---|
CompletableFuture<Boolean> |
deleteWorksheet(String name) |
Object |
getActiveWorksheet()
Returns an Integer index or a String name of this active worksheet in this
spreadsheet client.
|
String |
getName()
Returns the name of this workbook.
|
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.
|
int |
getSheetsCount()
Returns the count of the worksheets in this workbook.
|
Spreadsheet |
getSpreadsheet()
Returns the spreadsheet client which holds this workbook.
|
void |
insertWorksheet()
Inserts a new sheet in the workbook, with a default name.
|
void |
insertWorksheet(int index)
Inserts a new sheet in the workbook at the given index, with a default name.
|
void |
insertWorksheet(String name)
Inserts a new sheet in the workbook, with a given name.
|
CompletableFuture<Worksheet> |
loadWorksheet()
Returns the active worksheet from the remote server.
|
CompletableFuture<Worksheet> |
loadWorksheet(int index)
Returns the worksheet by the given index from the remote server.
|
CompletableFuture<Worksheet> |
loadWorksheet(String name)
Returns the worksheet by the given name from the remote server.
|
void |
setActiveWorksheet(int index)
Sets the active worksheet with the given index.
|
void |
setActiveWorksheet(Object indexOrName)
Sets the active worksheet with the given name or index.
|
void |
setActiveWorksheet(String name)
Sets the active worksheet with the given name.
|
Spreadsheet getSpreadsheet()
CompletableFuture<Worksheet> loadWorksheet()
CompletableFuture<Worksheet> loadWorksheet(int index)
CompletableFuture<Worksheet> loadWorksheet(String name)
Object getActiveWorksheet()
void setActiveWorksheet(int index)
void setActiveWorksheet(String name)
void setActiveWorksheet(Object indexOrName)
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 columnsString getName()
int getSheetsCount()
void insertWorksheet()
void insertWorksheet(String name)
void insertWorksheet(int index)
CompletableFuture<Boolean> deleteWorksheet(String name)
Copyright © 2017. All rights reserved.