This is a migrated thread and some comments may be shown as answers.

Export to Excel missing GridTemplateColumn column

1 Answer 236 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Kurt Kluth
Top achievements
Rank 1
Kurt Kluth asked on 09 Sep 2014, 09:02 PM
My export to Excel works fine with normal GridBoundColumn columns however will not work with GridTemplateColumn.  How might I facilitate a download of the grid?  When downloading it only includes Member Type, Phone, Approx Miles.  Need it to include CUName, Address, etc.

Thank you for your help
<telerik:RadGrid ID="grdResults" runat="server" AllowPaging="true" AllowSorting="true"
    AutoGenerateColumns="False" CellSpacing="-1" GridLines="Both" PageSize="100">
    <ExportSettings IgnorePaging="True" OpenInNewWindow="True"
        ExportOnlyData="True" FileName="CUMapListings">
        <Excel AutoFitImages="True" Format="ExcelML" />
        <Csv ColumnDelimiter="VerticalBar" EncloseDataWithQuotes="False" />
    </ExportSettings>
    <MasterTableView CommandItemDisplay="Top" UseAllDataFields="true" TableLayout="Fixed">
        <HeaderStyle Font-Bold="true" />
        <CommandItemTemplate>
            <asp:LinkButton ID="btnPrint" runat="server" CommandName="PrintResults" Visible="true" OnClientClick="PrintRadGrid(); return false;"><img style="border:0px;vertical-align:middle;" alt="" src="/Images/DownloadPrinter.png"/>Print</asp:LinkButton>  
            <asp:LinkButton ID="btnExportMap" runat="server" CommandName="ExportMapListing" Visible="true"><img style="border:0px;vertical-align:middle;" alt="" src="/Images/Help/CSV_Export.jpg"/>Excel Download</asp:LinkButton>  
        </CommandItemTemplate>
        <AlternatingItemStyle BackColor="LightGray" />
        <Columns>
            <telerik:GridTemplateColumn UniqueName="RowNumber">
                <ItemTemplate>
                    <asp:Label ID="lblRowNumber" runat="server" />
                </ItemTemplate>
                <ItemStyle Font-Bold="true" />
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn UniqueName="_search_asiNum" Visible="false" DataField="asi_num">
                <ItemTemplate>
                    <asp:Label ID="_search_asiNum" runat="server" />
                </ItemTemplate>
                <ItemStyle Font-Bold="true" />
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn UniqueName="CUInfo" HeaderText="ADDRESS">
                <ItemTemplate>
                    <asp:Label ID="lblCULink" runat="server" Visible="false" />
                    <asp:LinkButton runat="server" ID="CU_LinkButton" Visible="false"></asp:LinkButton>
                    <br />
                    <asp:Label ID="lblAddressInfo" runat="server" Visible="True" />
                </ItemTemplate>
                <HeaderStyle HorizontalAlign="Center" />
            </telerik:GridTemplateColumn>
            <telerik:GridBoundColumn HeaderText="MEMBER" UniqueName="MemberType" FilterControlAltText="Filter column column" DataField="MemberType">
                <ColumnValidationSettings>
                    <ModelErrorMessage Text=""></ModelErrorMessage>
                </ColumnValidationSettings>
                <ItemStyle HorizontalAlign="Center" />
                <HeaderStyle HorizontalAlign="Center" />
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn HeaderText="PHONE" UniqueName="Phone" FilterControlAltText="Filter column column" DataField="cuPhone">
                <ColumnValidationSettings>
                    <ModelErrorMessage Text=""></ModelErrorMessage>
                </ColumnValidationSettings>
                <ItemStyle HorizontalAlign="Center" />
                <HeaderStyle HorizontalAlign="Center" />
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn HeaderText="APPROX. MILES" UniqueName="Miles" FilterControlAltText="Filter column column" DataField="Distance" DataFormatString="{0:####.#0}">
                <ColumnValidationSettings>
                    <ModelErrorMessage Text=""></ModelErrorMessage>
                </ColumnValidationSettings>
                <ItemStyle HorizontalAlign="Center" />
                <HeaderStyle HorizontalAlign="Center" />
            </telerik:GridBoundColumn>
 
                                 
            <telerik:GridTemplateColumn UniqueName="Directions" HeaderText="DRIVING DIRECTION">
                <ItemTemplate>
                    <asp:PlaceHolder runat="server">
 
                    <a href="http://google.com/maps/dir/<;%# DataBinder.Eval(Container.DataItem, "Address1")%>%2C+<%# DataBinder.Eval(Container.DataItem, "City")%>+<%# DataBinder.Eval(Container.DataItem, "state_id")%>+<%# DataBinder.Eval(Container.DataItem, "zip_code")%>/<%# Request.QueryString("A")%>%2C+<%# Request.QueryString("C")%>+<%# Request.QueryString("S")%>+<%# Request.QueryString("Z")%>" target="_blank">To <%# Request.QueryString("N")%></a>
                    <br />
                    <a href="http://google.com/maps/dir/<;%# Request.QueryString("A")%>%2C+<%# Request.QueryString("C")%>+<%# Request.QueryString("S")%>+<%# Request.QueryString("Z")%>/<%# DataBinder.Eval(Container.DataItem, "Address1")%>%2C+<%# DataBinder.Eval(Container.DataItem, "City")%>+<%# DataBinder.Eval(Container.DataItem, "state_id")%>+<%# DataBinder.Eval(Container.DataItem, "zip_code")%>" target="_blank">From <%# Request.QueryString("N")%></a>
                </asp:PlaceHolder>
                </ItemTemplate>
                <HeaderStyle HorizontalAlign="Center" />
            </telerik:GridTemplateColumn>
        </Columns>
    </MasterTableView>
    <PagerStyle PageSizeControlType="RadComboBox" />
</telerik:RadGrid>

Here is how I populate the fields that are not showing.
Private Sub grdResults_ItemCommand(sender As Object, e As GridCommandEventArgs) Handles grdResults.ItemCommand
    If e.CommandName = "ExportMapListing" Then
        grdResults.ExportSettings.ExportOnlyData = True
        grdResults.ExportSettings.FileName = "ExportMapListing"
        grdResults.MasterTableView.ExportToExcel()
    End If
End Sub
 
Private Sub grdResults_ItemDataBound(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles grdResults.ItemDataBound
    'Set Row Count
    If TypeOf e.Item Is Telerik.Web.UI.GridDataItem Then
        Dim rowCounter As Integer = 0
        Dim lblRowNumber As Label = TryCast(e.Item.FindControl("lblRowNumber"), Label)
 
        rowCounter = grdResults.MasterTableView.PageSize * grdResults.MasterTableView.CurrentPageIndex
        lblRowNumber.Text = (e.Item.ItemIndex + 1 + rowCounter).ToString()
 
        Dim lblCULink As Label = TryCast(e.Item.FindControl("lblCULink"), Label)
        Dim CU_LinkButton As LinkButton = TryCast(e.Item.FindControl("CU_LinkButton"), LinkButton)
 
        Dim lblAddressInfo As Label = TryCast(e.Item.FindControl("lblAddressInfo"), Label)
        lblAddressInfo.Text = DataBinder.Eval(e.Item.DataItem, "Address1") & "<br />" & _
                                DataBinder.Eval(e.Item.DataItem, "City") & " " & _
                                DataBinder.Eval(e.Item.DataItem, "state_id") & " " & _
                                DataBinder.Eval(e.Item.DataItem, "zip_code")
 
        If DataBinder.Eval(e.Item.DataItem, "MemberType") = "Non-member" Then
            e.Item.ForeColor = Drawing.Color.Black
 
            lblCULink.Visible = True
            lblCULink.Text = "<a href=""/cuDataAnalysis/cuSummary.aspx?Charter_num=" & DataBinder.Eval(e.Item.DataItem, "charter_num") & """>" & DataBinder.Eval(e.Item.DataItem, "CUName") & " (" & DataBinder.Eval(e.Item.DataItem, "charter_num") & ")</a>"
 
            CU_LinkButton.Visible = False
        Else
            e.Item.ForeColor = Drawing.Color.Green
            'lblCULink.Text = "<a href=""/CUTracking/ContactManager/default.aspx?_search_asiNum=" & DataBinder.Eval(e.Item.DataItem, "asi_num") & """>" & DataBinder.Eval(e.Item.DataItem, "CUName") & " (" & DataBinder.Eval(e.Item.DataItem, "charter_num") & ")</a>"
            lblCULink.Visible = False
 
            CU_LinkButton.Visible = True
            CU_LinkButton.PostBackUrl = "/CUTracking/ContactManager/default.aspx" '?_search_asiNum=" & DataBinder.Eval(e.Item.DataItem, "asi_num")
            CU_LinkButton.Text = DataBinder.Eval(e.Item.DataItem, "CUName") & " (" & DataBinder.Eval(e.Item.DataItem, "charter_num") & ")"
        End If
    End If
 
End Sub







1 Answer, 1 is accepted

Sort by
0
Kostadin
Telerik team
answered on 12 Sep 2014, 11:04 AM
Hello Kurt,

Note that ExcelML format renders the Excel document directly from the datasource. In case you want to export the TemplateColumn text you need to set DataField property of the column. Otherwise you need to use HTML based export format.

Regards,
Kostadin
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
Grid
Asked by
Kurt Kluth
Top achievements
Rank 1
Answers by
Kostadin
Telerik team
Share this question
or