public void EncryptedFile()
{
using (OfficeCryptoStream s = OfficeCryptoStream.Open("test.xlsx"))
{
s.Password = "******";
s.Save();
}
}
void ChangePassword(String oldPassword, String newPassword)
{
using (OfficeCryptoStream s = OfficeCryptoStream.Open(TestFile, oldPassword))
{
s.Password = newPassword;
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();
}
public static void CreateEncryptedFile()
{
using (OfficeCryptoStream stream = OfficeCryptoStream.Create("a.xlsx"))
{
DoStuff(stream);
// Set or change the password anytime before the save.
// Set to null to save as plaintext.
stream.Password = "******";
stream.Save();
}
}
void CreateTestWorkbook(String password)
{
using (OfficeCryptoStream s = OfficeCryptoStream.Create(TestFile))
{
s.Password = password;
using (ExcelPackage p = new ExcelPackage(s))
{
ExcelWorksheet ws = p.Workbook.Worksheets["Test"];
if (ws == null)
{
ws = p.Workbook.Worksheets.Add("Test");
}
ws.Cell(1, 1).Value = "Test Cell";
p.Save();
}
s.Save();
}
}
