Import Data Using Storage

This REST API imports data into an Excel file.

REST API

POST http://api.aspose.cloud/v3.0/cells/{name}/importdata

The request parameters are

Parameter Name	Type	Location	Description
name	string	path	The name of the Excel file.
folder	string	query	The folder path in the storage where the file resides.
storageName	string	query	The name of the storage service.
importData	object	body	JSON object that contains the data to be imported.

The import‑data options parameters are described in the reference link.

The OpenAPI Specification defines a publicly accessible programming interface and lets you perform REST interactions directly from a web browser.

You can use the cURL command‑line tool to access Aspose.Cells web services easily. The following example shows how to call the Cloud API with cURL.

Request

curl -v "http://api.aspose.cloud/v3.0/cells/Book1.xlsx/importdata" \
-X POST \
-D "{\"Data\":[1,2,4],\"DestinationWorksheet\":\"Sheet1\",\"FirstRow\":1,\"FirstColumn\":2,\"IsVertical\":true,\"IsInsert\":true,\"importDataType\":\"IntArray\"}" \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>"

Response

{
  "Code": 200,
  "Status": "OK"
}

Import Batch Data into Excel Worksheet