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