XlExportOptionsBase.TextExportMode Property

Gets or sets a value indicating whether the cells in the resulting XLS document should use the same formatting as the original document.

Namespace: DevExpress.XtraPrinting

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

Declaration

C#

[DefaultValue(TextExportMode.Value)]
public TextExportMode TextExportMode { get; set; }

VB.NET

<DefaultValue(TextExportMode.Value)>
Public Property TextExportMode As TextExportMode

Property Value

Type	Default	Description
TextExportMode	Value	A TextExportMode enumeration value, specifying the text export mode in the resulting XLS document.

Available values:

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.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to TextExportMode
Cross-Platform Class Library	ExportOptions	.Xlsx.TextExportMode
WPF Controls	ExportOptionsContainer	.Xlsx.TextExportMode

Remarks

Use the TextExportMode property to specify whether to use both the .NET and native XLSX formatting of the data fields in the bound dataset for the cells in the exported XLS (or, XLSX) document. Note that if the TextExportMode property is set to Text, all data fields are exported to the XLS (or, XLSX) 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.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the TextExportMode property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

Reporting_how-to-customize-how-a-document-is-exported-from-print-preview-e172/CS/WindowsFormsApplication1/Form1.cs#L76

options.Xls.SheetName = "Page 1";
options.Xls.TextExportMode = TextExportMode.Value;

how-to-export-grid-columns-text-to-excel-e2585/CS/FilterCombo/Window1.xaml.cs#L63

{
    view.ExportToXls(@"1.xls", new XlsExportOptions() { TextExportMode = TextExportMode.Text });
}

Reporting_how-to-export-a-report-to-xlsx-format-e1539/CS/ExportToXLSX/Form1.cs#L25

xlsxOptions.ShowGridLines = true;
xlsxOptions.TextExportMode = TextExportMode.Value;
xlsxOptions.ExportHyperlinks = true;

Reporting_how-to-export-a-report-to-xls-format-e46/CS/Form1.cs#L29

xlsOptions.ShowGridLines = true;
xlsOptions.TextExportMode = TextExportMode.Value;

VB.NET

Reporting_how-to-customize-how-a-document-is-exported-from-print-preview-e172/VB/WindowsFormsApplication1/Form1.vb#L76

options.Xls.SheetName = "Page 1"
options.Xls.TextExportMode = TextExportMode.Value

how-to-export-grid-columns-text-to-excel-e2585/VB/FilterCombo/Window1.xaml.vb#L82

Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
    view.ExportToXls("1.xls", New XlsExportOptions() With {.TextExportMode = TextExportMode.Text})
End Sub

Reporting_how-to-export-a-report-to-xlsx-format-e1539/VB/ExportToXLSX/Form1.vb#L27

xlsxOptions.ShowGridLines = True
xlsxOptions.TextExportMode = TextExportMode.Value
xlsxOptions.ExportHyperlinks = True

Reporting_how-to-export-a-report-to-xls-format-e46/VB/Form1.vb#L31

xlsOptions.ShowGridLines = True
xlsOptions.TextExportMode = TextExportMode.Value