Export to excel

[Krunal Doshi]

Hi,

I have enabled option to export my RADGrid data to PDF, EXCEL, CSV and Word. While exporting to Excel, it also exports few buttons and Refresh link at the top row in excel sheet.

How can I avoid this?

Regards,
Krunal

[Cori]

Hello Krunal,

In your ExportSettings, you should set ExportOnlyData="true".

[Krunal Doshi]

Hi,

Even after that I am still getting those buttons. I have attached the screen shot for your reference.
Please let me know the possible solutions.

Regards,
Krunal

[Daniel]

Hello Krunal,

Please post your code in this thread so that we can examine your approach. I recommend that you use the "Code snippet" button in the toobar above.

Regards,
Daniel
the Telerik team

[Krunal Doshi]

Hi,

Please find the code for your reference.

<telerik:RadGrid ID="grdReport" runat="server" AllowSorting="True" GridLines="None"
                            AllowPaging="True" Font-Names="Arial" Font-Size="10pt" PageSize="25" Skin="Outlook"
                            OnNeedDataSource="grdReport_NeedDataSource" OnPreRender="grdReport_PreRender"
                            OnColumnCreated="grdReport_ColumnCreated"
                            OnDataBound="grdReport_DataBound" OnItemCommand="grdReport_ItemCommand"
                            EnableViewState="true" OnItemCreated="grdReport_ItemCreated"
                            onpdfexporting="grdReport_PdfExporting"
                            onitemdatabound="grdReport_ItemDataBound">
                            <ExportSettings IgnorePaging="True" OpenInNewWindow="True" ExportOnlyData="true">
                                <Pdf PageWidth="297mm" PageHeight="210mm" Author="VoltTrack" Creator="VoltTrack"
                                    Producer="VoltTrack" PageLeftMargin="0.5in" PageRightMargin="0.5in" />
                            </ExportSettings>
                            <PagerStyle Position="Top" />
                            <MasterTableView Width="100%" CommandItemDisplay="Top" EnableViewState="true">
                                <PagerStyle Mode="NextPrevNumericAndAdvanced" AlwaysVisible="true" />
                                <CommandItemSettings ShowExportToCsvButton="false" ShowExportToExcelButton="True"
                                    ShowExportToPdfButton="True" ShowExportToWordButton="false" />
                            </MasterTableView>
                            <HeaderStyle HorizontalAlign="Center" />
                            <ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True">
                                <Scrolling EnableVirtualScrollPaging="True" />
                            </ClientSettings>
                        </telerik:RadGrid>

Regards,
Krunal

[Daniel]

Hello Krunal,

I created a runnable demo (attached to this ticket) in order to recreate your scenario. Unfortunately I'm unable to reproduce the problem. Please test the aforementioned project and let me know if I'm missing something.

Regards,
Daniel
the Telerik team