Import JSON Data into Excel
Contents
[
Hide
]
This REST API imports JSON data into an Excel worksheet.
REST API
POST https://api.aspose.cloud/v3.0/cells/{name}/importjson
Security and Authentication
The Aspose.Cells Cloud APIs are secure and require JWT token-based authentication.
Request Parameters
| Parameter Name | Location | Type | Description |
|---|---|---|---|
| name | Path | string | The name of the workbook file. |
| importJsonRequest | HTTP body | class | The request payload that contains JSON import details. |
| password | Query string | string | Password for opening the workbook (if protected). |
| folder | Query string | string | The folder that contains the original workbook. |
| storageName | Query string | string | The name of the storage where the workbook resides. |
| outPath | Query string | string | Path for the output file after import. If omitted, the updated workbook is returned in the response. |
| outStorageName | Query string | string | Storage name for the output file. |
| checkExcelRestriction | Query string | string | Flag indicating whether to enforce Excel‑specific restrictions (true/false). |
Example Request Body
{
"JsonFileSource": {
"FilePath": "string"
},
"ImportPosition": {
"SheetName": "string",
"RowIndex": 0,
"ColumnIndex": 0
},
"JsonContent": "string"
}
Response
A successful request returns HTTP 200 with a JSON payload similar to:
{
"Code": 200,
"Status": "OK"
}
Possible status codes:
| Code | Meaning |
|---|---|
| 200 | Import succeeded |
| 400 | Bad request – missing or invalid data |
| 401 | Unauthorized – invalid or missing token |
| 500 | Internal server error |
How to Use the PostWorkbookImportJson API with SDKs
PostWorkbookImportJson API Specification
The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.
Use Aspose.Cells Cloud SDKs
Using an SDK is the most efficient way to accelerate development. SDKs handle low‑level details, allowing you to focus on your business logic. For a complete list of Aspose.Cells Cloud SDKs, please visit the GitHub repository.
The following code examples demonstrate how to call Aspose.Cells web services using various SDKs: