Exporting from RadGrid to Excel - multiple cell problem RSS

5 replies

Last post Dec 28, 2012 03:41 AM by Decker Dong - MSFT

‹ Previous Thread|Next Thread ›

Shortcuts

- Reply
wallace740
Member

33 Points

135 Posts

Exporting from RadGrid to Excel - multiple cell problem

Dec 27, 2012 09:58 AM|wallace740|LINK

I have a situation where my RadGrid has some rows Containing multiple rows

When I export this using RadGrid's export functionality, I see multiple cells used for 1 cell
- Reply
oned_gk
All-Star

52523 Points

15678 Posts

Re: Exporting from RadGrid to Excel - multiple cell problem

Dec 27, 2012 10:22 AM|oned_gk|LINK
what i know rg has export feature, you dont need export manualy like gv. You can export rg to many format. See documentasion. demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/exporting/defaultcs.aspx

Programming to simplify, don't look for difficult way
Suwandi - Non Graduate Programmer
- Reply
wallace740
Member

33 Points

135 Posts

Re: Exporting from RadGrid to Excel - multiple cell problem

Dec 27, 2012 10:36 AM|wallace740|LINK

<ExportSettings IgnorePaging="True" HideStructureColumns="true" ExportOnlyData="True">
</ExportSettings>

ShowExportToExcelButton="True"

I use these values with RadGrid and when I export to Excel, it generates a separate cell for each row (which I cant leave like that)
- Reply
Decker Dong...
All-Star

94130 Points

18109 Posts

Re: Exporting from RadGrid to Excel - multiple cell problem

Dec 27, 2012 08:29 PM|Decker Dong - MSFT|LINK

wallace740
wallace740

Hi,

Considering it that this belongs to a 3-rd party control tool of Telerik, I'm afraid Microsoft cannot do much comments on that.

http://www.telerik.com/community/forums/aspnet/grid.aspx

If you'd like to use GridView instead (because that's Microsoft control). I'd like to recommand you this:

http://geekswithblogs.net/AzamSharp/archive/2005/12/21/63843.aspx

wallace740

Member

33 Points

135 Posts

Re: Exporting from RadGrid to Excel - multiple cell problem

Dec 28, 2012 03:24 AM|wallace740|LINK

I use standart GridView to export to excel but the same thing happens.

HTML code is separated into multiple cells :(

protected void ExceleAktarLinkButton_Click(object sender, EventArgs e)
   {
       Response.Clear();
       Response.AddHeader("content-disposition", "attachment;filename=testExport.xls");
       Response.Charset = "";
       Response.Cache.SetCacheability(HttpCacheability.NoCache);
       Response.ContentType = "application/vnd.xls";
 
       System.IO.StringWriter stringWrite = new System.IO.StringWriter();
       HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
 
       form1.Controls.Clear();
       form1.Controls.Add(GridView1);
       form1.RenderControl(htmlWrite);
       Response.Write(stringWrite.ToString());
       Response.End();
   }
 
   //HTML Codes into Visual HTML
   protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
   {
       if (e.Row.RowType == DataControlRowType.DataRow)
       {
           for (int j = 0; j < e.Row.Cells.Count; j++)
           {
               string encoded = e.Row.Cells[j].Text;
               e.Row.Cells[j].Text = Context.Server.HtmlDecode(encoded);
           }
 
       }
   }

Screenshot(below) when exported from standart GridView.

1 cell in my GridView is separated into multiple rows :(

- Reply
Decker Dong...
All-Star

94130 Points

18109 Posts

Re: Exporting from RadGrid to Excel - multiple cell problem

Dec 28, 2012 03:41 AM|Decker Dong - MSFT|LINK

wallace740
wallace740

Hi,

To be very honest, it's not an easy task to export a GridView with Html formation.

Maybe you can try to use this tool:

http://highoncoding.com/Articles/202_GridView_Export_to_Excel_Button_Control.aspx

‹ Previous Thread|Next Thread ›