I am trying to figure out why a blank row is appearing between each row of data in the excel file that gets exported from my radgrid. Here is how I am doing the export:
I am at a loss as to why that is happening. Anyone run into this and if so, what is the solution?
grdMetricsClosed.ExportSettings.ExportOnlyData =
true
;
grdMetricsClosed.ExportSettings.IgnorePaging =
true
;
grdMetricsClosed.ExportSettings.OpenInNewWindow =
true
;
foreach
(GridColumn col
in
grdMetricsClosed.MasterTableView.RenderColumns)
{
col.Visible =
true
;
}
grdMetricsClosed.MasterTableView.ExportToExcel();
I am at a loss as to why that is happening. Anyone run into this and if so, what is the solution?