Disabling rows to be exported according to a condition

[Ueli]

Hi,

I just wonder whether it would be directly possible to have certains rows not exported based on a condition I set or whether I need to exclude them manually.

Ueli

[Stefan]

Hi Ueli,

Thank you for writing.

To exclude a row from being exported, you need to set its IsVisible property to false and the exporter's HiddenRowOption to DoNotExport:

private void radButton1_Click(object sender, EventArgs e)
{
    ExportToExcelML exporter = new ExportToExcelML(this.radGridView1);
    exporter.HiddenRowOption = HiddenOption.DoNotExport;

    string fileName = "C:\\ExportedData123.xls";

    foreach (var item in radGridView1.Rows)
    {
        item.IsVisible = false;
    }

    exporter.RunExport(fileName);

    foreach (var item in radGridView1.Rows)
    {
        item.IsVisible = true;
    }
}

I hope this helps.

Regards,
Stefan
Telerik