How to: Load a Document into SpreadsheetControl

• Jun 07, 2019
• 2 minutes to read

To load an existing spreadsheet document into SpreadsheetControl, use the SpreadsheetControl.LoadDocument method of the control, or the ISpreadsheetComponent.LoadDocument method of the IWorkbook object. These methods enable you to load a document from a file or a stream.

The SpreadsheetControl.BeforeImport event is raised before the document is loaded. The SpreadsheetControl.DocumentLoaded event is raised after the document is loaded.

• Load in XAML

  Load a document into the SpreadsheetControl in XAML using the SpreadsheetControl.DocumentSource property. You can load documents from a stream, byte array or any other location specified by the full file path or URI. An empty document is created if the SpreadsheetControl.DocumentSource property is null.

  XAML

  <Grid>
      <dxsps:SpreadsheetControl CommandBarStyle="Ribbon" ShowFormulaBar="True" DocumentSource="pack://application:,,,/WpfSpreadsheet;component/Document.xlsx"/>
  </Grid>
  

• Load from File

  Call the ISpreadsheetComponent.LoadDocument method of the IWorkbook object with the passed file path to load a workbook from the existing file. Specify the file format as the second parameter of the method using the DocumentFormat enumerator.

  C#

  // Load a workbook from a file.
  workbook.LoadDocument("Documents\\Document.xlsx", DocumentFormat.Xlsx);
  

  VB.NET

  ' Load a workbook from a file.
  workbook.LoadDocument("Documents\Document.xlsx", DocumentFormat.Xlsx)
  

• Load from Stream

  Create a FileStream object with the specified file path to open the existing file, and call the ISpreadsheetComponent.LoadDocument method of the IWorkbook object with this stream object passed as a parameter. Specify the file format as the second parameter of the method using the DocumentFormat enumerator.

  C#

  using System.IO;
  using DevExpress.Spreadsheet;
  // ...
  
  IWorkbook workbook = spreadsheetControl1.Document;
  
  // Load a workbook from a stream.
  using (FileStream stream = new FileStream("Documents\\Document.xlsx", FileMode.Open)) {
      workbook.LoadDocument(stream, DocumentFormat.Xlsx);
  }
  

  VB.NET

  Imports System.IO
  Imports DevExpress.Spreadsheet
  ' ...
  
  Dim workbook As IWorkbook = spreadsheetControl1.Document
  
  ' Load a workbook from a stream.
  Using stream As New FileStream("Documents\Document.xlsx", FileMode.Open)
      workbook.LoadDocument(stream, DocumentFormat.Xlsx)
  End Using