PUT http://api.aspose.cloud/v4.0/cells/unpivot/table
Function Description
This API performs an unpivot operation on the specified table (ListObject), transforming column-based data into row-based data.The table header row is used for column names, and the first column is treated as row identifiers.The result is a three-column table: Row Header, Column Header, and Value.The unpivoted data is placed in a new worksheet with "_UnpivotTable" suffix, and a new table is created with the same style. ## Error Handling - 400 Bad Request: Invalid worksheet name or table index.- 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.
The request parameters of unpivotTable API are:
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
| :- | :- | :- |:- |
|Spreadsheet|File|FormData|Upload spreadsheet file.|
|worksheet|String|Query|The worksheet name containing the table to unpivot.|
|index|Integer|Query|The zero-based index of the table (ListObject) to unpivot.|
|skipEmptyValue|Boolean|Query|If true, empty cells are skipped in the output. Default is true.|
|outPath|String|Query|(Optional) The folder path where the workbook is stored. The default is null.|
|outStorageName|String|Query|Output file Storage Name.|
|region|String|Query|Spreadsheet region/language setting (e.g., en-US, fr-FR). Influences number formatting, date parsing, and locale‑specific behavior.|
|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.