Get End Cell of an Excel Worksheet – Aspose.Cells Cloud API v4.0

This REST API returns the endcell of an Excel worksheet when the cellOrMethodName parameter is set to endcell.

Overview
The Get Last Cell operation returns the address of the last used cell in a specified worksheet. It is useful for determining the effective data range of a sheet without scanning the entire workbook.

cURL Example.

Request

curl -X GET "https://api.aspose.cloud/v4.0/cells/myWorkbook.xlsx/worksheets/Sheet1/cells/endcell" \
     -H "Authorization: Bearer <your_access_token>" \
     -H "Content-Type: application/json" \
     -H "Accept: application/json"

Response

{
  "Cell": {
    "Name": "F341",
    "Row": 340,
    "Column": 5,
    "Value": "<More Info>",
    "Type": "IsString",
    "Formula": "=HYPERLINK(SUBSTITUTE(HelpURLTemplate,\"xxxxxxxxxx\",[Help Topic]),\"<More Info>\")",
    "IsFormula": false,
    "IsMerged": false,
    "IsArrayHeader": false,
    "IsInArray": false,
    "IsErrorValue": false,
    "IsInTable": false,
    "IsStyleSet": false,
    "HtmlString": "<Font Style=\"TEXT-DECORATION: underline;FONT-FAMILY: Calibri;FONT-SIZE: 11pt;COLOR: #000000;\">&lt;More Info&gt;</Font>",
    "Style": {
      "link": {
        "Href": "/style",
        "Rel": "self"
      }
    }
  },
  "Code": "200",
  "Status": "OK"
}

Parameters

Parameter	Type	Required	Description
`fileName`	string	Yes	Name of the Excel file stored in the cloud.
`worksheetName`	string	Yes	Name of the worksheet from which to retrieve the last cell.
`cellOrMethodName`	string	Yes	Must be set to `endcell` to invoke this operation.
`folder` (optional)	string	No	Cloud folder path where the workbook is located.
`storageName` (optional)	string	No	Name of the storage. If omitted, the default storage is used.

HTTP Status Codes

Code	Meaning	Description
200	OK	Filter applied successfully; response contains operation details.
400	Bad Request	Missing or invalid parameters (e.g., unsupported file type).
401	Unauthorized	Invalid or missing JWT token.
413	Payload Too Large	Uploaded file exceeds size limit.
500	Internal Server Error	Unexpected server error.

Use Aspose.Cells Cloud SDKs

Using an SDK is the best way to accelerate development. An SDK handles low‑level details, allowing you to focus on your project tasks. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples demonstrate how to call Aspose.Cells web services using various SDKs:

For further operations related to cell navigation, see the Get First Cell and Get Max Row topics.

Get First Cell (A1) from an Excel Worksheet Get MaxRow from an Excel Worksheet