Multi‑Source Data Integration Excel Platform – Aspose.Cells Cloud Automated Data Import and Transformation API.

Core Features

Multi-Format Data Support

CSV Data Import: Supports various delimiters and automatically detects encoding.
JSON Data Handling: Flattens complex JSON structures into Excel tables.
XML File Conversion: Maps node data to Excel row and column structure.

Import Data into Spreadsheet API Description

Web API

PUT https://api.aspose.cloud/v4.0/cells/import/data

Security and Authentication

The Aspose.Cells Cloud APIs are secure and require JWT token-based authentication.

-H "Authorization: Bearer {access_token}"

Request Parameters

Parameter Name	Type	Location	Description
datafile	File	FormData	The data file (CSV, JSON, or XML) to be imported.
spreadsheet	File	FormData	The target workbook that will receive the imported data.
worksheet	string	Query	Name of the worksheet where data will be placed.
startCell	string	Query	Top‑left cell (e.g., `A1`) that marks the start position for the import.
insert	bool	Query	`true` to insert rows; `false` to overwrite existing data.
convertNumericData	bool	Query	`true` to convert numeric strings to numbers during import.
splitter	string	Query	Single‑character CSV delimiter (default is `,`).
outPath	string	Query (optional)	Folder path where the updated workbook will be stored.
outStorageName	string	Query (optional)	Name of the storage location for the output file.
fontsLocation	string	Query (optional)	Path to a custom fonts folder, if required.
region	string	Query (optional)	Spreadsheet region configuration (e.g., `en-US`).
password	string	Query (optional)	Password for opening a protected workbook.

Response

[
  {
    "Name": "ResponseFile",
    "DataType": {
      "Identifier": "File",
      "Reference": "Stream"
    }
  }
]

Error Codes

Code	Message	When It Occurs
400	Bad Request	Invalid API URI or malformed request parameters.
401	Unauthorized	Missing/invalid access token or client credentials.
404	Not Found	The specified spreadsheet cannot be accessed.
500	Internal Server Error	An unexpected server‑side problem while processing.

Why You Should Use This API

Efficient data loading – Enables bulk import of large datasets directly into a workbook without creating intermediate files.
Broad SDK support – Provides client libraries for .NET, Java, PHP, Ruby, Node.js, Python, Go, and Perl, simplifying integration.
In‑memory processing – Performs transformations in memory, which reduces temporary storage requirements.

How to Use the Import Data into Spreadsheet API with SDKs

Prerequisites: To use this API you must have a valid Aspose Cloud account, the latest version of the Aspose.Cells Cloud SDK (v4.0 or newer), and an OAuth2 access token with the Cells.ReadWrite scope. The data files must not exceed the service‑specific size limits (typically 100 MB per file).

Notes / Limitations: The API supports up to 1 000 000 rows per import. Only comma is the default CSV delimiter; other single‑character delimiters can be specified via the splitter parameter. Large XML files may increase processing time.

For related operations such as exporting data or converting workbook formats, see the Export Data and Convert Workbook documentation.

Import Data into Spreadsheet API Specification

The Import Data into Spreadsheet API Specification provides a publicly accessible programming interface, allowing REST interactions directly from your web browser.

Use Aspose.Cells Cloud SDKs

Using the SDK is the fastest way to develop, as it abstracts away low‑level details, allowing you to import data into a spreadsheet worksheet with short code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples illustrate how to invoke Aspose.Cells web services using various SDKs:

Java

PHP

Ruby

Node.js

Python

Perl