Device Information Settings for the CSV rendering format
The following table lists the device information settings for rendering in CSV format.
Available CSV Device Information Settings
|FieldDelimiter||String||The delimiter string to put in the result. The default value is a comma
|RecordSeparator||String||Specifies the string that is used to separate each record(row) in the produced CSV. By default, the NewLine string is taken from the environment. It is the newline character for the corresponding operating system (OS). For example, for Windows OS this is the carriage return and line feed '\r\n'. For Linux OS this is the '\n' character.|
|NoHeader||Boolean||Indicates whether the header row is excluded from the output. The default value is false.|
|NoStaticText||Boolean||Indicates whether static text is excluded from the output. From Telerik Reporting point of view a TextBox item which value is a string that does not start with = is considered static; otherwise it is evaluated as an expression. The default value is false.|
|Qualifier||String||The qualifier string to put around results that contain the field delimiter. If the results contain the qualifier, the qualifier is repeated. The Qualifier setting must be different from the FieldDelimiter setting. The default value is a quotation mark
|Encoding||String||The code page .NET name that will be used to encode the exported data. The default value is UTF-8. List of all the available code page identifiers can be obtained from the article Code Page Identifiers.|
|WriteBOM||Boolean||Indicates whether to write the byte order marks (BOM) at the beginning of the output stream. Applicable only when the selected encoding is Unicode. The default value is false.|
|FormulaPrefix||String||When the exported CSV file is to be opened in a spreadsheet application (Microsoft Excel, Google Sheets, etc.), it is recommended to escape CSV values with a prefix in order to prevent the spreadsheet application from automatically executing malicious formula injection attacks. The recommended formula prefix string which is not visually present in spreadsheet applications is the tab character
The default value is an empty string and the default behavior is to keep the original CSV data intact. This option is very useful when the exported CSV file will be read by a non-spreadsheet application and there is no risk of formula injection attacks.
Besides formula injection attacks the prefix will also prevent automatic execution of CSV values which incidentally resemble a spreadsheet formula. For example:
The CSV value above will be visualised as
For an example of how to set up the settings for a rendering extension, see extensions Element.