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

Advanced Data Processing Capabilities

  • Intelligent Field Mapping: Automatically matches source fields to target columns
  • Data Transformation Rules: Supports data type conversion and formatting
  • Batch Processing Support: Allows importing multiple data files simultaneously

Import Data into Spreadsheet API Description

API Endpoint

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

Request Parameters:

Parameter Name Type Path/Query String/HTTPBody Description
datafile File FormData Upload the data file to be imported.
Spreadsheet File FormData Upload the target spreadsheet file.
worksheet String Query Specify the worksheet for importing data.
startcell String Query Specify the starting position for importing data.
insert Boolean Query Indicates whether to insert or overwrite the specified import data.
convertNumericData Boolean Query Specify whether to convert numerical data during import.
splitter String Query Specify the delimiter for CSV format.
outPath String Query (Optional) The folder path where the workbook is stored. The default is null.
outStorageName String Query Specify the output file storage name.
fontsLocation String Query Define custom fonts to be used.
region String Query Set the spreadsheet region configuration.
password String Query The password for opening the spreadsheet file.

Response

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

Error Codes

  • 400 Bad Request: Invalid Aspose.Cells Cloud API URI.
  • 401 Unauthorized: Invalid access token. Or invalid client id and secret.
  • 404 Not Found: The spreadsheet file not accessible.
  • 500 Server Error: The spreadsheet has encountered an anomaly in obtaining calculation data.

Where should we use the Import Data into Spreadsheet API?

  • Patient Data Management: Import XML data from electronic health records (EHR) into Excel analysis sheets.
  • Clinical Trial Data: Consolidate research data from various formats into Excel for statistical analysis
  • Medical Device Monitoring: Import device log data in real time into Excel maintenance schedules
  • Transaction Data Analysis: Import CSV data from trading systems into Excel risk models
  • Customer Profiling: Integrate multi-source customer data into Excel customer analysis sheets
  • Regulatory Report Generation: Automatically populate Excel templates required by regulators
  • Inventory Management: Import supply chain XML data into Excel inventory optimization models
  • Customer Behavior Analysis: Consolidate website analytics JSON data into Excel customer insight reports
  • Price Monitoring: Import competitor pricing data into Excel pricing strategy sheets
  • Academic Research Data: Import experimental device JSON data into Excel for statistical analysis
  • Student Performance Management: Import data from multiple systems into Excel grade analysis sheets
  • Research Fund Management: Import financial system data into Excel funding usage reports

Why should you use the Import Data into Spreadsheet API?

  • Importing large amounts of data into spreadsheets.
  • Developer-Friendly: Aspose.Cells Cloud offers SDK libraries in multiple languages, enabling quick development and comes with comprehensive documentation. Compared to building custom chart rendering solutions, this significantly reduces the development workload.
  • Cost-Effective: You can import data without first uploading the data file and template file, which saves storage space and reduces costs.

How to Use the Import Data into Spreadsheet API with SDKs

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 the 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: