private void spreadsheetControl1_InvalidFormatException(object sender, SpreadsheetInvalidFormatExceptionEventArgs e) { SpreadsheetDecryptionException decryptionException = e.Exception as SpreadsheetDecryptionException; if (decryptionException != null && sourceFormat == DocumentFormat.Xls) { if (decryptionException.Error == SpreadsheetDecryptionError.PasswordRequired) { using (PasswordForm form = new PasswordForm()) { if (form.ShowDialog() == System.Windows.Forms.DialogResult.OK) { spreadsheetControl1.Options.Import.Xls.Password = form.Password; spreadsheetControl1.LoadDocument(sourceUri); spreadsheetControl1.Options.Import.Xls.Password = string.Empty; } } } else if (decryptionException.Error == SpreadsheetDecryptionError.WrongPassword) { MessageBox.Show("Incorrect password", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Stop); } else if (decryptionException.Error == SpreadsheetDecryptionError.EncryptionTypeNotSupported) { MessageBox.Show("Unsupported encryption type.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Stop); } } else { MessageBox.Show(string.Format("Cannot open the file {0} because file format is not valid.", sourceUri), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Stop); } }
void book_InvalidFormatException(object sender, SpreadsheetInvalidFormatExceptionEventArgs e) { }