DocumentFormat.Xlsx Field

The OpenXML file format for the workbook (default MS Excel 2007 format). File extension - .xlsx.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

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#

mvc-gridview-how-to-customize-an-exported-dataaware-excel-file-t385649/CS/T385649/Controllers/HomeController.cs#L24

ms.Position = 0;
mySpreadsheet.Open("myDoc", DocumentFormat.Xlsx, () => {
    return ms;

aspxspreadsheet-how-to-save-and-load-documents-from-a-database-t190812/CS/ASPxSpreadsheetBinding/Default.aspx.cs#L27

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

spreadsheet-how-to-save-and-load-documents-from-a-database-t190813/CS/DXWebApplication23/Controllers/HomeController.cs#L13

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

aspxspreadsheet-how-to-download-a-document-on-custom-ribbonitem-click-t623622/CS/ASPxSpreadsheetBinding/Default.aspx.cs#L30

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

aspxspreadsheet-how-to-use-jsproperties/CS/DXSample/Default.aspx.cs#L33

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

VB.NET

mvc-gridview-how-to-customize-an-exported-dataaware-excel-file-t385649/VB/T385649/Controllers/HomeController.vb#L26

ms.Position = 0
mySpreadsheet.Open("myDoc", DocumentFormat.Xlsx, Function() ms)
Dim aw As Worksheet = mySpreadsheet.Document.Worksheets(0)

aspxspreadsheet-how-to-save-and-load-documents-from-a-database-t190812/VB/ASPxSpreadsheetBinding/Default.aspx.vb#L31

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

spreadsheet-how-to-save-and-load-documents-from-a-database-t190813/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)

aspxspreadsheet-how-to-download-a-document-on-custom-ribbonitem-click-t623622/VB/ASPxSpreadsheetBinding/Default.aspx.vb#L37

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

aspxspreadsheet-how-to-use-jsproperties/VB/DXSample/Default.aspx.vb#L37

Dim view As DataView = DirectCast(SqlDataSource1.Select(DataSourceSelectArguments.Empty), DataView)
Spreadsheet.Open(EditedDocuemntID, DocumentFormat.Xlsx, Function()
    Return CType(view.Table.Rows(0)("DocumentContent"), Byte())