Export to Excel

[bkagan98]

When I cancel the grid_ElementExporting event for all cells in the row, but not for the row itself, it leaves an empty record in Excel file. Is there any way to eliminate these empty records? Please advise. Thanks.

grid_ElementExporting()

private void grdDataView_ElementExporting(object sender, GridViewElementExportingEventArgs e)
{
    if (e.Element == ExportElement.HeaderCell || e.Element == ExportElement.Cell)
    e.Cancel = true;
}

grid_ElementExported()

private void grdDataView_ElementExported(object sender, GridViewElementExportedEventArgs e)
{
    if (e.Element == ExportElement.HeaderRow)
    {
        e.Writer.Write(String.Format(@"<td>{0}</td>", "Plan Code"));
    }

    if (e.Element == ExportElement.Row)
    {
        JobDetailModel obj = e.Context as JobDetailModel;
        e.Writer.Write(String.Format(@"<td>{0}</td>", obj.PlanCode));
    }
}

resulting Excel file - see attached picture.

[Dimitrina]

Hi Boris,

 You have empty records as you do not exclude them when exporting. That is why the ElementExported event is fired for these rows. If you want to remove these rows from the result excel file, you should remove all empty rows in the output stream, like:

var strm = new MemoryStream();
                    this.clubsGrid.Export(strm, exportOptions);
                    var reader = new StreamReader(strm);
                    strm.Position = 0;
                    var text = reader.ReadToEnd();
                    text = text.Replace("<tr>\r\n</tr>", "");
                    var writer = new StreamWriter(stream);
                    writer.Write(text);
                    writer.Flush();

I have prepared a sample project, showing this. You may review how it is working.

Regards,
Didie
the Telerik team

[bkagan98]

Hi Didie,

My data grid contains hundreds of thousands records and if I do everything in the memory stream, will it affect the performance?

Thanks.

[bkagan98]

That worked. One more question: would it be possible to show gridlines in generated XLS file? If yes, would you please tell how? Thanks.

[Dimitrina]

Hi Boris,

Unfortunately showing gridlines in generated export XLS file would not be possible.

If you have any further questions, please do not hesitate to contact us.

Greetings,
Didie
the Telerik team

[Prithvi]

Hi,
Am very new to telerick control. Please let me know how to export data from radGridview to Excel (SILVERLIGHT). Please help me

While esporting the data if there is date field/combo box field in RadGrid, that data is not getting export to Excel instead it is showing empty cell(data missing ).

Thanks in advance. please help me.


Prithvi