Excel export missing header graphic & column headers

[Pat]

Hey all,
We have a telerik grid displaying data as well as an export control to PDF and Excel. 
The PDF still works fine and all looks well (data, graphic at top, header column titles, shading etc...). 
The Excel did work and now does not. Actually the excel export displays just the data but does not display the graphic at the top of the page, the header column titles, shading between breaks etc. 
The PDF uses the same designer as the excel routine. 
I'm needing some things to look into and check. 
The original code author is no longer in the picture and I'm responsible for support.

Thanks,
Pat in Omaha

[Dimitrina]

Hi Pat,

When you export to Excel with ExportFormat.Html, then you can set the e.Styles dictionary with proper CSS values for styling the element to be exported when the ElementExporting is raised for the RadGridView. 

You could also apply some styling (Background, Foreground, Font) as demonstrated on the Exporting online example. Still it does not have the options that the RadDocument can suggest.
 

All the best,
Didie
the Telerik team

[Pat]

Thanks for the reply Didie. I have researched this issue a bit more and now think I may have worded my initial post differently.

The short story:
We have three exports going through the same designer/template. Only the Excel looks bad, missing the first two columns and not displaying a "Report Header Graphic" that shows up on the other two.

More info:
We have a data return that fills a Telerik grid, on screen there is an export control giving the user the option for a PDF, an MS Word doc or an Excel spreadsheet. 

The three different options all use the same designer file, they all go to the DB and grab the same data, come back and bind to the export. The PDF looks great and has the graphic and column headings but the Excel output is missing the first two columns entirely, the column headings and the graphic. Wacky stuff.

What is the difference if I may ask?

Thanks,
Pat G in Omaha

[Dimitrina]

Hi,

Those are the capabilities of the inbuilt export functionality. As you need more complicated export to Excel, what I can suggest you is to check our Reporting tools (Telerik Reporting).

Regards,
Didie
the Telerik team

[Pat]

Didie,
Good news. There really wasn't anything 'wrong' with the excel export. It is exported as an Excel 2003 (.xls) format or version. I saved the spreadsheet off locally and opened it up in MS Excell 2003 view and it looked great. 
So... we are running ver 5.1.11 Telerik Reporting. Can you tell me what version supports or kicks out an Excel 2010 (.xlsx) file? 

Thanks,
Pat G.
Omaha NE

[Stef]

Hello Pat,

Please check my colleagues post about the xlsx format in Telerik Reporting applicable to Q2 2011: New export options on Telerik.Reporting Version 5.0.11.316?

I hope this helps.

Regards,
Stef
Telerik