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.
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.