This is a migrated thread and some comments may be shown as answers.

Blank Rows when Exporting to Excel From Telerik Report

1 Answer 245 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
David
Top achievements
Rank 1
David asked on 10 Jun 2013, 07:01 PM
For every row in the report I get one or three blank rows, when exporting to Excel From my Telerik report. 
How can I remove them?
The report has:
Status   Type  Subtype                        Agency Agency ID   
Active    Air     Emergency Generator  DEP      EXP7968705022013-3  
Active    Air     Emergency Generator  DEP      EXP7968705022013-4  
Active    Air     Emergency Generator  DEP      EXP7968705022013-6  
Active    Air     Emergency Generator  DEP      EXP7968705022013-7  
Active    Air     Emergency Generator  DEP      EXP7968705022013-8  
Active    Air     Emergency Generator  DEP      EXP7968705022013-2  
Active    Air     Emergency Generator  DEP      PA067182Z  
Active    Air     Emergency Generator  DEP      PA010895L  
but the spreadsheet has:
Status Type Subtype Agency Agency ID
                       
  Active Air Emergency Generator DEP EXP7968705022013-3
             
  Active Air Emergency Generator DEP EXP7968705022013-4
             
  Active Air Emergency Generator DEP EXP7968705022013-6
             
  Active Air Emergency Generator DEP EXP7968705022013-7
             
  Active Air Emergency Generator DEP EXP7968705022013-8
             
  Active Air Emergency Generator DEP EXP7968705022013-2
             
                       
  Active Air Emergency Generator DEP PA067182Z
                   
                       
                       
  Active Air Emergency Generator DEP PA010895L
                   
                       
                       
It also seem to have some extra columns.
How can I remove them?


1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 13 Jun 2013, 07:28 AM
Hello David,

Please check the Design Considerations for Excel Rendering help article which elaborates on the way items are rendered in Excel.

If you need further help, please post your report definition, so we can check the created layout and used items. Also specify the used Telerik Reporting version.

Regards,
Stef
Telerik

Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

Tags
General Discussions
Asked by
David
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or