Export Multiple Grid into single excel

[Nithya Rani]

I have 3 radgrids. while i click the export button, All the 2 grids should be exported into the single excel file.
first grid should be sheet1, 2nd grid should be in sheet2 accordingly.
Whether this is possible. If this is possible how can we do this.
this is my grid code
<table runat="server" id="GridTable" visible="false" width="100%">
            <tr>
                <td>
                    <div class="pageheadertext">
                        On-Hand
                    </div>
                </td>
            </tr>
            <tr>
                <td align="center">
                    <telerik:RadGrid ID="RadGrid_LotDetailsonHand" runat="server" AllowPaging="True"
                        AllowSorting="True" EnableLinqExpressions="false" Width="90%" AutoGenerateEditColumn="false"
                        AutoGenerateColumns="False" OnPageIndexChanged="RadGrid_LotDetailsonHand_PageIndexChanged"
                        Visible="false" ShowFooter="True">
                        <PagerStyle Mode="NextPrevAndNumeric" />
                        <HeaderStyle BorderStyle="Solid" Font-Bold="true" HorizontalAlign="Center" />
                        <ItemStyle HorizontalAlign="Left" Font-Underline="false" />
                        <AlternatingItemStyle HorizontalAlign="Left" Font-Underline="false" />
                        <ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true">
                            <Excel Format="ExcelML" />
                        </ExportSettings>
                        <MasterTableView AllowPaging="true" CommandItemDisplay="Top" AllowMultiColumnSorting="false"
                            ShowGroupFooter="true">
                            <CommandItemSettings ShowExportToExcelButton="true" ShowRefreshButton="false" ShowAddNewRecordButton="false"
                                ShowExportToCsvButton="false" ShowExportToPdfButton="true" ShowExportToWordButton="true" />
                            <PagerStyle Mode="NextPrevAndNumeric" />
                            <Columns>
                                <telerik:GridBoundColumn HeaderText="Warehouse" UniqueName="Warehouse_code" DataField="WAREHOUSE_CODE"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Location" UniqueName="Locetion_code" DataField="LOCATION_CODE"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                                <telerik:GridCalculatedColumn HeaderText="Qty" UniqueName="qty" ItemStyle-HorizontalAlign="Right"
                                    DataFields="QTTY, PACKSHORT_DESC" Expression='{0}+ " " +{1}' />
                                <%--  <telerik:GridBoundColumn Aggregate="Sum" HeaderText="Qty" UniqueName="qty" ItemStyle-HorizontalAlign="Right"
                                    DataField="QTTY">
                                    
                                </telerik:GridBoundColumn>--%>
                                <telerik:GridBoundColumn HeaderText="Owner" UniqueName="Owner_Code." DataField="OWNER_CODE"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Status" UniqueName="Status" DataField="STATUS"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </MasterTableView>
                    </telerik:RadGrid>
                </td>
            </tr>
            <tr>
                <td>
                    <div class="pageheadertext">
                        Received
                    </div>
                </td>
            </tr>
            <tr>
                <td align="center">
                    <telerik:RadGrid ID="RadGrid_LotDetailsOnRecev" runat="server" AllowPaging="True"
                        AllowSorting="True" EnableLinqExpressions="false" Width="90%" AutoGenerateEditColumn="false"
                        AutoGenerateColumns="False" OnPageIndexChanged="RadGrid_LotDetailsOnRecev_PageIndexChanged"
                        Visible="false">
                        <PagerStyle Mode="NextPrevAndNumeric" />
                        <ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true">
                            <Excel Format="ExcelML" />
                        </ExportSettings>
                        <MasterTableView AllowPaging="true" CommandItemDisplay="Top">
                            <CommandItemSettings ShowExportToExcelButton="true" ShowRefreshButton="false" ShowAddNewRecordButton="false"
                                ShowExportToCsvButton="true" ShowExportToPdfButton="true" ShowExportToWordButton="true" />
                            <PagerStyle Mode="NextPrevAndNumeric" />
                            <Columns>
                                <telerik:GridDateTimeColumn DataType="System.DateTime" HeaderText="Date" UniqueName="Date"
                                    ItemStyle-HorizontalAlign="Left" DataField="DATETIME" DataFormatString="<%$Appsettings:dateformat%>">
                                </telerik:GridDateTimeColumn>
                                <telerik:GridTemplateColumn ItemStyle-HorizontalAlign="Left" SortExpression="PO_ORDER_NO"
                                    HeaderText="Order" UniqueName="Order">
                                    <ItemTemplate>
                                        <asp:LinkButton ID="lnkOrdNum" runat="server" OnClick="lnkrefNum_Click" ForeColor="DarkBlue"
                                            CommandArgument='<%# DataBinder.Eval (Container.DataItem, "ORDER_NO2") %>' Text='<%# DataBinder.Eval (Container.DataItem, "PO_ORDER_NO") %>'
                                            ValidationGroup='<%# DataBinder.Eval (Container.DataItem, "SRORDER_ID") %>'>
                                        </asp:LinkButton>
                                    </ItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridBoundColumn HeaderText="(Alt Order)" UniqueName="Alt_Order" DataField="ORDER_NO2"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                                <telerik:GridCalculatedColumn HeaderText="Qty" UniqueName="qty" ItemStyle-HorizontalAlign="Right"
                                    DataFields="QTTY, PACKSHORT_DESC" Expression='{0}+ " " +{1}' />
                                <telerik:GridBoundColumn HeaderText="Owner" UniqueName="Owner_Code." DataField="OWNER_CODE"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Status" UniqueName="Status" DataField="STATUS"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Warehouse" UniqueName="Warehouse_code" DataField="WAREHOUSE_CODE"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Source" UniqueName="source" ItemStyle-HorizontalAlign="Left"
                                    DataField="SOURCE">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </MasterTableView>
                    </telerik:RadGrid>
                </td>
            </tr>
            <tr>
                <td>
                    <div class="pageheadertext">
                        Shipped
                    </div>
                </td>
            </tr>
            <tr>
                <td align="center">
                    <telerik:RadGrid ID="RadGrid_LotDetailsShipper" runat="server" AllowPaging="True"
                        AllowSorting="True" EnableLinqExpressions="false" Width="90%" AutoGenerateEditColumn="false"
                        AutoGenerateColumns="False" OnPageIndexChanged="RadGrid_LotDetailsShipper_PageIndexChanged"
                        Visible="false">
                        <PagerStyle Mode="NextPrevAndNumeric" />
                        <ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true">
                            <Excel Format="ExcelML" />
                        </ExportSettings>
                        <MasterTableView AllowPaging="true" CommandItemDisplay="Top">
                            <CommandItemSettings ShowExportToExcelButton="true" ShowRefreshButton="false" ShowAddNewRecordButton="false"
                                ShowExportToCsvButton="true" ShowExportToPdfButton="true" ShowExportToWordButton="true" />
                            <PagerStyle Mode="NextPrevAndNumeric" />
                            <Columns>
                                <telerik:GridDateTimeColumn DataType="System.DateTime" HeaderText="Date" UniqueName="Date"
                                    ItemStyle-HorizontalAlign="Left" DataField="DATETIME" DataFormatString="<%$Appsettings:dateformat%>">
                                </telerik:GridDateTimeColumn>
                                <telerik:GridTemplateColumn ItemStyle-HorizontalAlign="Left" SortExpression="CO_ORDER_NO"
                                    HeaderText="Order" UniqueName="Order">
                                    <ItemTemplate>
                                        <asp:LinkButton ID="lnkOrdNum" runat="server" OnClick="lnkrefNum_Click" ForeColor="DarkBlue"
                                            CommandArgument='<%# DataBinder.Eval (Container.DataItem, "ORDER_NO2") %>' Text='<%# DataBinder.Eval (Container.DataItem, "CO_ORDER_NO") %>'
                                            ValidationGroup='<%# DataBinder.Eval (Container.DataItem, "SRORDER_ID") %>'>
                                        </asp:LinkButton>
                                    </ItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridBoundColumn HeaderText="(Alt Order)" UniqueName="Alt_Order" DataField="ORDER_NO2"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                                <telerik:GridCalculatedColumn HeaderText="Qty" UniqueName="qty" ItemStyle-HorizontalAlign="Right"
                                    DataFields="QTTY, PACKSHORT_DESC" Expression='{0}+ " " +{1}' />
                                <telerik:GridBoundColumn HeaderText="Owner" UniqueName="Owner_Code." DataField="OWNER_CODE"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Status" UniqueName="Status" DataField="STATUS"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Warehouse" UniqueName="Warehouse_code" DataField="WAREHOUSE_CODE"
                                    ItemStyle-HorizontalAlign="Left">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn HeaderText="Designation" UniqueName="Designation" ItemStyle-HorizontalAlign="Left"
                                    DataField="DEST">
                                </telerik:GridBoundColumn>
                            </Columns>
                        </MasterTableView>
                    </telerik:RadGrid>
                </td>
            </tr>
        </table>

[Princy]

Hello,

Take a look into the following code library.
Export multiple RadGrids in single PDF/Excel file

Thanks,
Princy.

[Margret]

Hi,
Can we do the export multiple grid into single excel in separate sheets without having the wrapper grid concept as you told in the last example link?

[Kostadin]

Hello Margret,

Please review the following example from our SDK. As you could see we are using an ExportInfrastructure and manually generated the exported excel file. This way you could export multiple RadGrids in a single or multiple spreadsheets.

Regards,
Kostadin
Telerik

[Margret]

Hi,
 I have used the following namespace in my project.
using Telerik.Web.UI.GridExcelBuilder;
using xls = Telerik.Web.UI.ExportInfrastructure;
But it shows type are namespce ExportInfrastructure doesnt exist in the Telerik.Web.UI namespace.I have to add any reference in bin folder?

Regards,
Margret

[Margret]

Hi ,
any update on this?
Regards,
Margret.

[Maria Ilieva]

Hello Margret,

Note that the Telerik Export Infrastructure is released in Q2 2012 which means that in case you are using earlier version of the controls the presented behavior is expected. Upgrade your application at least to the mentioned version and verify if this helps.

Regards,
Maria Ilieva
Telerik

[Margret]

Hi,Maria.
Thanks for your clarification.I have used the earlier version telerik v2011.1.519.35.
Regards,
Margret.