SpreadsheetControl.InvalidFormatException Event
Fires when the supplied data could not be recognized as data in the assumed format for import.
Namespace: DevExpress.XtraSpreadsheet
Assembly: DevExpress.XtraSpreadsheet.v19.1.dll
Declaration
Event Data
The InvalidFormatException event's data class is SpreadsheetInvalidFormatExceptionEventArgs. The following properties provide information specific to this event:
| Property | Description |
|---|---|
| Exception | Gets the exception which triggers the InvalidFormatException event. |
| SourceUri | Gets the source location for the document which triggers the InvalidFormatException event. |
Remarks
If the data for import is in an incorrect format, the control silently cancels import if the InvalidFormatException is not handled. If you subscribe to the InvalidFormatException event, the event is fired when the control attempts to load incorrect data, so you can provide custom logic in this situation.
To throw an exception on loading an invalid document, set the WorkbookImportOptions.ThrowExceptionOnInvalidDocument property to true (import options are accessible via the SpreadsheetControl.Document.Options.Import notation).
Related GitHub Examples
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the InvalidFormatException event.
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.