Export to EXCEL extra BLANK rows

5 posts, 0 answers
  1. Mike
    Mike avatar
    338 posts
    Member since:
    Jun 2008

    Posted 17 Feb 2009 Link to this post

    I followed the wizzard and made no changes to the report layout besides what the wizzard did and when I export to Excel there are two extra blank rows between every row of data.  What is causing this?

    The report has a labels group header and detail...
  2. Steve
    Steve avatar
    10941 posts

    Posted 18 Feb 2009 Link to this post

    Hello Mike,

    We leave some space on top and on bottom of the items by design. You can easily remove it by zooming and making sure all items "fit" exactly to the details' section top and then squeeze its bottom to the items' bottoms.
    As you know we are currently working on crosstab/table item and once it is ready, we would modify the report wizard to use table directly to avoid such inconsistencies.

    Best wishes,
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  3. Mark
    Mark avatar
    2 posts
    Member since:
    Oct 2014

    Posted 07 Oct 2014 in reply to Steve Link to this post

    I have zoomed in to 400% and have tightened up my fields in the Details section to where it looks as tight as it can be and I'm still getting extra rows in Excel when I export. Is there another trick involved?
  4. Mark
    Mark avatar
    2 posts
    Member since:
    Oct 2014

    Posted 07 Oct 2014 in reply to Mark Link to this post

    Also, there are many, many columns separating the data fields.  How do I eliminate those?
  5. Stef
    Stef avatar
    3610 posts

    Posted 09 Oct 2014 Link to this post

    Hello Mark,

    Please check the suggestion in the Design Considerations for Excel Rendering article under Merging Cells.

    If yuo need further help, feel free to open a support ticket and send us details about the used Telerik Reporting versions, the report code files, including test data to run them.


    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top