export to csv

[lm]

I have a radgrid with mostly template columns...I have added export feature to the grid, export to pdf works fine with the footer details but with csv export footer is missing I am looking for group footer and grid footer data. Is it possible if so please guide me. thank you

[Shinu]

Hi Im,

Please try the following example code snippet to export footer data.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server"  ShowFooter="True" ShowGroupFooter="true" OnGridExporting="RadGrid1_GridExporting">
    <ExportSettings ExportOnlyData="false" IgnorePaging="true" OpenInNewWindow="true">
    </ExportSettings>
    <MasterTableView CommandItemDisplay="Top">
        <CommandItemSettings ShowExportToCsvButton="true" />
        <Columns>
            <telerik:GridBoundColumn HeaderText="Unit Price" DataField="UnitPrice" UniqueName="UnitPrice"
                Aggregate="Sum">
            </telerik:GridBoundColumn>
            <telerik:GridTemplateColumn UniqueName="TemplateColumn">
                <HeaderTemplate>
                    Quantity
                </HeaderTemplate>
                <ItemTemplate>
                    <%# Eval("Quantity")%>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

C#:

protected void RadGrid1_GridExporting(object sender, GridExportingArgs e)
   {
     if (e.ExportType == ExportType.Csv)
     {
       string footer = "";
       GridFooterItem footerItem = RadGrid1.MasterTableView.GetItems(GridItemType.Footer)[0] as GridFooterItem;
       foreach (GridColumn column in RadGrid1.MasterTableView.RenderColumns)
       if (column.Visible)
       footer += String.Format("\"{0}\",", footerItem[column.UniqueName].Text.Replace(" ", ""));
       e.ExportOutput += footer;
       }
   }

Hope this helps.

Thanks,
Shinu

[lm]

I believe the code provided by you would help me to get the gridfooter but I need to export the group footer as well in to csv file.

Also I get file error when I export to Excel I researching I understood that xslx is not supported by radgrid, even saving the file as xls and opening it later did not help me. any options please let me know. thank you

[lm]

I managed to export to excel using excel format excelml, similar to csv the group footers are not exported, could you please help me to find a solution.

[Kostadin]

Hello Lavanua,

Would recommend you to check out the following forum post.
Radgrid doesnt export Grid-Footer to Excel (ExcelML)
ExcelML Export with aggregates in groupfooter

Since CSV file is a plain text, it does not support footer as well, so you have to add the footer manually. Shinu's suggestion demonstrates a possible solution how this could be achieved.

Regards,
Kostadin
Telerik