Open XML SDK 2.0

http://msdn.microsoft.com/en-us/library/bb448854

http://msdn.microsoft.com/en-us/library/gg278316%28v=office.14%29

http://msdn.microsoft.com/en-us/library/cc850837 ---how to 

 

Excel加密

將想要設定的密碼傳入Mothed 1得到加密密碼，將加密密碼傳給workbookPassword，即實現加密。

SheetProtection wSheetProtection = new SheetProtection() { Password = workbookPassword,Sheet = true, Objects = true, Scenarios = true };

 

Mothed 1 :

 

    public String GetSheetPassword(String password)    {      Int32 pLength = password.Length;      Int32 hash = 0;      if (pLength == 0) return hash.ToString("X");      for (Int32 i = pLength - 1; i >= 0; i--)      {        hash = hash >> 14 & 0x01 | hash << 1 & 0x7fff;        hash ^= password[i];      }      hash = hash >> 14 & 0x01 | hash << 1 & 0x7fff;      hash ^= 0x8000 | 'N' << 8 | 'K';      hash ^= pLength;      return hash.ToString("X");    }