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

How to add gridline to export excel file

2 Answers 242 Views
Grid
This is a migrated thread and some comments may be shown as answers.
york
Top achievements
Rank 1
york asked on 24 Jun 2011, 09:50 PM
Hi,
I want to add gridline to the export excel file. How to do it? Thanks.

2 Answers, 1 is accepted

Sort by
0
Accepted
Shinu
Top achievements
Rank 2
answered on 27 Jun 2011, 07:06 AM
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.
0
AR
Top achievements
Rank 1
answered on 22 Feb 2017, 09:54 AM

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.

 

 

Tags
Grid
Asked by
york
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
AR
Top achievements
Rank 1
Share this question
or