[Solved] Remove all Styles for Excel Export

[Robert]

Is there an easy way to remove all styling for an Excel export.  Out of the box I get an export with a background color and no grid lines. Is there a way to prevent any style from passing to the Excel document?

[Schlurk]

The following should export just data, and no styles etc.:

this.RadGrid1.ExportSettings.ExportOnlyData = true;

You can find more info about it in this documentation article.

[Daniel]

Hello Robert,

This is the way Microsoft Excel interprets the HTML Excel content. If you open the output file in Notepad++ or similar, you will notice that we don't explicitly set background color or grid lines.

I recommend you switch to ExcelML format if this appearance is not suitable for your scenario.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.