Import String Array into Excel Worksheet

This REST API imports string array data into an Excel worksheet.

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

REST API

POST https://api.aspose.cloud/v3.0/cells/import
POST https://api.aspose.cloud/v3.0/cells/{name}/importdata

The important parameters are described in the following table:

ImportStringArrayOption

Parameter Name	Type	Description
FirstRow	int	The starting row index (1‑based) where the data will be placed.
FirstColumn	int	The starting column index (1‑based) where the data will be placed.
IsVertical	string	`true` to insert data vertically; `false` to insert horizontally.
Data	String[]	The string array to be imported.
DestinationWorksheet	string	The name of the worksheet that will receive the data.
IsInsert	string	`true` to insert rows/columns; `false` to overwrite existing cells.
ImportDataType	string	Type of data being imported (e.g., `IntArray`, `DoubleArray`, `StringArray`, `TwoDimensionIntArray`, `TwoDimensionDoubleArray`, `TwoDimensionStringArray`, `BatchData`, `csvData`).
Source	FileSource	Indicates the data file location when the BatchData parameter is null.

Example

<ImportStringArrayOption>
    <DestinationWorksheet>Sheet1</DestinationWorksheet>
    <IsInsert>false</IsInsert>
    <ImportDataType>StringArray</ImportDataType>
    <FirstRow>1</FirstRow>
    <FirstColumn>1</FirstColumn>
    <IsVertical>true</IsVertical>
    <Source>
        <FileSourceType>CloudFileSystem</FileSourceType>
        <FilePath>Array_string_xml.txt</FilePath>
    </Source>
</ImportStringArrayOption>

Cloud SDK Family

Using an SDK is the best way to speed up development. An SDK handles low‑level details, allowing you to 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 call Aspose.Cells web services using various SDKs:

Import Integer Array into Excel Worksheet