//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; CheckBoxCellType cellType = new CheckBoxCellType { Caption = "Caption", TextTrue = "True", TextFalse = "False", TextIndeterminate = "Indeterminate", IsThreeState = true, TextAlign = CheckBoxAlign.Right }; worksheet.Range["C5:C6"].CellType = cellType; worksheet.Range["C5"].Value = true; worksheet.Range["C6"].Value = false; // Save to a pdf file workbook.Save("AddCheckBoxCellType.pdf");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) Dim cellType As New CheckBoxCellType With { .Caption = "Caption", .TextTrue = "True", .TextFalse = "False", .TextIndeterminate = "Indeterminate", .IsThreeState = True, .TextAlign = CheckBoxAlign.Right } worksheet.Range("C5:C6").CellType = cellType worksheet.Range!C5.Value = True worksheet.Range!C6.Value = False ' save to a pdf file workbook.Save("AddCheckBoxCellType.pdf")