Here is some sample code to remove all digital signatures from an Excel workbook. This can be run from a Windows app or Console app. I'm going to try to make it work within a SharePoint document library event handler. That should be interesting. Basically the idea is to have a document library that has a bunch of documents that are digitally signed and then every month get reset by removing all the digital signatures. Hope this runs in the event handler.
Microsoft.Office.Interop.Excel.Application eApp = null; Microsoft.Office.Interop.Excel.Workbook wb = null;
//gets our workbook
eApp = new Microsoft.Office.Interop.Excel.Application();
wb = eApp.Workbooks.Open(textBox1.Text, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
//makes it visible and activates the workbook
//eApp.Visible = true;
//wb.Activate();
//get signatures
Microsoft.Office.Core.SignatureSet sigs = wb.Signatures;
//remove all the signatures
foreach (Microsoft.Office.Core.Signature sig in sigs)
{ sig.Delete(); }
//save and close the form
wb.Save();
wb.Close(Type.Missing, Type.Missing, Type.Missing);
wb = null;
eApp = null;
Subscribe to:
Post Comments (Atom)
3 comments:
Thanks a lot for giving the code.I am facing a problem of this kind. I will certainly try it and will let you know.
public private key
thanks
I was searching for the code for removing all digital signatures from an Excel sheet.You really saved a lot of my time.I will try to use this.Thanks
Post a Comment