using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DocumentFormat.OpenXml.Spreadsheet;
using com.mksword.Net.OpenXmlTools;
using com.mksword.OpenXmlUtil_log4netTool;
using DocumentFormat.OpenXml.Packaging;
namespace ConsoleApplication5
{
class Class1 : ExcelTool
{
public override void Action()
{
if (_Core.HandOpenSpreadsheetDocumentOnLoacl(UnProtectCell, true))
{
SetLog("UnProcted", OXULogType.INFO);
}
else
{
SetLog("Operation Failed", OXULogType.FATAL);
}
}
private bool UnProtectCell(SpreadsheetDocument SSD)
{
bool result = false;
WorkbookPart WBP = SSD.WorkbookPart;
Workbook WB = WBP.Workbook;
Sheet S = WB.Descendants<Sheet>().Where(SH => SH.Name == "Sheet1")
.FirstOrDefault();
if (S != null)
{
WorksheetPart WSP = WBP.GetPartById(S.Id) as WorksheetPart;
Worksheet WS = WSP.Worksheet;
SheetProtection SP = WS.Descendants<SheetProtection>()
.FirstOrDefault();
if (SP != null)
{
SetLog(SP.Password.Value, OXULogType.FATAL);
SP.Remove();
WS.Save();
result = true;
}
else
SetLog("SheetProtection in NULL", OXULogType.FATAL);
}
else
SetLog("Sheet is NULL", OXULogType.FATAL);
return result;
}
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");
}
}
}
OpenXml获取被保护Sheet的密码并解除保护
最新推荐文章于 2022-11-21 17:55:21 发布