To decrypt an encrypted template, set DecryptPassword to the password set using EncryptPassword or in Microsoft Excel (Tools -> Options... -> Security).

 public System.String DecryptPassword{ get; set; }

Public Property DecryptPassword() As String

Set DecryptPassword before calling Open.


          ExcelTemplate xlt = new ExcelTemplate();
          xlt.DecryptPassword = "password";
          xlt.Open(Application["templatepath"] +
               @"\DataBinding\EmployeeOrdersTemplate.xls");
        

          Dim xlt As New ExcelTemplate()
          xlt.DecryptPassword = "password"
          xlt.Open(Application["templatepath"] & _
               "\DataBinding\EmployeeOrdersTemplate.xls")