How to export the date along with the time value to Excel in WinForms?
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 Sub
Conclusion
I hope you enjoyed learning about how to export the date along with the time value to Excel in WinForms.
You can refer to our WinForms GridGroupingControl feature tour page to know about its other groundbreaking feature representations and documentation, to understand how to create and manipulate data.
For current customers, you can check out our 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 other controls.
If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!
