ISpreadsheetComponent.LoadDocument(String) Method

SECURITY-RELATED CONSIDERATIONS

Using file paths sourced from untrusted input may expose unauthorized files or allow unintended file access. Always validate and normalize all external paths to prevent path manipulation.

Loads a document from a file.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

bool LoadDocument(
    string fileName
)

VB.NET

Function LoadDocument(
    fileName As String
) As Boolean

Parameters

Name	Type	Description
fileName	String	A string specifying the file to load (including the full path).

Returns

Type	Description
Boolean	true, if a document is loaded successfully; otherwise, false.

Remarks

When you use this method to load a document from a file, the document format is identified automatically based on its content (regardless of the filename extension).

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the LoadDocument(String) 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#

wpf-spreadsheetcontrol-api-part-2/CS/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/RowAndColumnActions.cs#L14

#region #DeleteRowsBasedOnCondition
workbook.LoadDocument("Documents\\Document.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

winforms-spreadsheetcontrol-api-part-2/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/SearchActions.cs#L18

#region #SimpleSearch
workbook.LoadDocument("Documents\\ExpenseReport.xlsx");
workbook.Calculate();

winforms-spreadsheetcontrol-api-part-3/CS/SpreadsheetControl_API_Part03/CodeExamples/RowAndColumnActions.cs#L11

#region #DeleteRowsBasedOnCondition
workbook.LoadDocument("Documents\\Document.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/DataValidationActions.cs#L25

// Load a document from a file.
workbook.LoadDocument("..\\..\\..\\Documents\\DataValidation.xlsx");

spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/RowAndColumnActions.cs#L225

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

VB.NET

winforms-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/SearchActions.vb#L15

'            #Region "#SimpleSearch"
            workbook.LoadDocument("Documents\ExpenseReport.xlsx")
            workbook.Calculate()

wpf-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/SearchActions.vb#L17

'            #Region "#SimpleSearch"
            workbook.LoadDocument("Documents\ExpenseReport.xlsx")
            workbook.Calculate()

winforms-spreadsheetcontrol-api-part-3/VB/SpreadsheetControl_API_Part03/CodeExamples/RowAndColumnActions.vb#L10

#Region "#DeleteRowsBasedOnCondition"
            workbook.LoadDocument("Documents\Document.xlsx")
            Dim worksheet As DevExpress.Spreadsheet.Worksheet = workbook.Worksheets(0)

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/DataValidationActions.vb#L24

' Load a document from a file.
workbook.LoadDocument("..\..\..\Documents\DataValidation.xlsx")

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/RowAndColumnActions.vb#L181

' Load a document from a file.
workbook.LoadDocument("Documents\Document.xlsx")