SpreadsheetBuilder.Open(String, DocumentFormat, Func<Byte[]>) Method

Opens a document in the specified format from a byte array.

Namespace : DevExpress.AspNetCore.Spreadsheet

Assembly : DevExpress.AspNetCore.Spreadsheet.v25.2.dll

NuGet Package : DevExpress.AspNetCore.Spreadsheet

Declaration

csharp

public SpreadsheetBuilder Open(
    string documentId,
    DocumentFormat documentFormat,
    Func<byte[]> contentAccessorByBytes
)

Parameters

Name	Type	Description
documentId	String

A document identifier.

| | documentFormat | DocumentFormat |

A document format.

| | contentAccessorByBytes | Func<Byte[]> |

A method delegate that obtains a byte array.

Returns

Type	Description
SpreadsheetBuilder

An object that can be used to further configure the Spreadsheet.

Remarks

This method overload allows you to disable automatic format detection and improve performance when the Spreadsheet opens a document. Call the Open(String, Func<Byte[]>) method to determine the document’s format automatically when you open a document. Refer to the following section for more information: Open a Document from a Byte Array.

The example below demonstrates how to open a document from a byte array:

Index.cshtml

razor

@model SpreadsheetDocumentContent

@(Html.DevExpress()
    .Spreadsheet("spreadsheet")
    .Open(@Model.DocumentId, DocumentFormat.Xlsx, @Model.ContentAccessorByBytes)
)

SpreadsheetControler.cs

csharp

public IActionResult Index() {
    byte[] byteArrayAccessor() => System.IO.File.ReadAllBytes("your-file-path");
    var model = new SpreadsheetDocumentContent("DocumentId1", byteArrayAccessor);
    return View(model);
}

SpreadsheetDocumentContent.cs

csharp

public class SpreadsheetDocumentContent {
    public string DocumentId { get; set; }
    public Func<byte[]> ContentAccessorByBytes { get; set; }
    public DocumentFormat DocumentFormat { get; set; } = DocumentFormat.Xlsx;
    public SpreadsheetDocumentContent(string documentId, Func<byte[]> contentAccessorByBytes) {
        DocumentId = documentId;
        ContentAccessorByBytes = contentAccessorByBytes;
    }
}