Articles in this section
Category / Section

How to identify a password protected excel document and provide the password dynamically?

1 min read

If an excel document is encrypted with a password, XlsIO supports to raise an event to provide the password dynamically. The code snippets to provide password dynamically is given below.

C#

         
 private void btnCreate_Click(object sender, System.EventArgs e)
 {
     ExcelEngine excelEngine = new ExcelEngine();
 
                IApplication application = excelEngine.Excel;
 
                application.OnPasswordRequired += application_OnPasswordRequired;
 
               IWorkbook workbook;
 
                string inputPath = GetFullTemplatePath("Sample.xlsx");
 
                workbook = application.Workbooks.Open(inputPath, ExcelOpenType.Automatic);                     
 
                IWorksheet sheet = workbook.Worksheets[0];
 
                workbook.Version = ExcelVersion.Excel2010;
                string fileName = @"../../Output/Output.xlsx";
 
                workbook.SaveAs(fileName);
 }
 
         void application_OnPasswordRequired(object sender, PasswordRequiredEventArgs e)
         {
                e.NewPassword = "syncfusion";
         }
 

VB

            Dim excelEngine As ExcelEngine = New ExcelEngine()
 
            Dim application As IApplication = excelEngine.Excel
 
            application.OnPasswordRequired += application_OnPasswordRequired
 
            Dim workbook As IWorkbook
 
            Dim inputPath As String = GetFullTemplatePath("Sample.xlsx")
 
            workbook = application.Workbooks.Open(inputPath, ExcelOpenType.Automatic)
 
            Dim sheet As IWorksheet = workbook.Worksheets(0)
 
            workbook.Version = ExcelVersion.Excel2010
            Dim fileName As String = "../../Output/Output.xlsx"
 
            workbook.SaveAs(fileName)
 
        Private Sub application_OnPasswordRequired(ByVal sender As Object, ByVal e As PasswordRequiredEventArgs)
            e.NewPassword = "syncfusion"
        End Sub 

 

The sample illustrating the behavior can be downloaded here.

 

 

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments
Please sign in to leave a comment
Access denied
Access denied