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

Aspose.Cells Cloud API supports importing data from a variety of data sources, and can export data from Excel, charts, and charts to different formats, including Excel, CSV, PDF, HTML, PNG, etc. 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 export process. The ability to imports kinds of formats and types of data into the file with a precise professional quality is a top feature of Aspose.Cells Cloud.

Import Data APIs Information

The following APIs to import data into an Excel file or multiple Excel files is provided:

API	Description
POST /cells/impport	Import data into Excel files without using storage.
POST /cells/{name}/impportdata	Import data into the Excel file with using storage.

Request Parameters

Without using storage

Parameter Name	Type	Path/Query String/HTTPBody	Description
file	file	formData	File to upload
ImportOption	ImportOptions	HTTPBody	IntArray/DoubleArray/StringArray/TwoDimensionIntArray/TwoDimensionDoubleArray/TwoDimensionStringArray/BatchData/CSVData/Picture

With using storage

Parameter Name	Type	Path/Query String/HTTPBody	Description
name	string	path
folder	string	query
storageName	string	query	storage name.
importData		body

Import data option parameter

The important parameters are described in the following table:

ImportBatchDataOption

Parameter	Type	Description
BatchData	List	batch data
DestinationWorksheet	String	Destination work sheet name.
IsInsert	String	true/false.
ImportDataType	String	TwoDimensionStringBatchDataArray
Source	FileSource	Indicates data file position when the BatchData parameter is null.

ImportCSVDataOption

Parameter	Type	Description
ConvertNumericData	String	true/false.
FirstRow	int
FirstColumn	int
SeparatorString	String
DestinationWorksheet	String	Destination work sheet name.
CustomParsers	List
ImportDataType	String	CSVData
Source	FileSource	Indicates data file position when the BatchData parameter is null.

ImportPictureOption

Parameter	Type	Description
FirstRow	int
FirstColumn	int
IsVertical	String	true/false.
Data	String[]
DestinationWorksheet	String	Destination work sheet name.
IsInsert	String	true/false.
ImportDataType	String	Picture
Source	FileSource	Indicates data file position when the BatchData parameter is null.

Import2DimensionIntArrayOption

Parameter	Type	Description
FirstRow	int
FirstColumn	int
Data	Integer[,]
DestinationWorksheet	String	Destination work sheet name.
IsInsert	String	true/false.
ImportDataType	String	TwoDimensionIntArray
Source	FileSource	Indicates data file position when the BatchData parameter is null.

Import2DimensionDoubleArrayOption

Parameter	Type	Description
FirstRow	int
FirstColumn	int
Data	Double[,]
DestinationWorksheet	String	Destination work sheet name.
IsInsert	String	true/false.
ImportDataType	String	TwoDimensionDoubleArray
Source	FileSource	Indicates data file position when the BatchData parameter is null.

Import2DimensionStringArrayOption

Parameter	Type	Description
FirstRow	int
FirstColumn	int
Data	String[,]
DestinationWorksheet	String	Destination work sheet name.
IsInsert	String	true/false.
ImportDataType	String	TwoDimensionStringArray
Source	FileSource	Indicates data file position when the BatchData parameter is null.

ImportIntegerArrayOption

Parameter	Type	Description
FirstRow	int
FirstColumn	int
IsVertical	String	true/false.
Data	Integer[]
DestinationWorksheet	String	Destination work sheet name.
IsInsert	String	true/false.
ImportDataType	String	IntegerArray
Source	FileSource	Indicates data file position when the BatchData parameter is null.

ImportDoubleArrayOption

Parameter	Type	Description
FirstRow	int
FirstColumn	int
IsVertical	String	true/false.
Data	Double[]
DestinationWorksheet	String	Destination work sheet name.
IsInsert	String	true/false.
ImportDataType	String	DoubleArray
Source	FileSource	Indicates data file position when the BatchData parameter is null.

ImportStringArrayOption

Parameter	Type	Description
UpperLeftRow	int
UpperLeftColumn	int
LowerRightRow	int
LowerRightColumn	int
Filename	String
Data	String
DestinationWorksheet	String	Destination work sheet name.
IsInsert	String	true/false.
ImportDataType	String	StringArray
Source	FileSource	Indicates data file position when the BatchData parameter is null.

CellValue

Parameter	Type	Description
rowIndex	int
columnIndex	int
type	String	data type
value	String
style	Style(object)

FileSource

Parameter	Type	Description
FileSourceType	String	InMemoryFiles/CloudFileSystem/RequestFiles
FilePath	String	file position

How to export Excel objects to various file formats

If you have originally created an Excel file in a certain format, like XLS, XLSX, XLSB, and CSV, you may sometimes find it useful to convert the excel file to another format so you can take advantage of special features provided by it. For example, you may want to export an excel file to PDF to protect your contents from any unauthorized modifications and make it easy to read and share simultaneously.

Excel object export is a complex process. Many factors contribute to the complexity and therefore, should be taken into account during the export process. The ability to export Excel object to one format file with a precise professional quality is a top feature of Aspose.Cells Cloud.

It works perfectly for workbook, chart, shape and picture exported from excel file. You can export formats: XLS, XLSX, XLSB, CSV, TSV, XLSM, ODS, TXT. The export-only formats: PDF, OTS, XPS, DIF, PNG, JPEG, BMP, SVG, TIFF, EMF, NUMBERS, FODS.

The request is an HTTP request with multipart content (see RFC 2046 or RFC 1341). The first part of the multipart content contains the data file and the second contains save options.

The REST API export workbook and internal objects to different format file.

Export API Information


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

The request parameters are:

Parameter Name	Type	Path/Query String/HTTPBody	Description
file	file	formData	File to upload
objectType	string	query	object type (workbook/worksheet/chart/shape/picture/listobject/oleobject)
format	string	query	File Format

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

You can use cURL command-line tool to access Aspose.Cells web services easily. The following example shows how to make calls to Cloud API with cURL.

Request

 
curl -v "http://api.aspose.cloud/v3.0/cells/export" \
-X POST \
-H "Content-Type: application/json" \
-H "Accept: application/json" \
-H "Authorization: Bearer <jwt token>" \
-F 'xxxxx1=@xxxx1.xlsx' \
-F 'xxxxx2=@xxxx2.xlsx'

Response

{
    "Files":
    [
        { 
            "Filename":"xxxxx",
            "FileSize":274022,
            "FileContent":"-----Base64String--------"
        },
        { 
            "Filename":"xxxxx",
            "FileSize":274022,
            "FileContent":"-----Base64String--------"
        }
    ]
}

How to call import and export APIs

The following articles explain each API how to call in detail and contain cURL and SDK Examples of each API:

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