DocumentFormat.Xlsx Field

Microsoft Office Open XML format - the default file format starting with Microsoft Excel 2007. File extension - .xlsx.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public static readonly DocumentFormat Xlsx

VB.NET

Public Shared ReadOnly Xlsx As DocumentFormat

Field Value

Type	Description
DocumentFormat	A document format.

Related GitHub Examples

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

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#

asp-net-mvc-spreadsheet-work-with-database/CS/DXWebApplication23/Controllers/HomeController.cs#L13

DocumentId = Guid.NewGuid().ToString(),
DocumentFormat = DocumentFormat.Xlsx,
Document = DataHelper.GetDocument()

web-dashboard-custom-info-exported-excel/CS/WebDashboardForm.aspx.cs#L24

if (e.ExcelExportOptions.Format == ExcelFormat.Xlsx)
    workbook.LoadDocument(e.Stream, DocumentFormat.Xlsx);
else if (e.ExcelExportOptions.Format == ExcelFormat.Xls)

asp-net-web-forms-spreadsheet-work-with-database/CS/ASPxSpreadsheetBinding/Default.aspx.cs#L27

EditedDocumentID,
DocumentFormat.Xlsx,
() => { return (byte[])view.Table.Rows[0]["DocBytes"]; }

asp-net-web-forms-spreadsheet-download-file-on-custom-ribbon-item-click/CS/ASPxSpreadsheetBinding/Default.aspx.cs#L30

using (var stream = new MemoryStream()) {
    Spreadsheet.Document.SaveDocument(stream, DocumentFormat.Xlsx);
    Response.Clear();

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/Form1.cs#L209

string fileName = "SampleDocument.xlsx";
workbook.SaveDocument(fileName, DocumentFormat.Xlsx);
Process.Start(fileName);

VB.NET

asp-net-mvc-spreadsheet-work-with-database/VB/DXWebApplication23/Controllers/HomeController.vb#L13

Public Function Index() As ActionResult
    Dim model = New SpreadsheetData() With {.DocumentId = Guid.NewGuid().ToString(), .DocumentFormat = DocumentFormat.Xlsx, .Document = DataHelper.GetDocument()}
    Return View(model)

web-dashboard-custom-info-exported-excel/VB/WebDashboardForm.aspx.vb#L26

If e.ExcelExportOptions.Format = ExcelFormat.Xlsx Then
    workbook.LoadDocument(e.Stream, DocumentFormat.Xlsx)
ElseIf e.ExcelExportOptions.Format = ExcelFormat.Xls Then

asp-net-web-forms-spreadsheet-work-with-database/VB/ASPxSpreadsheetBinding/Default.aspx.vb#L34

    Dim view As DataView = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), DataView)
    Spreadsheet.Open(EditedDocumentID, DocumentFormat.Xlsx, Function() CType(view.Table.Rows(0)("DocBytes"), Byte()))
End If

asp-net-web-forms-spreadsheet-download-file-on-custom-ribbon-item-click/VB/ASPxSpreadsheetBinding/Default.aspx.vb#L40

Using stream = New MemoryStream()
    Spreadsheet.Document.SaveDocument(stream, DocumentFormat.Xlsx)
    Response.Clear()

winforms-dashboard-customize-exported-document/VB/CustomExportDocumentExample/Form1.vb#L33

If e.ExcelExportOptions.Format = ExcelFormat.Xlsx Then
    workbook.LoadDocument(fileStream, DocumentFormat.Xlsx)
ElseIf e.ExcelExportOptions.Format = ExcelFormat.Xls Then