Import Json data into Excel
Contents
[
Hide
]
This REST API import json data into Excel work sheet.
RSET API
POST https://api.aspose.cloud/v3.0/cells/{name}/importjson
The important parameters are described in the following table:
ImportStringArrayOption
| Parameter Name | Type | Description |
|---|---|---|
| name | string | The workbook name |
| importJsonRequest | class | Import json request. |
| password | string | The password of workbook. |
| folder | string | Original workbook folder. |
| storageName | string | Storage name. |
| outPath | string | Output file path. |
| outStorageName | string | Storage name for output file. |
| checkExcelRestriction | string | Check Excel restriction. |
Example
{
"JsonFileSource": {
"FilePath": "string"
},
"ImportPosition": {
"SheetName": "string",
"RowIndex": 0,
"ColumnIndex": 0
},
"JsonContent": "string"
}
Cloud SDK Family
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: