[Solved] How to add gridline to export excel file

[york]

Hi,
I want to add gridline to the export excel file. How to do it? Thanks.

[Shinu]

Hello York,

Try setting the GridLines property to Both and see whether the Grid lines are getting exported.
aspx:

<telerik:RadGrid runat="server" ID="RadGrid1" DataSourceID="SqlDataSource1"  GridLines="Both" >
    <ExportSettings FileName="Customers" Excel-Format="HTML"  >
    </ExportSettings>

Thanks,
Shinu.

[AR]

Hi Team,

Even after adding GridLines="Both" i am not able to get gridlines in excel after exporting data to excel from radgrid.

Attached is screenshot of code and exported excel.

Looking forward for your valuable response, thanks for your cooperation and support in advance.