CSV

CSV (Comma Separated Values) is a text format that is used to represent table data. Each string of the file is one row of the table. The values of each column are separated by the delimiter that depends on regional settings. The values that contain reserved characters (such as a comma or a new string) are framed with the double quotes ( ") symbol; if double quotes are found in the value they are represented as two double quotes in the file.

 

Information

 

Only those data (components) can be exported to the CSV format which are placed on data bands. If the SkipColumnHeaders property is set to false then, additionally, column headers are exported as the first row.

 

 

 

Export Settings

 

The export parameters of the CSV export are described in the StiCsvExportSettings class. The description of all class properties are in the table below.

 

Name

Type

Description

Separator

string

sets the symbol-separator of a list that is used when exporting; by default CurrentCulture.TextInfo.ListSeparator

Encoding

Encoding

text file coding; by default Encoding.UTF8

SkipColumnHeaders

bool

skip headers of columns; by default false

 

 

Static Options

 

Static properties of export to CSV. To access to export properties it is necessary to add the StiOptions.Export.Csv... prefix. For example, StiOptions.Export.Csv.ForcedSeparator.

 

Name

Type

Description

ForcedSeparator

string

sets the separator forcibly which are used in export; if the empty string is set then the symbol from export settings in used; by default - empty string