[Solved] Export auto generated checkbox column

[Jan]

Hello,

I want to do an Excel export of a grid with AutoGenerated columns. The problem is that for a GridCheckboxColumn in Excel the cell is empty, I want it to have true/false, 0/1, etc.

In another thread it's advised to create a hidden column and show that before export, but I am afraid i can't use that because it is impossible to add a column between two autogenerated columns? We really need the auto-generated columns...

Any help would be much appreciated.

[Princy]

Hello Jan,

The possible approach to your scenario is to replace the CheckBoxColumn with a BoundColumn and toggle the visibility while exporting. You can also swap the columns on exporting so that the  boundcolumn appears at the position of the checkboxcolumn while exporting. Check out the code below to understand better:
aspx:

 <telerik:RadGrid ID="RadGrid1" AllowPaging="true" PageSize="6"DataSourceID="SqlDataSource1" AutoGenerateColumns="true" runat="server">
       <MasterTableView>
        <Columns>
        <telerik:GridBoundColumn UniqueName="ConditionDuplicate" DataField="Condition" HeaderText="Condition" Visible="false"> </telerik:GridBoundColumn>
            .....

c#:

protected void btnExport_Click(object sender, EventArgs e)
    {
        RadGrid1.MasterTableView.SwapColumns("Condition","ConditionDuplicate");
        RadGrid1.MasterTableView.GetColumn("Condition").Visible = false;
        RadGrid1.MasterTableView.GetColumn("ConditionDuplicate").Visible = true;
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.ExportSettings.IgnorePaging = true;
        RadGrid1.MasterTableView.ExportToExcel();
    }

Thanks
Princy

[Jan]

Thanks a lot Princy, SwapColumns works wonderfully :)

Jan