Import Batch Data into Excel Worksheet
Contents
[
Hide
]
This REST API import batch data into Excel work sheet.
The request is an HTTP request with multipart content (see RFC 2046 or RFC 1341). The first part of the multipart content contains the ImportBatchDataOption data and the second contains a data file.
RSET API
POST https://api.aspose.cloud/v3.0/cells/import
POST https://api.aspose.cloud/v3.0/cells/{name}/import-data
The important parameters are described in the following table:
ImportBatchDataOption
| Parameter Name | Type | Description |
|---|---|---|
| BatchData | List |
batch data |
| DestinationWorksheet | string | destination work sheet name. |
| IsInsert | string | true/false. |
| ImportDataType | string | IntArray/DoubleArray/StringArray/TwoDimensionIntArray/TwoDimensionDoubleArray/TwoDimensionStringArray/BatchData/CSVData. |
| Source | FileSource | Indicates data file position when the BatchData parameter is null. |
CellValue
| Parameter Name | Type | Description |
|---|---|---|
| rowIndex | int | |
| columnIndex | int | |
| type | string | data type |
| value | string | |
| style | Style(object) |
FileSource
| Parameter Name | Type | Description |
|---|---|---|
| FileSourceType | string | InMemoryFiles/CloudFileSystem/RequestFiles |
| FilePath | string | file position |
Example
<ImportIntArrayOption>
<DestinationWorksheet>Sheet1</DestinationWorksheet>
<IsInsert>false</IsInsert>
<ImportDataType>IntArray</ImportDataType>
<FirstRow>1</FirstRow>
<FirstColumn>1</FirstColumn>
<IsVertical>true</IsVertical>
<Source>
<FileSourceType>CloudFileSystem</FileSourceType>
<FilePath>Array_int_xml.txt</FilePath>
</Source>
</ImportIntArrayOption>
Cloud SDK Family
Using an SDK is the best way to speed up the development. An SDK takes care of low-level details and lets you focus on your project tasks. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.
The following code examples demonstrate how to make calls to Aspose.Cells web services using various SDKs: