Advertisement
Guest User

RadGrid Export To Excel Layout Issue

a guest
Apr 5th, 2012
590
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.19 KB | None | 0 0
  1. <telerik:RadGrid ID="RadGrid1" runat="server" ShowFooter="false" AutoGenerateColumns="false"
  2. AllowPaging="true" AllowSorting="false" CellSpacing="5" AllowFilteringByColumn="false">
  3. <ExportSettings HideStructureColumns="true" ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true">
  4. <Pdf AllowAdd="false" AllowCopy="true" AllowModify="false" AllowPrinting="true" PageTitle="ESign Sent vs Sold"
  5. Title="ESign Sent vs Sold" PaperSize="A4" PageWidth="260mm" />
  6. <Excel Format="Html" />
  7. </ExportSettings>
  8.  
  9. <ClientSettings AllowExpandCollapse="true">
  10. <Selecting AllowRowSelect="true" />
  11. </ClientSettings>
  12.  
  13. <MasterTableView DataKeyNames="ParentID, ID" Name="DivisionTable" HierarchyLoadMode="Client" HierarchyDefaultExpanded="false" ClientDataKeyNames="ParentID, ID">
  14. <HeaderStyle Font-Bold="true" HorizontalAlign="Left" Wrap="false" />
  15. <ItemStyle Wrap="false" VerticalAlign="Middle" HorizontalAlign="Left" />
  16. <AlternatingItemStyle Wrap="false" VerticalAlign="Middle" HorizontalAlign="Left" />
  17. <FooterStyle Wrap="false" />
  18.  
  19. <DetailTables>
  20. <telerik:GridTableView Name="RegionTable" DataKeyNames="ParentID, ID" ClientDataKeyNames="ParentID, ID" HierarchyLoadMode="Client" Width="100%" HierarchyDefaultExpanded="false" >
  21. <DetailTables>
  22. <telerik:GridTableView Name="BranchTable" DataKeyNames="ParentID, ID" ClientDataKeyNames="ParentID, ID" HierarchyLoadMode="Client" Width="100%" HierarchyDefaultExpanded="false" >
  23. <Columns>
  24. <telerik:GridTemplateColumn UniqueName="Filler" ItemStyle-Width="25px" HeaderStyle-Width="25px">
  25. <ItemTemplate>
  26. <span>&nbsp;</span>
  27. </ItemTemplate>
  28. </telerik:GridTemplateColumn>
  29. <telerik:GridBoundColumn UniqueName="Text" DataField="Text" SortExpression="Text" HeaderText="Branch" ItemStyle-Width="300px" HeaderStyle-Width="300px" />
  30. <telerik:GridBoundColumn UniqueName="SentCount" DataField="SentCount" SortExpression="SentCount" HeaderText="ESign Sent" ItemStyle-Width="150px" HeaderStyle-Width="150px" />
  31. <telerik:GridBoundColumn UniqueName="SoldCount" DataField="SoldCount" SortExpression="SoldCount" HeaderText="Sold w/ ESign" />
  32. </Columns>
  33. </telerik:GridTableView>
  34. </DetailTables>
  35.  
  36. <Columns>
  37. <telerik:GridBoundColumn UniqueName="Text" DataField="Text" SortExpression="Text" HeaderText="Region" ItemStyle-Width="300px" HeaderStyle-Width="300px" />
  38. <telerik:GridBoundColumn UniqueName="SentCount" DataField="SentCount" SortExpression="SentCount" HeaderText="ESign Sent" ItemStyle-Width="150px" HeaderStyle-Width="150px" />
  39. <telerik:GridBoundColumn UniqueName="SoldCount" DataField="SoldCount" SortExpression="SoldCount" HeaderText="Sold w/ ESign" />
  40. </Columns>
  41. </telerik:GridTableView>
  42. </DetailTables>
  43.  
  44. <Columns>
  45. <telerik:GridBoundColumn UniqueName="Text" DataField="Text" SortExpression="Text" HeaderText="Division" ItemStyle-Width="300px" HeaderStyle-Width="300px" />
  46. <telerik:GridBoundColumn UniqueName="SentCount" DataField="SentCount" SortExpression="SentCount" HeaderText="ESign Sent" ItemStyle-Width="150px" HeaderStyle-Width="150px" />
  47. <telerik:GridBoundColumn UniqueName="SoldCount" DataField="SoldCount" SortExpression="SoldCount" HeaderText="Sold w/ ESign" />
  48. </Columns>
  49.  
  50. </MasterTableView>
  51. </telerik:RadGrid>
  52.  
  53. protected void btnExport_Click(object sender, EventArgs e)
  54. {
  55. Response.Clear();
  56. Response.Buffer = true;
  57. Response.ContentType = "application/vnd.ms-excel";
  58. Response.Charset = "";
  59.  
  60. this.EnableViewState = false;
  61. System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
  62. System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
  63. RadGrid1.RenderControl(oHtmlTextWriter);
  64. Response.Write(oStringWriter.ToString());
  65. Response.End();
  66. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement