'Declaration Public Event HeaderCellExporting As HeaderCellExportingEventHandler
public event HeaderCellExportingEventHandler HeaderCellExporting
The event handler receives an argument of type HeaderCellExportingEventArgs containing data related to this event. The following HeaderCellExportingEventArgs properties provide information specific to this event.
Property | Description |
---|---|
Cancel (Inherited from System.ComponentModel.CancelEventArgs) | |
CurrentColumnIndex (Inherited from Infragistics.Win.UltraWinGrid.ExcelExport.ExcelExportCancelEventArgs) | Zero-based index of current exporting column in excel worksheet.. |
CurrentOutlineLevel (Inherited from Infragistics.Win.UltraWinGrid.ExcelExport.ExcelExportCancelEventArgs) | Current outline level used for grouping. |
CurrentRowIndex (Inherited from Infragistics.Win.UltraWinGrid.ExcelExport.ExcelExportCancelEventArgs) | Zero-based index of current exporting row in excel worksheet. |
CurrentWorksheet (Inherited from Infragistics.Win.UltraWinGrid.ExcelExport.ExcelExportCancelEventArgs) | Current exporting worksheet. |
ExportText | The value which will be exported to the Excel worksheet. |
GridHeader | Grid header. |
GridRow | Associated grid row. |
HeaderType | Type of header. |
Workbook (Inherited from Infragistics.Win.UltraWinGrid.ExcelExport.ExcelExportCancelEventArgs) | Exporting workbook. |
The GridHeader argument returns a reference to grid header.
The GridRow argument returns a reference to associated grid row.
The HeaderType argument returns header type.
Additionaly this event has Cancel, Workbook, CurrentWorksheet, CurrentRowIndex, CurrentColumnIndex, CurrentOutlineLevel arguments inherited from ExcelExportCancelEventArgs.
This event is fired before excel cell with header value is processed. Use Cancel argument to cancel cell exporting.
Private Sub MyGridExporter_HeaderCellExporting(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.ExcelExport.HeaderCellExportingEventArgs) Handles MyGridExporter.HeaderCellExporting If e.CurrentColumnIndex Mod 2 = 0 Then e.GridHeader.Appearance.BackColor = Color.Yellow End If End Sub Private Sub MyGridExporter_HeaderCellExported(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.ExcelExport.HeaderCellExportedEventArgs) Handles MyGridExporter.HeaderCellExported If e.CurrentColumnIndex Mod 2 = 0 Then Dim tmCF As IWorksheetCellFormat = e.CurrentWorksheet.Rows(e.CurrentRowIndex).Cells(e.CurrentColumnIndex).CellFormat tmCF.BottomBorderStyle = CellBorderLineStyle.Dotted tmCF.TopBorderStyle = CellBorderLineStyle.Dotted tmCF.LeftBorderStyle = CellBorderLineStyle.Dotted tmCF.RightBorderStyle = CellBorderLineStyle.Dotted End If End Sub
private void HeaderCellExportingEH(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.HeaderCellExportingEventArgs e) { if(e.CurrentColumnIndex%2==0) e.GridHeader.Appearance.BackColor = Color.Yellow; } private void HeaderCellExportedEH(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.HeaderCellExportedEventArgs e) { if(e.CurrentColumnIndex%2==0) { IWorksheetCellFormat tmCF = e.CurrentWorksheet.Rows[e.CurrentRowIndex].Cells[e.CurrentColumnIndex].CellFormat; tmCF.BottomBorderStyle = tmCF.TopBorderStyle = tmCF.LeftBorderStyle = tmCF.RightBorderStyle = CellBorderLineStyle.Dotted; } }
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2