Excel Export puts data into 2 rows when it should be 1

[Karl Wilkens]

Hi, we have a large dataset of nearly 200 columns by 250 rows. On screen, the grid presentation is normal with a row-per-record as it should be. However, when exported to Excel and opened in Excel 2008, each record shows in two rows with one row being blank. This results in a row count that is 2x what it should be.

When selecting an individual data item in the resulting excel file, two cells are selected.

The data does not appear to be grouped, at least as far as Excel is concerned.

We have attempted a variety of 'tricks' in Excel to remove the extra rows, but none are perfect and some result in lost data.

Is the issue (2 rows in excel) known and if so, how can we resolve this so that ideally, the excel file appears as it does on screen? We are using .net 2 framework and telerik 2010 Q1 (2010.1.309.20) for this application. Thanks.

[Daniel]

Hello Karl,

Could you please try the following workaround?

protected void RadGrid1_GridExporting(object source, GridExportingArgs e)
{
    if (e.ExportType == ExportType.Excel)
    {
        string css = "<style type='text/css'> br { mso-data-placement: same-cell; } </style>";
        e.ExportOutput = e.ExportOutput.Replace("</head>", css + "</head>");
    }
}

I hope this helps.

Regards,
Daniel
the Telerik team

[Karl Wilkens]

Hi, thanks but unfortunately that had no effect.
I wanted to attach a sample so you could see the data but unfortunately you only allow screen grabs here. Any suggestions?

[Daniel]

Hello Karl,

I would appreciate it if you could submit a support ticket containing a simple runnable project that demonstrates the problem.
This will help me provide a workaround/suggestion/explanation which is suitable for your scenario.

Regards,
Daniel
the Telerik team

[Karl Wilkens]

We ended up using Aspose's library to output the excel file and that generated a desired result.

The data we are using is sensitive health-care related. We have scrubbed it and will add a new ticket with a zip file that contains the .aspx, .vb and xml file that can reproduce the issue directly. Hopefully you can either identify an issue in the data or resolve a bug.

Thanks.

[Daniel]

Hello Karl,

I will do my best to assist you with this problem provided that you submit a runnable project.
Below you can find some suggestions as to how to isolate the issue:
Isolating a problem in a sample project

Thanks in advance

Daniel
the Telerik team

[Dan A]

Hopefully if you resolve this issue you will post a solution here.  Other people have the same issue and would also like to resolve it.

[Daniel]

Hello Dan,

I will gladly try to find a workaround for your problem but first I need to know how to reproduce it. Can you please help me to recreate your scenario?

Regards,
Daniel
the Telerik team