Excel export missing header graphic & column headers

6 posts, 0 answers
  1. Pat
    Pat avatar
    3 posts
    Member since:
    Apr 2011

    Posted 29 Apr 2013 Link to this post

    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
  2. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 01 May 2013 Link to this post

    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

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  3. DevCraft banner
  4. Pat
    Pat avatar
    3 posts
    Member since:
    Apr 2011

    Posted 17 May 2013 Link to this post

    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
  5. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 18 May 2013 Link to this post

    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

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  6. Pat
    Pat avatar
    3 posts
    Member since:
    Apr 2011

    Posted 31 May 2013 Link to this post

    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
  7. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 05 Jun 2013 Link to this post

    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

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Back to Top
DevCraft banner