//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; RadioButtonListCellType cellType = new RadioButtonListCellType { Direction = CellTypeDirection.Horizontal, TextAlign = CellTypeTextAlign.Right, IsFlowLayout = false, MaxColumnCount = 2, MaxRowCount = 1, HorizontalSpacing = 20, VerticalSpacing = 5, }; cellType.Items.Add(new SelectFieldItem("sample1", "1")); cellType.Items.Add(new SelectFieldItem("sample2", "2")); cellType.Items.Add(new SelectFieldItem("sample3", "3")); cellType.Items.Add(new SelectFieldItem("sample4", "4")); cellType.Items.Add(new SelectFieldItem("sample5", "5")); worksheet.Range["A1"].RowHeight = 60; worksheet.Range["A1"].ColumnWidth = 25; worksheet.Range["A1"].CellType = cellType; worksheet.Range["A1"].Value = 1; // Save to a pdf file workbook.Save("AddRadiobuttonListCellType.pdf");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) Dim cellType As New RadioButtonListCellType With { .Direction = CellTypeDirection.Horizontal, .TextAlign = CellTypeTextAlign.Right, .IsFlowLayout = False, .MaxColumnCount = 2, .MaxRowCount = 1, .HorizontalSpacing = 20, .VerticalSpacing = 5 } With cellType.Items .Add(New SelectFieldItem("sample1", "1")) .Add(New SelectFieldItem("sample2", "2")) .Add(New SelectFieldItem("sample3", "3")) .Add(New SelectFieldItem("sample4", "4")) .Add(New SelectFieldItem("sample5", "5")) End With With worksheet.Range!A1 .RowHeight = 60 .ColumnWidth = 25 .CellType = cellType .Value = 1 End With ' save to a pdf file workbook.Save("AddRadiobuttonListCellType.pdf")