Grid with Export

[Avinash]

Hi,

I have a requirement like:

I have a datatable with 10 columns, out of which I am showing only 5 columns on page. Page also have export button, which is working fine and exporting only five columns with sorting & filtering.

Now due to some requirement , client is expecting to show 5 columns as is on page but while exporting, excel should contain all 10 columns.

Is it possible to full fill this requirement?

[Jayesh Goyani]

Hi Avinash,

add colunm in your code and set visible to false.

<telerik:GridBoundColumn UniqueName="Column6" DataField="YourDataField"  Visible="false">

and when you export command fire at that time you set visible=true of that extra columns.

protected void Radgrid1_ItemCommand(object source, GridCommandEventArgs e)
{
     if(e.CommandName == "ExportToExcel")
     {
             Radgrid1.MasterTableView.Columns.FindByUniqueName("Column6").Visible = true;
     }
}

let me know if any concern

Thanks,
Jayesh Goyani

[Avinash]

Hi Jayesh,

This is not working as ItemCommand is not getting fired when I click on export button.

I think I have to check in exporting event itself.

Thank you for giving me an idea.

[Jayesh Goyani]

hi Avinash,

Radgrid1.MasterTableView.Columns.FindByUniqueName("Column6").Visible = true;
Radgrid1.MasterTableView.ExportToExcel();

sorry for that i think that u want to export from inbuilt export command's button.
above code is help full to you.

Thanks,
Jayesh Goyani

[Avinash]

Cool.

It is working. Thank you.