Delete spreadsheet blank rows
Excel API : DeleteSpreadsheetBlankRows
Overview
Delete all blank rows that do not contain any data or other objects.
Function Description
This method removes rows from a spreadsheet that are completely empty, containing no data or objects. It scans through all sheets and identifies rows where every cell is empty. The operation is performed directly on the spreadsheet, ensuring that only rows with no content are deleted. This helps in cleaning up the spreadsheet and removing unnecessary blank rows, making the data more organized and easier to manage. Users should ensure that the spreadsheet is backed up before performing this operation, as deleted rows cannot be recovered.
API Endpoint
PUT http://api.aspose.cloud/v4.0/cells/delete/blank-rows
The request parameters of deleteSpreadsheetBlankRows API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
|---|---|---|---|
| Spreadsheet | File | FormData | Upload spreadsheet file. |
| outPath | String | Query | (Optional) The folder path where the workbook is stored. The default is null. |
| outStorageName | String | Query | Output file Storage Name. |
| regoin | String | Query | The spreadsheet region setting. |
| password | String | Query | The password for opening spreadsheet file. |
Response Structure
{
File
}
Error Handling
- 400 Bad Request: Invalid url.
- 401 Unauthorized: Authentication has failed, or no credentials were provided.
- 404 Not Found: Source file not accessible.
- 500 Server Error The spreadsheet has encountered an anomaly in obtaining data.
Usage Scenarios
Key Features and Benefits
- Blank Row Identification: This function identifies rows that do not contain any data or objects, ensuring thorough removal of unnecessary blank rows.
- Data Integrity: By removing only truly empty rows, it maintains the integrity of your dataset, preventing accidental data loss.
- Efficiency: Enhances the readability and usability of spreadsheets by eliminating extraneous blank rows.
- Usage scenarios: Ideal for cleaning large datasets where blank rows may interfere with data analysis or processing.
OpenAPI Specification
The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.
Excel API SDK
Using an SDK is the best way to speed up the development. An SDK takes care of low-level details and lets you 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: