Category / Section
How to export to excel without empty child groups in WinForms GridGroupingControl?
1 min read
Excel export
In WinForms
GridGroupingControl, a child without (empty) records can be
hidden/skipped while exporting by canceling the QueryExportNestedTable event
of GridGroupingExcelConverterControl.
C#
converter.QueryExportNestedTable += converter_QueryExportNestedTable;
/// <summary>
/// Hide the empty elements being exported to Excel.
/// </summary>
void converter_QueryExportNestedTable(object sender, ExportNestedTableEventArgs e)
{
if (e.NestedTable.Records.Count == 0)
e.Cancel = true;
}
VB
AddHandler converter.QueryExportNestedTable, AddressOf converter_QueryExportNestedTable
''' <summary>
''' Hide the empty elements being exported to Excel.
''' </summary>
Private Sub converter_QueryExportNestedTable(ByVal sender As Object, ByVal e As ExportNestedTableEventArgs)
If e.NestedTable.Records.Count = 0 Then
e.Cancel = True
End If
End Sub
Samples:
C#: ExportGrid
VB: ExportGrid
Reference Link: Getting Started