We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Export to excel generates extra lines

We are using the GridGroupingControl to export a dataset into an excel file. This is working ok, except that the generated file has 3 extra rows at the top of the file - 2 blank lines a a line that says "Table: n Items".

Is there an easy way to make it so these extra lines are not generate with the export?

Example code:
var syncGrid = new GridGroupingControl
    DataSource = data.Tables[0]
excel.ExportNestedTable = true; excel.Export();

Any help with this would be greatly appreciated.


4 Replies

ES Eswari S Syncfusion Team February 17, 2014 04:24 AM UTC

Hi Jo,


Thank you for using Syncfusion products.


We were unable to reproduce the issue. We have prepared vide demonstrating of the sample and the same can be downloaded from the following link:






Could you please try with the sample and if still issue reproduces please provide us some more information regarding the issue or else please modify the sample to reproduce the issue so that we can analyze based on that and provide you better solution.


Please try this and let us know if you have any queries.



Eswari S

JS Jo Scothern February 17, 2014 08:09 PM UTC

Thanks Eswari,

We were using an older version, so I guess I will simply need to update to get rid of two of the blank lines.

Is it possible to get rid of the line that mentions the number of items in the table, in your example it says:

"Table1: 13 Items ( Showing 1 to 12 )"


ES Eswari S Syncfusion Team February 19, 2014 10:37 AM UTC

Hi Jo,


Thanks for your update.


The reported issue “ Setting Caption Row (Table1: 13 Items ( Showing 1 to 12 ))  as false , gives blank row while exporting ” is suspected to be defect and we will update you with further validation details on 02/21/2014.


Also could you please share the Essential Studio current version which you are using and screenshot of the exported sheet which contains two blank lines or sample files of the grid ? Since we can able to reproduce one blank row issue by setting caption row as false , not two blank rows as you have specified. The information provided would be of great help in resolving the issue.


Let us know if you have any queries.



Eswari S

ES Eswari S Syncfusion Team February 21, 2014 09:13 AM UTC


Hi Jo,


Thanks for your patience.


We are able to reproduce the issue “Removing Blankrow with Showcaption(false)”, in order for you to get a solution for this behaviour, please contact us at Syncfusion Support or you may also open a support ticket by login in to direct trac account and mention this forum link for reference.


Please let us know if you need any further assistance.



Eswari S


Live Chat Icon For mobile
Up arrow icon