XLSImportCSV5

# Unit XLSImportCSV5

Description | Uses | Classes, Interfaces, Objects and Records | Functions and Procedures | Types | Constants | Variables

## Description

## Uses

- Classes
- SysUtils
- Xc12Utils5
- XLSUtils5
- XLSReadWriteII5

## Overview

### Functions and Procedures

`function ImportCSV(XLS: TXLSReadWriteII5; SheetIndex,Col,Row: integer; Filename: AxUCString; SepChar: AxUCChar; HasQuoteChar: boolean): boolean; overload;`
`function ImportCSV(XLS: TXLSReadWriteII5; SheetIndex,Col,Row: integer; List: TStrings; SepChar: AxUCChar; HasQuoteChar: boolean): boolean; overload;`
`function ImportCSVAuto(XLS: TXLSReadWriteII5; SheetIndex,Col,Row: integer; Filename: AxUCString): boolean;`

## Description

### Functions and Procedures

`function ImportCSV(XLS: TXLSReadWriteII5; SheetIndex,Col,Row: integer; Filename: AxUCString; SepChar: AxUCChar; HasQuoteChar: boolean): boolean; overload;`
This routine will import a text (CSV) file into a worksheet. Any existing cells on the worksheet will be overwritten. Correct value for decimal separator is detected automatically. See alse ˜[link ImportCSVAuto] ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜param SepChar Separator character for the fields (cells) in the source file. ˜param HasQuoteChar Set this to True if strings in the source file are quoted. ˜result The number of cells that where imported.

`function ImportCSV(XLS: TXLSReadWriteII5; SheetIndex,Col,Row: integer; List: TStrings; SepChar: AxUCChar; HasQuoteChar: boolean): boolean; overload;`

`function ImportCSVAuto(XLS: TXLSReadWriteII5; SheetIndex,Col,Row: integer; Filename: AxUCString): boolean;`
This routine will import a text (CSV) file into a worksheet. Any existing cells on the worksheet will be overwritten. The routine will try to detect correct values for separator character, quote character and decimal separator. See alse ˜[link ImportCSV] ˜param XLS The target XLSReadWriteII object. ˜param SheetIndex The index to the worksheet where the file will be imported to. ˜param Col Left column where the imported data will be written. ˜param Row Top row where the imported data will be written. ˜param Filename The name of the text file that shall be imported. ˜result The number of cells that where imported.

Generated by PasDoc 0.12.1 on 2013-03-18 12:36:48