Export to excell selected row from hierarchical grid

[Atul]

we are using radGrid and having details table inside master table view  and an event onneeddatasource and checkbox column onside of radgrid and i want to export only selected row to excel..but the problem is that it is exporting all record to excell sheet beside selection of rows please help me ????????????????????????????

[Shinu]

Hello,

Try the following code.
C#:

protected void Button2_Click(object sender, EventArgs e)
{
 foreach (GridDataItem item in RadGrid1.Items)
 {
  if (item.Selected == false)
  {
   item.Visible = false;
  }
 }
   RadGrid1.ExportSettings.ExportOnlyData = true;
   RadGrid1.ExportSettings.OpenInNewWindow = true;
   RadGrid1.MasterTableView.ExportToExcel();
}

-Shinu.

[Atul]

hi shinu

please  give me another solution...because previous solution are not work .
???????????????????

[Shinu]

Hi Atul,

The above code is working fine at my end with Excel-Format="Html".Please specify which Excel-Format you are using or can you paste your complete code?My suggestion is valid for the HTML Excel type only. If the Excel-Format is "ExcelML" it gets the data straight from the datasource and it doesn't care if the rows are hidden or not .

Thanks,
-Shinu.