2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
Excel exportThe 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: https://help.syncfusion.com/windowsforms/classic/gridgroupingcontrol/exporting |
2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.