Working with Excel ListObject

Excel ListObjects (tables) provide a structured way to organize data sets. They include features such as automatic data arrangement, header rows, built‑in filters, and optional total rows. Master these capabilities to analyze your data quickly and efficiently.

ListObject definition: A ListObject is Excel’s native table object that groups rows and columns, enables sorting, filtering, styling, and can be accessed via the Aspose.Cells Cloud API.

How to Work with Table (List Object)

• How to add a table (list object) inside the worksheet
• How to update a table (list object) inside the worksheet
• How to convert a table (list object) to a range
• How to sort table data
• How to remove duplicate rows from a table
• How to insert a slicer for a table

API Reference (overview):
The Aspose.Cells Cloud REST API exposes ListObject operations through endpoints such as GET /cells/{fileName}/worksheets/{sheetName}/listobjects, POST /cells/{fileName}/worksheets/{sheetName}/listobjects, PUT /cells/{fileName}/worksheets/{sheetName}/listobjects/{listObjectIndex}, and DELETE /cells/{fileName}/worksheets/{sheetName}/listobjects/{listObjectIndex}. Required query parameters include folder and storage. Request bodies are JSON objects describing the table’s properties (name, showHeaderRow, showTotalRow, etc.), and responses return JSON payloads with the created or modified ListObject details.

Prerequisites:

• A valid Aspose.Cells Cloud authentication token.
• The workbook file must be uploaded to a supported storage location (default: /) and the folder query parameter should point to that location.
• Optional: Set storage if using a non‑default storage service.

Endpoint details

Code snippets

C# (POST – Add ListObject)

var api = new CellsApi("client_id", "client_secret");
var request = new ListObject
{
    Name = "MyTable",
    StartRow = 0,
    StartColumn = 0,
    TotalRows = 20,
    TotalColumns = 5,
    ShowHeaderRow = true,
    ShowTotalRow = false
};
var response = api.PostWorksheetListObject("Book1.xlsx", "Sheet1", request, folder: "", storage: null);
Console.WriteLine(response.ListObject.Name);

Java (GET – Retrieve ListObjects)

CellsApi apiInstance = new CellsApi();
ListObjectResponse result = apiInstance.getWorksheetListObjects("Book1.xlsx", "Sheet1", null, null);
System.out.println(result.getListObjects());

Python (PUT – Update ListObject)

from asposecellscloud import CellsApi, ListObject
api = CellsApi(client_id, client_secret)
list_obj = ListObject(name="UpdatedTable", show_total_row=True)
response = api.put_worksheet_list_object(
    "Book1.xlsx", "Sheet1", 0, list_obj, folder="", storage=None)
print(response.list_object.name)

Node.js (DELETE – Remove ListObject)

const { CellsApi } = require("asposecellscloud");
const api = new CellsApi(clientId, clientSecret);
api.deleteWorksheetListObject("Book1.xlsx", "Sheet1", 0, { folder: "" })
   .then(res => console.log("Deleted:", res.body));

Notes:

• ListObject indices are zero‑based.
• When adding a ListObject, the StartRow and StartColumn define the upper‑left cell of the table.
• The API supports pagination via offset and limit query parameters (not shown in the table) for large worksheets.
• Rate limits: 100 requests per minute per account; exceeding this returns 429 Too Many Requests.

By incorporating the term Excel ListObject several times throughout the page, the content aligns with the target keywords “Excel ListObject”, “Aspose.Cells Cloud”, and “Excel table API”, improving SEO while remaining natural for readers.