Import Csv, JSON, or XML Data into a Spreadsheet file.

Import data into a spreadsheet worksheet. The supported format of the imported data file is Xml, JSON or CSV.

Import Data into Spreadsheet API

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.
regoin 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 Apose.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?

  • Importing large amounts of data into spreadsheet worksheet.
  • The imported data file format is Xml, JSON and CSV.

Why should you use the Import Data into Spreadsheet API?

  • Importing large amounts of data into spreadsheets.
  • Development can be quickly completed through the existing SDK.

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: