Blog

RadGrid Export To Excel with Excel Basic Styles

Posted by Subramanyam Rompicherla Blogs | ASP.NET Programming Dec 07, 2012
RadGrid Export To Excel with excel basic styles like borders, cell text wrapping, header text, alternative row colors.

Using below code steps to get the basic excel styles in RadGrid Exporting data to Excel.

1. Add the event in the radgrid like below:

OnExcelMLExportStylesCreated="rgdReport_OnExcelMLExportStylesCreated"

2. Add the event in code behind for:

protected void rgdReport_OnExcelMLExportStylesCreated(object source, GridExportExcelMLStyleCreatedArgs e)
{
   // To set the Excel cell borders style

orderStylesCollection borders = new BorderStylesCollection();

   BorderStyles borderStyle = null;

   for (int i = 1; i <= 4; i++)

   {

      borderStyle = new BorderStyles();

      borderStyle.PositionType = (PositionType)i;

      borderStyle.Color = System.Drawing.Color.Black;

      borderStyle.LineStyle = LineStyle.Continuous;

      borderStyle.Weight = 1.0;

      borders.Add(borderStyle);

   } 

  

// styles have to set for export excel

   foreach (StyleElement style in e.Styles){

      //For Header style - background color

      if (style.Id == "headerStyle"){

            style.InteriorStyle.Pattern = InteriorPatternType.Solid;

            style.InteriorStyle.Color = System.Drawing.Color.Gray;

      }

      //For alternate row style - background color

      if (style.Id == "alternatingItemStyle" || style.Id == "alternatingPriceItemStyle" || style.Id == "alternatingPercentItemStyle" || style.Id == "alternatingDateItemStyle"){

            style.InteriorStyle.Pattern = InteriorPatternType.Solid;

            style.InteriorStyle.Color = System.Drawing.Color.LightGray;

      }

      if

(

style.Id.Contains("itemStyle") || style.Id == "priceItemStyle" || style.Id == "percentItemStyle" || style.Id == "dateItemStyle")   {

      style.InteriorStyle.Pattern = InteriorPatternType.Solid;

      style.InteriorStyle.Color = System.Drawing.Color.White;

      }

     

// for each cell border styles

      foreach (BorderStyles border in borders)

      {

         style.Borders.Add(border);

      }

     

// Each cell text wrapping

      style.AlignmentElement.Attributes.Add("ss:WrapText", "1");

}

}

3. From above code we can get below styles:

  1. n excel export data get borders
  2. Export data can wrap on each cell
  3. Export data alternative rows colors
  4. Export data header styles

References

http://www.telerik.com/community/forums/aspnet-ajax/grid/radgrid-export-data-to-excel.aspx
http://www.telerik.com/community/forums/aspnet-ajax/grid/wrapping-text-in-an-excel-cell-via-gridexcelbuilder.aspx

COMMENT USING
PREMIUM SPONSORS
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.
SPONSORED BY
  • MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.