Freeze Panes on an Excel Worksheet

This REST API sets freeze panes on an Excel worksheet.

REST API

PUT https://api.aspose.cloud/v3.0/cells/{name}/worksheets/{sheetName}/freezepanes

The request parameters are:

Parameter Name Type Location Description
name string path The name of the workbook file.
sheetName string path The name of the worksheet where panes are frozen.
row integer query Zero‑based index of the first unfrozen row.
column integer query Zero‑based index of the first unfrozen column.
frozenRows integer query Number of rows to freeze starting from the top.
frozenColumns integer query Number of columns to freeze starting from the left.
folder string query Folder path in storage where the workbook resides.
storageName string query Name of the storage service.

The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.

You can use the cURL command‑line tool to access Aspose.Cells web services easily. The following example shows how to make calls to the Cloud API with cURL.

Error‑Response

HTTP Status Code Message Example
400 Bad Request 400 Invalid parameters { "Code": 400, "Message": "Invalid frozenRows value" }
401 Unauthorized 401 Missing or invalid JWT token { "Code": 401, "Message": "Invalid access token" }
404 Not Found 404 Workbook or worksheet not found { "Code": 404, "Message": "File not found" }
500 Internal Server Error 500 Unexpected server error { "Code": 500, "Message": "Internal server error" }

Cloud SDK Family

Using an SDK is the best way to speed up development. An SDK handles low‑level details so you can 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 make calls to Aspose.Cells web services using various SDKs:

Unfreeze Panes on an Excel Worksheet