//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; ComboBoxCellType cellType = new ComboBoxCellType { EditorValueType = EditorValueType.Value }; ComboBoxCellItem item = new ComboBoxCellItem { Value = "US", Text = "United States" }; cellType.Items.Add(item); item = new ComboBoxCellItem { Value = "CN", Text = "China" }; cellType.Items.Add(item); item = new ComboBoxCellItem { Value = "JP", Text = "Japan" }; cellType.Items.Add(item); worksheet.Range["C5"].CellType = cellType; worksheet.Range["C5"].Value = "CN"; // Save to a pdf file workbook.Save("AddComboBoxCellType.pdf");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) Dim cellType As New ComboBoxCellType With { .EditorValueType = EditorValueType.Value } cellType.Items.Add(New ComboBoxCellItem With { .Value = "US", .Text = "United States" }) cellType.Items.Add(New ComboBoxCellItem With { .Value = "CN", .Text = "China" }) cellType.Items.Add(New ComboBoxCellItem With { .Value = "JP", .Text = "Japan" }) With worksheet.Range!C5 .CellType = cellType .Value = "CN" End With ' save to a pdf file workbook.Save("AddComboBoxCellType.pdf")