Skip to main content
Row

Workbook.SaveDocument(DocumentFormat, EncryptionSettings) Method

Saves the document to an array of bytes in the specified format and with the specified encryption settings.

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.v24.1.dll

NuGet Package: DevExpress.Document.Processor

Declaration

public byte[] SaveDocument(
    DocumentFormat format,
    EncryptionSettings encryptionSettings
)

Parameters

Name Type Description
format DocumentFormat

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

encryptionSettings EncryptionSettings

Specifies encryption options.

Returns

Type Description
Byte[]

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

Remarks

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

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

Workbook workbook = new Workbook();
// ...

// Specify encryption settings.
EncryptionSettings encryptionSettings = new EncryptionSettings();
encryptionSettings.Type = DevExpress.Spreadsheet.EncryptionType.Strong;
encryptionSettings.Password = "password";

// Save the document to a byte array.
byte[] docBytes = workbook.SaveDocument(DocumentFormat.Xlsx, encryptionSettings);

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.

See Also