Opening password protected .xls file
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