void ChangePassword(String oldPassword, String newPassword)
{
using (OfficeCryptoStream s = OfficeCryptoStream.Open(TestFile, oldPassword))
{
s.Password = newPassword;
s.Save();
}
}
public void EncryptedFile()
{
using (OfficeCryptoStream s = OfficeCryptoStream.Open("test.xlsx"))
{
s.Password = "******";
s.Save();
}
}
public static void AccessEncryptedFile()
{
using (OfficeCryptoStream stream = OfficeCryptoStream.Open("a.xlsx", "password"))
{
DoStuff(stream);
stream.Save(); // Skip this line if you don't want to save/encrypt
}
}
public static void AccessPlaintextFile()
{
using (OfficeCryptoStream stream = OfficeCryptoStream.Open("a.xlsx"))
{
DoStuff(stream);
stream.Save();
}
}
void CreateTestWorkbook(String password)
{
using (OfficeCryptoStream s = OfficeCryptoStream.Open(TestFile))
{
s.Password = password;
s.Save();
}
}
public static void AccessEncryptedFileManualSave()
{
// Create stream, decrypt
OfficeCryptoStream stream = OfficeCryptoStream.Open("a.xlsx", "password");
// Do whatever is needed in your program
DoStuff(stream);
// When done, save and close the encrypted stream
stream.Save();
stream.Close();
}
void AssertFileCorrect(String password)
{
using (OfficeCryptoStream s = OfficeCryptoStream.Open(TestFile, password))
{
using (ExcelPackage p = new ExcelPackage(s))
{
Assert.IsNotNull(p, "Cannot create package.");
ExcelWorksheet ws = p.Workbook.Worksheets["Test"];
Assert.IsNotNull(ws, "No Test worksheet.");
String cval = ws.Cell(1, 1).Value;
Assert.AreEqual("Test Cell", cval, "First cell value incorrect.");
}
}
}