Back to Devexpress

Workbook.SaveDocument(DocumentFormat) Method

officefileapi-devexpress-dot-spreadsheet-dot-workbook-dot-savedocument-x28-devexpress-dot-spreadsheet-dot-documentformat-x29.md

latest3.7 KB
Original Source

Workbook.SaveDocument(DocumentFormat) Method

Saves a document to a byte array in the specified format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Docs.v25.2.dll

NuGet Package : DevExpress.Document.Processor

Declaration

csharp
public byte[] SaveDocument(
    DocumentFormat format
)
vb
Public Function SaveDocument(
    format As DocumentFormat
) As Byte()

Parameters

NameTypeDescription
formatDocumentFormat

A DocumentFormat enumeration value that specifies the document’s format.

|

Returns

TypeDescription
Byte[]

A byte array that contains document data in the specified format.

|

Remarks

You can use the current SaveDocument method overload to store a workbook in an external database. Refer to the How to: Store a Workbook in the Database document for more information.

csharp
// Add a reference to the DevExpress.Docs.dll assembly.
using DevExpress.Spreadsheet;
// ...

Workbook workbook = new Workbook();

// Save a document to a byte array to store it in a database.
byte[] docBytes = workbook.SaveDocument(DocumentFormat.Xlsx);

// ...

// Load the saved document from a byte array into the Workbook instance.
workbook.LoadDocument(docBytes);
vb
' Add a reference to the DevExpress.Docs.dll assembly.
Imports DevExpress.Spreadsheet
' ...

Dim workbook As New Workbook()

' Save a document to a byte array to store it in a database.
Dim docBytes() As Byte = workbook.SaveDocument(DocumentFormat.Xlsx)

' ...

' Load the saved document from a byte array into the Workbook instance.
workbook.LoadDocument(docBytes)

Calculate Formulas Before Save Operation

The default calculation mode for a Workbook is Manual. This mode implies that the Spreadsheet does not calculate formulas before it saves a document. Call the Workbook.Calculate or Workbook.CalculateFull method to calculate all formulas in the workbook.

Implements

SaveDocument(DocumentFormat)

See Also

LoadDocument

Workbook Class

Workbook Members

DevExpress.Spreadsheet Namespace