How to export date or time to Excel in WinForms GridGroupingControl?
By default, the time values in the cells are not exported to Excel in WinForms GridGroupingControl; only the date value is exported. To export the DateTime value of the cell, you have to set the Format property to dd/MM/yyyy h:mm:ss tt in the QueryImportExportCellInfo event.
C#
GridExcelConverterControl converter = new GridExcelConverterControl();
converter.QueryImportExportCellInfo += converter_QueryImportExportCellInfo;
void converter_QueryImportExportCellInfo(object sender, GridImportExportCellInfoEventArgs e)
{
if (e.GridCell.CellType == GridCellTypeName.MonthCalendar)
{
//Format of the month calendar is changed.
e.GridCell.Format = "dd/MM/yyyy h:mm:ss tt";
}
}VB
Private converter As New GridExcelConverterControl()
Private converter.QueryImportExportCellInfo ,AddressOf converter_QueryImportExportCellInfo
Private Sub converter_QueryImportExportCellInfo(ByVal sender As Object, ByVal e As GridImportExportCellInfoEventArgs)
If e.GridCell.CellType Is GridCellTypeName.MonthCalendar Then
'Format of the month calendar is changed.
e.GridCell.Format = "dd/MM/yyyy h:mm:ss tt"
End If
End SubConclusion
I hope you enjoyed learning about how to export date or time to Excel in WinForms GridGroupingControl.
You can refer to our WinForms GridGroupingControl’s feature tour page to know about its other groundbreaking feature representations. You can also explore our WinForms GridGroupingControl documentation to understand how to present and manipulate data.
For current customers, you can check out our WinForms 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 WinForms GridGroupingControl and other WinForms components.
If you have any queries or require clarifications, please let us know in comments below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!
