Import Data into Excel files and Export data from Excel files.

Aspose.Cells Cloud API supports importing data from a variety of sources and can export Excel workbooks, charts, and other objects to different formats, including XLSX, CSV, PDF, HTML, PNG, and more. This makes data management and sharing simple and efficient.

How to import data from various data sources

Importing data into an Excel file is a complex process. Many factors contribute to the complexity and therefore should be taken into account during the import process. The ability to import many formats and types of data with professional quality is a top feature of Aspose.Cells Cloud.

Import Data APIs Information

The following APIs are provided to import data into one or multiple Excel files:

API	Description
POST /cells/import	Import data into Excel files without using storage.
POST /cells/{name}/importdata	Import data into an Excel file stored in the cloud.

Request Parameters

Without using storage

Parameter Name	Type	Location	Description
file	file	formData	File to upload
ImportOption	ImportOptions	HTTP body	Specifies the import format (IntArray, DoubleArray, StringArray, TwoDimensionIntArray, TwoDimensionDoubleArray, TwoDimensionStringArray, BatchData, csvData, Picture)

With using storage

Parameter Name	Type	Location	Description
name	string	path	Name of the Excel file
folder	string	query	Folder path in storage
storageName	string	query	Storage name
importData	ImportOptions	body	Import data payload

Import data option parameters

The important parameters are described in the following tables:

ImportBatchDataOption

Parameter	Type	Description
BatchData	List<CellValue>	Batch data to import
DestinationWorksheet	String	Destination worksheet name
IsInsert	String	Whether to insert data (true/false)
ImportDataType	String	TwoDimensionStringBatchDataArray
Source	FileSource	Data file location when BatchData is null

ImportCSVDataOption

Parameter	Type	Description
ConvertNumericData	String	Whether to convert numeric data (true/false)
FirstRow	int	Index of the first row
FirstColumn	int	Index of the first column
SeparatorString	String	Column separator
DestinationWorksheet	String	Destination worksheet name
CustomParsers	List<CustomParserConfig>	Custom parser configurations
ImportDataType	String	CSVData
Source	FileSource	Data file location when BatchData is null

ImportPictureOption

Parameter	Type	Description
FirstRow	int	Index of the first row
FirstColumn	int	Index of the first column
IsVertical	String	Whether the picture is placed vertically (true/false)
Data	String[]	Picture data (base‑64 strings)
DestinationWorksheet	String	Destination worksheet name
IsInsert	String	Whether to insert data (true/false)
ImportDataType	String	Picture
Source	FileSource	Data file location when BatchData is null

Import2DimensionIntArrayOption

Parameter	Type	Description
FirstRow	int	Index of the first row
FirstColumn	int	Index of the first column
Data	Integer[,]	Two‑dimensional integer array
DestinationWorksheet	String	Destination worksheet name
IsInsert	String	Whether to insert data (true/false)
ImportDataType	String	TwoDimensionIntArray
Source	FileSource	Data file location when BatchData is null

Import2DimensionDoubleArrayOption

Parameter	Type	Description
FirstRow	int	Index of the first row
FirstColumn	int	Index of the first column
Data	Double[,]	Two‑dimensional double array
DestinationWorksheet	String	Destination worksheet name
IsInsert	String	Whether to insert data (true/false)
ImportDataType	String	TwoDimensionDoubleArray
Source	FileSource	Data file location when BatchData is null

Import2DimensionStringArrayOption

Parameter	Type	Description
FirstRow	int	Index of the first row
FirstColumn	int	Index of the first column
Data	String[,]	Two‑dimensional string array
DestinationWorksheet	String	Destination worksheet name
IsInsert	String	Whether to insert data (true/false)
ImportDataType	String	TwoDimensionStringArray
Source	FileSource	Data file location when BatchData is null

ImportIntegerArrayOption

Parameter	Type	Description
FirstRow	int	Index of the first row
FirstColumn	int	Index of the first column
IsVertical	String	Whether the array is vertical (true/false)
Data	Integer[]	One‑dimensional integer array
DestinationWorksheet	String	Destination worksheet name
IsInsert	String	Whether to insert data (true/false)
ImportDataType	String	IntegerArray
Source	FileSource	Data file location when BatchData is null

ImportDoubleArrayOption

Parameter	Type	Description
FirstRow	int	Index of the first row
FirstColumn	int	Index of the first column
IsVertical	String	Whether the array is vertical (true/false)
Data	Double[]	One‑dimensional double array
DestinationWorksheet	String	Destination worksheet name
IsInsert	String	Whether to insert data (true/false)
ImportDataType	String	DoubleArray
Source	FileSource	Data file location when BatchData is null

ImportStringArrayOption

Parameter	Type	Description
UpperLeftRow	int	Upper‑left row index
UpperLeftColumn	int	Upper‑left column index
LowerRightRow	int	Lower‑right row index
LowerRightColumn	int	Lower‑right column index
Filename	String	Name of the source file
Data	String	String data to import
DestinationWorksheet	String	Destination worksheet name
IsInsert	String	Whether to insert data (true/false)
ImportDataType	String	StringArray
Source	FileSource	Data file location when BatchData is null

CellValue

Parameter	Type	Description
rowIndex	int	Row index of the cell
columnIndex	int	Column index of the cell
type	String	Data type of the cell value
value	String	Cell value
style	Style (object)	Cell style definition

FileSource

Parameter	Type	Description
FileSourceType	String	InMemoryFiles, CloudFileSystem, or RequestFiles
FilePath	String	Path to the source file

How to export Excel objects to various file formats

If you originally created an Excel file in a format such as XLS, XLSX, XLSB, or CSV, you may want to convert it to another format to take advantage of specific features. For example, exporting to PDF protects the content from unauthorized modifications while making it easy to read and share.

Exporting Excel objects is a complex process, and many factors must be considered. Aspose.Cells Cloud provides high‑quality export of workbooks, charts, shapes, and pictures to a wide range of formats:

Export‑only formats: PDF, OTS, XPS, DIF, PNG, JPEG, BMP, SVG, TIFF, EMF, NUMBERS, FODS.
Both import and export: XLS, XLSX, XLSB, CSV, TSV, XLSM, ODS, TXT.

The request uses multipart content as defined in [RFC 2046] and [RFC 1341]. The first part contains the data file; the second part contains save options.

Export API Information

POST https://api.aspose.cloud/v3.0/cells/export

Request parameters

Parameter Name	Type	Location	Description
file	file	formData	File to upload
objectType	string	query	Object type (`workbook`, `worksheet`, `chart`, `shape`, `picture`, `listobject`, `oleobject`)
format	string	query	Desired output file format (see Supported File Formats)

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

You can use the cURL command‑line tool to call the API. The example below demonstrates a request and its JSON response.

Request

curl -v "https://api.aspose.cloud/v3.0/cells/export" \
  -X POST \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -H "Authorization: Bearer <jwt token>" \
  -F 'file1=@example1.xlsx' \
  -F 'file2=@example2.xlsx'

Response

{
  "Files": [
    {
      "Filename": "example1.pdf",
      "FileSize": 274022,
      "FileContent": "-----Base64String--------"
    },
    {
      "Filename": "example2.pdf",
      "FileSize": 274022,
      "FileContent": "-----Base64String--------"
    }
  ]
}

How to call import and export APIs

The following articles explain each API in detail and contain cURL and SDK examples:

Insert Watermarks or set Backgrounds in Excel files. Convert an Excel file to another format or save it differently.