Export to CSV not working

[hitonline]

I have been trying to export my radgrid into CSV format, but somehow it'snot working even after following settings.
 <CommandItemSettings ShowExportToExcelButton="true" ShowExportToCsvButton="true"
            ShowAddNewRecordButton="false" ShowRefreshButton="false" />

It does not even hit  OnGridExporting="radInvoiceDetails_GridExporting" method.

[Shinu]

Hi,

I tried with the scenario and it is working fine at my end.If you are Ajaxifying the RadGrid ,the exporting feature of the control work with regular postbacks only. To bypass the limitation you can wire the OnRequestStart event of the ajax panel or ajax manager, determine whether the target control is ajaxified and explicitly disable its ajax mode to export with regular postback.

ASPX:

<telerik:RadAjaxManager ClientEvents-OnRequestStart="onRequestStart" ID="ajax" runat="server">
 <AjaxSettings>
    <telerik:AjaxSetting AjaxControlID="RadGrid1">
        <UpdatedControls>
            <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
        </UpdatedControls>
    </telerik:AjaxSetting>
 </AjaxSettings>
</telerik:RadAjaxManager>

Javascript:

<script type="text/javascript">
    function onRequestStart(sender, args)
    {
        if (args.get_eventTarget().indexOf("ExportToCsvButton") >= 0) {
            args.set_enableAjax(false);
        }
    }
</script>

Please take a look into this help documentation.Provide the code if it doesn't help.

Thanks,
Shinu.

[hitonline]

I am getting this extra button and image in exported report. (See the attachment)  looks like a command item which has been disabled in code

telerik:RadGrid ID="radInvoiceDetails" runat="server" Skin="WebBlue" AllowSorting="true"

    OnGridExporting="radInvoiceDetails_GridExporting" OnPreRender="radInvoiceDetails_PreRender"

    ExportSettings-HideStructureColumns="true" ExportSettings-ExportOnlyData="true"

    EnableLinqExpressions="false" Width="100%" AutoGenerateColumns="False" Height="100%"

    OnItemDataBound="radInvoiceDetails_ItemDataBound" PageSize="10" AllowPaging="True"

    EnableAJAX="True

protected void radInvoiceDetails_GridExporting(object sender, GridExportingArgs e)
        {
            if (e.ExportType == ExportType.Excel)
            {
                string fileName = radInvoiceDetails.ExportSettings.FileName + "." + radInvoiceDetails.ExportSettings.Excel.FileExtension;
                Response.ClearHeaders();
                Response.ContentType = "application/vnd.ms-excel";

                Response.AddHeader("Content-Disposition", "attachment;filename=\"" + fileName + "\"");

                Response.Write(e.ExportOutput);
            }
        }

" RetrieveAllDataFields="true" OnNeedDataSource="radInvoiceDetails_NeedDataSource">

[Shinu]

HI,

Try setting ExportOnlyData as true.
C#:

RadGrid1.ExportSettings.ExportOnlyData = true;
RadGrid1.MasterTableView.ExportToExcel();

Thanks,
Shinu.