//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet activeSheet = workbook.ActiveSheet; ISignatureSetup setup = workbook.Signatures.AddSignatureLine(activeSheet, 100.0, 50.0).Setup; setup.ShowSignDate = false; setup.AllowComments = false; setup.SigningInstructions = "Please check the content before signing."; setup.SuggestedSigner = "Shinzo Nagama"; setup.SuggestedSignerEmail = "shinzo.nagama@ea.com"; setup.SuggestedSignerLine2 = "Commander (Balanced)"; // Save to an excel file workbook.Save("AddSignatureLines.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim activeSheet As IWorksheet = workbook.ActiveSheet With workbook.Signatures.AddSignatureLine( activeSheet, 100.0, 50.0).Setup .ShowSignDate = False .AllowComments = False .SigningInstructions = "Please check the content before signing." .SuggestedSigner = "Shinzo Nagama" .SuggestedSignerEmail = "shinzo.nagama@ea.com" .SuggestedSignerLine2 = "Commander (Balanced)" End With ' save to an excel file workbook.Save("AddSignatureLines.xlsx")