or
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using Telerik.WinControls.UI;namespace TestTelerikGrid3{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { HtmlViewDefinition view = new HtmlViewDefinition(); view.RowTemplate.ReadXml("GridLayout.htm"); radGridView1.ViewDefinition = view; radGridView1.Font = new Font("Segoe UI", 15.75F,FontStyle.Regular); radGridView1.AutoSizeRows = true; } }}<table><tr> <td colspan="2">Column1</td></tr><tr> <td>Column2</td> <td>Column3</td></tr></table>
I;m giving herebelow an example of code to create a drop down list using the Excel Interop assemblies but which I'd like to use/convert with the faster ExportToExcelML method:
Private Sub AddCategoryValidationList(ByVal rng As Excel.Range)
With
rng.Validation
.Add(Excel.XlDVType.xlValidateList, _
Excel.XlDVAlertStyle.xlValidAlertStop, _
1,
"=Beneficiaries!$A$1:$A$1000")
.InCellDropdown =
True
.ErrorTitle =
"Stock release form"
.InputMessage =
"Please select a beneficiairy"
.ErrorMessage =
"The value you have entered is not a " & _
"valid beneficiary. Please select a beneficiary from " & _
"the list."
.ShowInput =
True
.ShowError =
True
End With
End Sub