SpreadsheetControl.SaveDocument(DocumentFormat) Method

Saves a document to an array of bytes in the specified format.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v19.1.dll

Declaration

C#

public byte[] SaveDocument(
    DocumentFormat format
)

VB.NET

Public Function SaveDocument(
    format As DocumentFormat
) As Byte()

Parameters

Name	Type	Description
format	DocumentFormat	A DocumentFormat enumeration member specifying the format of the document to be saved.

Returns

Type	Description
Byte[]	A Byte[] object that is an array of bytes containing document data in the specified format.

Remarks

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

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the SaveDocument(DocumentFormat) method.

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#

how-to-store-a-workbook-in-the-database-e5132/CS/SpreadsheetToDatabase/Form1.cs#L25

SqlParameter dataParameter = new SqlParameter("@Data", SqlDbType.VarBinary);
dataParameter.Value = spreadsheetControl1.SaveDocument(DevExpress.Spreadsheet.DocumentFormat.OpenXml);
command.Parameters.Add(dataParameter);

VB.NET

how-to-store-a-workbook-in-the-database-e5132/VB/SpreadsheetToDatabase/Form1.vb#L22

Dim dataParameter As New SqlParameter("@Data", SqlDbType.VarBinary)
dataParameter.Value = spreadsheetControl1.SaveDocument(DevExpress.Spreadsheet.DocumentFormat.OpenXml)
command.Parameters.Add(dataParameter)