Import CSV Data into Excel Worksheet

This REST API import csv 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 ImportCSVDataOption 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:

ImportCSVDataOption

Parameter Name	Type	Description
SeparatorString	string
ConvertNumericData	string	true/false.
FirstRow	int
FirstColumn	int
SourceFile	string
CustomParsers	List

CustomParserConfig

Parameter Name	Type	Description
ColumnIndex	int
ParseMethod	string
CustomStyle	string

Example


 <ImportCSVDataOption>
     <DestinationWorksheet>Sheet1</DestinationWorksheet>
     <IsInsert>true</IsInsert>
     <ImportDataType>CSVData</ImportDataType>
     <SeparatorString>;</SeparatorString>
     <ConvertNumericData>true</ConvertNumericData>
     <FirstRow>1</FirstRow>
     <FirstColumn>2</FirstColumn>
     <SourceFile>TestImportDataCSV.csv</SourceFile>
     <CustomParsers>
         <CustomParserConfig>
             <ColumnIndex>0</ColumnIndex>
             <ParseMethod>ToString</ParseMethod>
             <CustomStyle>#</CustomStyle>
         </CustomParserConfig>
     </CustomParsers>
 </ImportCSVDataOption>

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:

Import Data without using storage Import 2 Dimension Double Array into Excel Worksheet