TextExportMode Enum

Specifies whether to use the formatting of the data fields in the bound dataset for the cells in the exported XLS (or XLSX) document.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

[ResourceFinder(typeof(ResFinder))]
[TypeConverter(typeof(EnumTypeConverter))]
public enum TextExportMode

VB.NET

<TypeConverter(GetType(EnumTypeConverter))>
<ResourceFinder(GetType(ResFinder))>
Public Enum TextExportMode

Members

Name	Description
Value	Exports all data fields to the XLS (or XLSX) file using the same formatting as they have in the original document.
Text	Exports all data fields to the XLS (or XLSX) file as strings, with the corresponding non-HTML formatting embedded into those strings. HTML tags are ignored.

Related API Members

The following properties accept/return TextExportMode values:

• TextExportOptionsBase.TextExportMode
• XlExportOptionsBase.TextExportMode

Remarks

The TextExportMode enumeration values are used to get or set the TextExportOptionsBase.TextExportMode property, which is used to specify whether to use the formatting of the data fields in the bound dataset for the cells in the exported XLS document. Note that if the TextExportOptionsBase.TextExportMode property is set to Text, all data fields are exported to the XLS file as strings, with the corresponding formatting embedded into those strings.

Note

Unfortunately, not all .NET format strings have their equivalents in XLS format. If exact conversion is impossible, the XtraPrinting Library tries to find a string that best resembles the original. For example, the .NET “n4” format that represents a numerical value with 4 decimal places, will be converted as “n2”, to represent this numerical value with 2 decimal places, since the XLS format doesn’t have a built-in numerical format with 3 or 4 decimal places.