Opening password protected .xls file
06:20 19 Apr 2019

Can I use EPplus to open password protected .xls files?

My current method only works for .xlsx files

    Dim oFileInfo As New FileInfo("C:\Temp\test.xlsx")
    Dim oPackage As New ExcelPackage(oFileInfo, "test")

    For Each oSheet As ExcelWorksheet In oPackage.Workbook.Worksheets
        If oSheet.Name = "Alles" Then
            Debug.Print(oSheet.Cells("A1").Value)
            Exit For
        End If
    Next
epplus