Import CSV data file into the local spreadsheet.
- Base URL:
http://api.aspose.cloud/v4.0 - Authentication Method:
JWT (OAuth2, application)Token URL:https://api.aspose.cloud/connect/token
PUT http://api.aspose.cloud/v4.0/cells/import/data/csv
The method parses the CSV, maps the data to the spreadsheet's cell structure, and saves the file locally. Supported spreadsheet formats include .xlsx and .ods.## Error Handling- 400 Bad Request: Invalid url.- 401 Unauthorized: Authentication has failed, or no credentials were provided.- 404 Not Found: Source file not accessible.- 500 Server Error The spreadsheet has encountered an anomaly in obtaining data.## Key Features and Benefits- Direct Spreadsheet Integration: Imports data directly into the specified spreadsheet.- Efficient Data Handling: Processes data efficiently, ensuring accurate parsing and insertion.
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
|---|---|---|---|
| datafile | File | FormData | Upload data file. |
| Spreadsheet | File | FormData | Upload spreadsheet file. |
| worksheet | String | Query | Need to import CSV data into the worksheet. |
| startcell | String | Query | Starting position for data import |
| insert | Boolean | Query | Controls the insertion behavior. true: inserts data; false: overwrites existing data. |
| convertNumericData | Boolean | Query | Whether the string in text file is converted to numeric data. |
| splitter | String | Query | |
| outPath | String | Query | (Optional) The folder path where the workbook is stored. The default is null. |
| outStorageName | String | Query | Output file Storage Name. |
| fontsLocation | String | Query | Use Custom fonts. |
| region | String | Query | The spreadsheet region setting. |
| password | String | Query | The password for opening spreadsheet file. |
{
File
}The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.