ajGetLastUsedCellAddress function
Description
The ajGetLastUsedCellAddress function is used to retrieve the last cell that contains the data or formatting on a worksheet. The last cell is defined as the bottom-right-most cell of a worksheet.
This function is mainly used in defining the end address of a class worksheet in the Related Worksheets section of Java API Class Worksheet and REST API Endpoint Group Worksheet.
Syntax
ajGetLastUsedCellAddress(worksheet_name)
| Argument Name | Description |
|---|---|
| worksheet_name (required) | Specify the worksheet to retrieve the last cell used. |
The function will return:
1) Content type: Address of the last cell used.
2) Method: Within a cell
Examples
Here are a few examples of ajGetLastUsedCellAddress function.
Example 1
The bottom-right-most cell in this example is J10.
Example 2
The bottom-right-most cell in this example is E6.
