XlDocumentFormat Enum

Lists values used to specify the document format.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public enum XlDocumentFormat

VB.NET

Public Enum XlDocumentFormat

Members

Name	Description
Xlsx	The OpenXML file format for the workbook (default MS Excel 2007 format). File extension - .xlsx.
Xls	MS Excel 97-2003 binary file format.
Csv	The CSV format (Comma-Separated Values) - the file format to store tabular data as plain text using commas as separators between cells.

Related API Members

The following properties accept/return XlDocumentFormat values:

• CsvDataAwareExporterOptions.DocumentFormat
• IXlDocumentOptions.DocumentFormat

Remarks

To set the document format to which a spreadsheet should be exported, use the XlExport.CreateExporter method.

Related GitHub Examples

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

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#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/FormulaActions.cs#L11

#region Actions
public static Action<Stream, XlDocumentFormat> SimpleFormulasAction = SimpleFormula;
public static Action<Stream, XlDocumentFormat> ComplexFormulasAction = ComplexFormulas;

how-to-use-the-excel-export-api-to-generate-a-list-of-employees-t251723/CS/XLExportExample/Form1.cs#L55

    return;
if (ExportToFile(fileName, XlDocumentFormat.Xlsx))
    ShowFile(fileName);

how-to-use-the-excel-export-api-to-perform-a-sales-analysis-t252486/CS/XLExportExample/Form1.cs#L60

    return;
if (ExportToFile(fileName, XlDocumentFormat.Xlsx))
    ShowFile(fileName);

how-to-use-the-excel-export-api-to-generate-a-sales-report-t251810/CS/XLExportExampleSalesReport/Form1.cs#L57

    return;
if (ExportToFile(fileName, XlDocumentFormat.Xlsx))
    ShowFile(fileName);

how-to-use-the-excel-export-api-to-generate-an-invoice-t252983/CS/XLExportExample/Form1.cs#L107

    return;
if (ExportToFile(fileName, XlDocumentFormat.Xlsx))
    ShowFile(fileName);

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/SparklineActions.vb#L9

#Region "Actions"
Public Shared AddSparklineGroupAction As Action(Of Stream, XlDocumentFormat) = AddressOf AddSparklineGroup
Public Shared AddSparklineAction As Action(Of Stream, XlDocumentFormat) = AddressOf AddSparkline

how-to-use-the-excel-export-api-to-generate-a-list-of-employees-t251723/VB/XLExportExample/Form1.vb#L58

End If
If ExportToFile(fileName, XlDocumentFormat.Xlsx) Then
    ShowFile(fileName)

how-to-use-the-excel-export-api-to-perform-a-sales-analysis-t252486/VB/XLExportExample/Form1.vb#L63

End If
If ExportToFile(fileName, XlDocumentFormat.Xlsx) Then
    ShowFile(fileName)

how-to-use-the-excel-export-api-to-generate-a-sales-report-t251810/VB/XLExportExampleSalesReport/Form1.vb#L60

End If
If ExportToFile(fileName, XlDocumentFormat.Xlsx) Then
    ShowFile(fileName)

how-to-use-the-excel-export-api-to-generate-an-invoice-t252983/VB/XLExportExample/Form1.vb#L110

End If
If ExportToFile(fileName, XlDocumentFormat.Xlsx) Then
    ShowFile(fileName)