The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+

SpreadsheetDecryptionException Class

Fires under certain conditions when an attempt to load a password-protected .xls file fails.

Namespace: DevExpress.XtraSpreadsheet

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

Declaration

public class SpreadsheetDecryptionException :
    Exception
Public Class SpreadsheetDecryptionException
    Inherits Exception
public class SpreadsheetDecryptionException :
    Exception
Public Class SpreadsheetDecryptionException
    Inherits Exception
public class SpreadsheetDecryptionException :
    Exception
Public Class SpreadsheetDecryptionException
    Inherits Exception

Remarks

Note

The sample code which uses the SpreadsheetDecryptionException to load a password-protected file is obsolete. To load a password encrypted file, use the built-in dialog which prompts an end-user for a password, the WorkbookImportOptions.Password property and the ISpreadsheetComponent.EncryptedFilePasswordRequest event.

Examples

This example demonstrates the technique required to to open a password protected .xls file prompting a user for a correct password.

When the Spreadsheet control attempts to open a password protected .xls file and the XlsDocumentImporterOptions.Password property is not set, the control raises the SpreadsheetControl.InvalidFormatException event with the SpreadsheetDecryptionException exception in the event arguments. If this event is not handled, the control cancels loading without any alert.

The method is to subscribe to the InvalidFormatException event, prompt the user for a password, specify the password and call the SpreadsheetControl.LoadDocument.

Note

This technique can be used for password-protected .xls documents created with Microsoft Excel versions up to 2010.

Imports DevExpress.Spreadsheet
Imports DevExpress.XtraSpreadsheet
Imports System.Windows.Forms

Namespace PasswordToOpenSample
    Partial Public Class Form1
        Inherits Form

        Private sourceUri As String
        Private sourceFormat As DocumentFormat

        Public Sub New()
            InitializeComponent()
            AddHandler spreadsheetControl1.BeforeImport, AddressOf spreadsheetControl1_BeforeImport
            AddHandler spreadsheetControl1.InvalidFormatException, AddressOf spreadsheetControl1_InvalidFormatException
        End Sub

        Private Sub spreadsheetControl1_BeforeImport(ByVal sender As Object, ByVal e As DevExpress.Spreadsheet.SpreadsheetBeforeImportEventArgs)
            sourceUri = e.Options.SourceUri
            sourceFormat = e.DocumentFormat
        End Sub
#Region "#decryptionexception"
        Private Sub spreadsheetControl1_InvalidFormatException(ByVal sender As Object, ByVal e As SpreadsheetInvalidFormatExceptionEventArgs)
            Dim decryptionException As SpreadsheetDecryptionException = TryCast(e.Exception, SpreadsheetDecryptionException)
            If decryptionException IsNot Nothing AndAlso sourceFormat = DocumentFormat.Xls Then
                If decryptionException.Error = SpreadsheetDecryptionError.PasswordRequired Then
                    Using form As New PasswordForm()
                        If form.ShowDialog() = System.Windows.Forms.DialogResult.OK Then
                            spreadsheetControl1.Options.Import.Xls.Password = form.Password
                            spreadsheetControl1.LoadDocument(sourceUri)
                            spreadsheetControl1.Options.Import.Xls.Password = String.Empty
                        End If
                    End Using
                ElseIf decryptionException.Error = SpreadsheetDecryptionError.WrongPassword Then
                    MessageBox.Show("Incorrect password", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Stop)
                ElseIf decryptionException.Error = SpreadsheetDecryptionError.EncryptionTypeNotSupported Then
                    MessageBox.Show("Unsupported encryption type.", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Stop)
                End If
            Else
                MessageBox.Show(String.Format("Cannot open the file {0} because file format is not valid.", sourceUri), Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Stop)
            End If
        End Sub
#End Region ' #decryptionexception
    End Class
End Namespace

Inheritance

Object
Exception
SpreadsheetDecryptionException
See Also