Hi,
We are using ExportToXlxs to export data from RadGridView in our application. Wondering, how to write additional data to the stream like below using the ElementExportingToDocument event. Thanks!
private void RadGridView1_ElementExported(object sender, GridViewElementExportedEventArgs e)
{
if (e.Element == ExportElement.Row)
{
Employees obj = e.Context as Employees;
if (obj != null)
{
e.Writer.Write(String.Format(@"<
tr
><
td
style
=
""
background-color:#CCC;""
colspan
=
""
{0}"">",
((IEnumerable<
Telerik.Windows.Controls.GridViewColumn
>)RadGridView1.Columns).Count()));
e.Writer.Write(String.Format(@"<
b
>Birth date:</
b
> {0} <
br
/>", obj.BirthDate));
e.Writer.Write(String.Format(@"<
b
>Hire date:</
b
> {0} <
br
/>", obj.HireDate));
e.Writer.Write(String.Format(@"<
b
>Address:</
b
> {0} <
br
/>", obj.Address));
e.Writer.Write(String.Format(@"<
b
>City:</
b
> {0} <
br
/>", obj.City));
e.Writer.Write(String.Format(@"<
b
>Notes:</
b
> {0} <
br
/>", obj.Notes));
e.Writer.Write("</
td
></
tr
>");
}
}
}