SummaryLevel プロパティ (SummaryRowExportingEventArgs)

集計レベル

シンタックス

Visual Basic

'宣言
 
Public ReadOnly Property SummaryLevel As Integer

C#

public int SummaryLevel {get;}

使用例

Visual Basic

Private Sub MyGridExporter_SummaryRowExporting(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.ExcelExport.SummaryRowExportingEventArgs) Handles MyGridExporter.SummaryRowExporting
    If e.SummaryLevel Mod 2 = 0 Then
        e.Summaries(0).Appearance.BackColor = Color.LightCoral
    End If
End Sub

Private Sub MyGridExporter_SummaryRowExported(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.ExcelExport.SummaryRowExportedEventArgs) Handles MyGridExporter.SummaryRowExported
    If e.SummaryLevel Mod 2 = 0 Then
        e.CurrentWorksheet.Rows(e.CurrentRowIndex - 1).CellFormat.Font.Bold = ExcelDefaultableBoolean.True
    End If
End Sub

C#

private void SummaryRowExportingEH(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.SummaryRowExportingEventArgs e)
{
	if(e.SummaryLevel%2==0)
		e.Summaries[0].Appearance.BackColor = Color.LightCoral;		
}

private void SummaryRowExportedEH(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.SummaryRowExportedEventArgs e)
{
	if(e.SummaryLevel%2==0)
		e.CurrentWorksheet.Rows[e.CurrentRowIndex-1].CellFormat.Font.Bold = ExcelDefaultableBoolean.True;		
}