How to exclude the Hidden Columns while exporting in WinForms DataGrid?

WinForms DataGrid (SfDataGrid) does not provide the direct support to exclude the hidden columns while exporting. You can exclude the hidden columns while exporting by using ExcludeColumns field in ExcelExportingOptions.

private void BtnExportExcel_Click(object sender, EventArgs e)
{
    var file_name = "Sample.xlsx";
    var options = new ExcelExportingOptions
    {
        ExcelVersion = ExcelVersion.Excel2016,
    };

    //get the columns in SfDataGrid
    foreach (var column in sfDataGrid.Columns)
    {
        //check the columns is Visible or not
        if (!column.Visible)
            //While exporting Hidden column stop by Add the MappingName of hidden column in ExcludeColumns in ExcelExportingOptions
            options.ExcludeColumns.Add(column.MappingName);
    }

    var excelEngine = sfDataGrid.ExportToExcel(sfDataGrid.View, options);
    var workBook = excelEngine.Excel.Workbooks[0];
    workBook.SaveAs(file_name);
    _ = Process.Start(file_name);
}

Take a moment to peruse the WinForms DataGrid - Export To Excel documentation, where you can find about export to excel with code examples.

View sample in GitHub.

Conclusion

I hope you enjoyed learning about how to exclude the Hidden Columns while exporting in WinForms DataGrid (SfDataGrid).

You can refer to our WinForms DataGrid feature tour page to know about its other groundbreaking feature representations and documentation, and how to quickly get started for configuration specifications. You can also explore our WinForms DataGrid example to understand how to create and manipulate data.

For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our other controls.

If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!