Delete spreadsheet blank columns
Contents
[
Hide
]
Excel API : DeleteSpreadsheetBlankColumns
Delete all blank columns which do not contain any data.
Interface Details
Endpoint
PUT http://api.aspose.cloud/v4.0/cells/delete/blank-columns
Function Description
- Blank Column Identification: This function identifies columns that do not contain any data or objects, ensuring thorough removal of unnecessary blank columns.- Data Integrity: By removing only truly empty columns, it maintains the integrity of your dataset, preventing accidental data loss.- Usage:- Ideal for cleaning large datasets where blank columns may interfere with data analysis or processing.- Enhances the readability and usability of spreadsheets by eliminating extraneous blank columns.
The request parameters of deleteSpreadsheetBlankColumns 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 Description
{
File
}
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: