dxSpreadSheetCSVFormatSettings Method

Provides access to the CSV file format’s global settings for the Load and Save operations in the SpreadSheet Control.

Declaration

function dxSpreadSheetCSVFormatSettings: TdxSpreadSheetCSVFormatSettings;

Returns

Type
TdxSpreadSheetCSVFormatSettings

Remarks

This function provides an interface to the CSV format settings. Since the dxSpreadSheetFormatCSV unit is not included to your project by default, you need to add it explicitly in order to use the dxSpreadSheetCSVFormatSettings function.

Call the dxSpreadSheetCSVFormatSettings function to customize the following parameters of the CSV file format, used by the LoadFromStream, LoadFromFile, SaveToStream and SaveToFile methods of the ExpressSpreadSheet control’s instance:

• The text Encoding within a .csv file;

• Characters used as quotes and data delimiters within a file;

• CSV parser settings, including value and string interpretation and quotes usage.

Additionally, you can use the dxSpreadSheetCSVFormatSettings method to set the CSV file settings to the default values by invoking the TdxSpreadSheetCSVFormatExportSettings.Reset and TdxSpreadSheetCSVFormatSettings.Reset procedures.