Page History

{description}
{excerpt}If you set [EncryptPassword|ExcelTemplate.EncryptPassword], ExcelWriter will encrypt the generated spreadsheet \- when [Process|ExcelTemplate.Process()] is called \- using RC4 encryption. 
{excerpt}
{signature:C#}
 public System.String EncryptPassword{ get; set; }

{signature}
{signature:vb.net

}
Public Property EncryptPassword() As String

{signature}
{remarks}
Set {{EncryptPassword}} to a string no longer than 15 characters.  Use this string to decrypt the file, either in Microsoft Excel or by setting [DecryptPassword|ExcelTemplate.DecryptPassword].

Set {{EncryptPassword}} *before* calling {{Process}}.
{remarks}
{example}{code:csharp|title=C#}

          ExcelTemplate xlt = new ExcelTemplate();
          xlt.EncryptPassword = "MyPassword";
        

{code}
{code:vb.net

|title=vb.net

}

          Dim xlt As New ExcelTemplate()
          xlt.EncryptPassword = "MyPassword"
        {code}

{example}