Preserving cell style when exporting to Excel

[Joel Brom]

I have a RadGrid that I am establishing cell styles in the itemdatabound method.  I export this grid to Excel .

     <ExportSettings HideStructureColumns="true" ExportOnlyData="false" IgnorePaging="true" Excel-Format="ExcelML" OpenInNewWindow="true" >
     </ExportSettings>

How do I preserve the cell styles (color, text color, bolding, etc ) that I set in the grid .

[Maria Ilieva]

Hi Joel,

Due to the fact that this format is based on standard HTML/CSS it is quite straightforward to control the appearance of the output using inline styles. You can apply CSS tags/classes to the cells/rows/tables, etc.
Please review the followinh help topic for more information of RadGrid export styling.

Kind regards,
Maria Ilieva
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Joel Brom]

I must be doing something wrong because the  OnExcelExportCellFormatting method is not being executed.  The export is accomplished via the following code

    protected void ExportToExcel(object sender, System.EventArgs e)
    {
        RptCrdGrdGrid.ExportSettings.ExportOnlyData = false;
        RptCrdGrdGrid.ExportSettings.IgnorePaging = true;
        RptCrdGrdGrid.ExportSettings.OpenInNewWindow = true;

        RptCrdGrdGrid.MasterTableView.ExportToExcel();
    }

 

 

 

[Maria Ilieva]

Hi Joel,

Please accept apologize for the previous post. I did not notice that in the Export settings tag you have Excel-Format="ExcelML”. If this is the correct format you need to export to, please refer to the following help topic.

I hope this helps. Let us know if further assistance is needed

Sincerely yours,
Maria Ilieva
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Joel Brom]

Things I needed to do to implement this
1. Add using statement for Telerik.Web.UI.GridExcelBuilder
2. Add OnExcelMLExportRowCreated to the RadGrid definition
3. Add OnExcelMLExportStylesCreated to the RadGrid definition

I see that I can now format cells by name.  It appears that setting the myStyle.InteriorStyle.Color = System.Drawing.Color.Blue
has no effect.
I need to generate different styles within the cells based on the value (text) of the cell.  I do not see a Get Method for the text or value.
Is this possible?

[Maria Ilieva]

Hello Joel,

In order to set properly the cell format you should also add pattern setting. For example:

style.InteriorStyle.Pattern = InteriorPatternType.Solid;

Please find attached a sample application which demonstrates the required functionality.
Test it on your side and let me know if it helps.

Regards,
Maria Ilieva
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.