[]
Document Solutions Data Viewer - v7.2.0 / WorkSheet
Represents a worksheet.
▸ getText(row
, col
): string
Retrieves formatted text in the cell based on the desired row and column index.
Sample
var text = worksheet.getText(0, 0);
Name | Type | Description |
---|---|---|
row |
number |
The row index. |
col |
number |
The column index. |
string
Returns the formatted text of the cell.
▸ getValue(row
, col
): any
Retrieves unformatted data from the specified cell based on the desired row and column index.
Sample
var value = worksheet.getValue(0, 0);
Name | Type | Description |
---|---|---|
row |
number |
The row index. |
col |
number |
The column index. |
any
Object Returns the value of the cell.
▸ getSelections(): undefined
| Range
[]
Retrieves the selections in the current sheet.
Sample
var selection = worksheet.getSelections();
undefined
| Range
[]
The type Range is stored in an Array.