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

Export to excel - remove blank formated columns

1 Answer 168 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Hema Raju
Top achievements
Rank 1
Hema Raju asked on 17 Jun 2011, 07:59 AM
Hi,

I have export to excel in my app where exporting the data present in Grid.

The problem here is entire excel sheet is getting formatted (Ex: header background color, borders etc).

I want to format only the columns which are exported from the grid to excel.

Please find the attachment for more information.

Thanks in advance.

Regards,
Hemaraju

1 Answer, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 17 Jun 2011, 09:18 AM
Hello Hemaraju,

The solution is to apply these styles on a cell level and not to the whole row.

e.Item.Style...

foreach(TableCell cell in e.Item.Cells)
      cell.Style...

Regards,
Daniel
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Tags
Grid
Asked by
Hema Raju
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Share this question
or