Get Last Cell of Excel Worksheet – Aspose.Cells Cloud API (v4.0)

Contents
[ ]

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

  • cURL Example.
  • Response Fields Overview
Field Type Description
Name string Address of the cell (e.g., F341).
Row integer Zero‑based row index.
Column integer Zero‑based column index.
Value string The cell’s displayed value.
Type string Data type of the cell (e.g., IsString).
Formula string Formula text if the cell contains a formula.
IsFormula bool Indicates whether the cell contains a formula.
IsMerged bool Indicates whether the cell is part of a merged range.
IsArrayHeader bool Indicates whether the cell is an array header.
IsInArray bool Indicates whether the cell belongs to an array.
IsErrorValue bool Indicates whether the cell contains an error value.
IsInTable bool Indicates whether the cell is inside a table.
IsStyleSet bool Indicates whether a style is applied to the cell.
HtmlString string HTML‑encoded representation of the cell’s value.
Style.link object Hyperlink to the style resource.
  • Cloud SDK Family

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:

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