wpf-devexpress-dot-xpf-dot-spreadsheet-dot-spreadsheetcontrol-dot-loaddocument-x28-system-dot-string-devexpress-dot-spreadsheet-dot-documentformat-x29.md
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, specifying the document format.
Namespace : DevExpress.Xpf.Spreadsheet
Assembly : DevExpress.Xpf.Spreadsheet.v25.2.dll
NuGet Package : DevExpress.Wpf.Spreadsheet
public bool LoadDocument(
string fileName,
DocumentFormat format
)
Public Function LoadDocument(
fileName As String,
format As DocumentFormat
) As Boolean
| Name | Type | Description |
|---|---|---|
| fileName | String |
A string value specifying the path to a file from which to load a document.
| | format | DocumentFormat |
The DocumentFormat enumeration member.
|
| Type | Description |
|---|---|
| Boolean |
true, if a document is loaded successfully; otherwise, false.
|
If the data has an incorrect format, the SpreadsheetControl.InvalidFormatException event fires.
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the LoadDocument(String, 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.
spreadsheet.Options.Culture = new CultureInfo("en-US");
spreadsheet.LoadDocument(@"Documents/Expenses_template.xlsx", DocumentFormat.Xlsx);
}
spreadsheet.Options.Culture = New CultureInfo("en-US")
spreadsheet.LoadDocument("Documents/Expenses_template.xlsx", DocumentFormat.Xlsx)
End Sub
See Also