Rad grid export to excel

[jayanthi]

Am using rad grid in web application.
Grid display rows with 3 colors (red,green,yellow)
While export to excel it shows the colors, but i need to add header rows programatically.
So i used  <Excel Format="ExcelML" />, but it display rows without colors.

1. How to achieve it while export to excel, i need rows with colors and header rows
2. Also i need to add header in each page

Help me

Thank you
Jayanthi

[jayanthi]

Any ideas?
It's very urgent.

[Princy]

Hi Jayanthi,

Can you try using Excel Format="HTML"  and see if you are able to achieve this scenario.Please go through these documentation where its mentioned about adding styles and headers.
Excel Format (HTML-Based) and HTML-Based Export.

Thanks,
Princy

[Osismii]

Hello,

I do not know if I understand your problem correctly but I think the solutions are as follows:

For you format ExcelML can use something like this:

protected void rgList_OnExcelMLExportStylesCreated(object source, GridExportExcelMLStyleCreatedArgs e)

       {

               foreach (StyleElement style in e.Styles)

               {

                   if (style.Id == "headerStyle")

                   {

                       style.InteriorStyle.Pattern = InteriorPatternType.Solid;

                       style.InteriorStyle.Color = System.Drawing.ColorTranslator.FromHtml("#A05D62");

                   }

                   if (style.Id == "alternatingItemStyle")

                   {

                       style.InteriorStyle.Pattern = InteriorPatternType.Solid;

                       style.InteriorStyle.Color = System.Drawing.ColorTranslator.FromHtml("#COLOR");

                   }

                   if (style.Id.Contains("itemStyle"))

                   {

                       style.InteriorStyle.Pattern = InteriorPatternType.Solid;

                       style.InteriorStyle.Color = System.Drawing.ColorTranslator.FromHtml("#COLOR");

                   }

               }

       }

For the other problem, and if your goal is to add a header to Excel you can use something like this:

protected void rgList_ExcelMLExportRowCreated(object sender, GridExportExcelMLRowCreatedArgs e)
        {


            if (e.RowType == GridExportExcelMLRowType.HeaderRow)
            {
                RowElement row1 = new RowElement();
                CellElement cell1 = new CellElement();
                cell1.MergeAcross = e.Row.Cells.Count - 1;
                cell1.Data.DataItem = "Your text gos here";
                row1.Cells.Add(cell1);
                e.Worksheet.Table.Rows.Insert(0, row1);
                e.Worksheet.AutoFilter.Range = e.Worksheet.AutoFilter.Range.Replace("R1", "R2");

            }
        }

I hope that your problems were these.