TExportCell → TExportCellCustomNumber → TExportCellDateTime
Use TExportCellDate for date and time cells. Example date formatting: 01.12.2012 15:48:12 (default format is system-dependent, you may specify your own with DateTimeFormat property).
Important note: Excel can store dates only after 30.12.1890. Therefore OExport converts all dates before 30.12.1890 to strings automatically.
Name | Type | Description |
---|---|---|
DateTime | TDateTime | Datetime value of the cell. |
DateTimeFormat | OWideString | Delphi-compatible date-time formatting string
(you can use it e.g. in DateTimeToString. Please note that language codes are not supported for day and month names. By default, the format strings from TExportWorksheet NewCellDateFormat (date cells) NewCellTimeFormat (time cells) is used. If you have to use excel language codes, please use the function TExportCell.SetExcelNumberFormatAndTransform (see more information there). |
DateTimeType | TExportCellDateTimeTypeSet |
Read-only property that returns the date type of the current cell:
|
AllowMoreThan24Hours | Boolean |
Applicable only to time cells:
|
TExportCell → TExportCellCustomNumber → TExportCellDateTime → TExportCellDate
Use TExportCellDateTime for datetime cells. Example date formatting: 01.12.2012
(default format is system-dependent, you may specify your own with DateTimeFormat property).
Please use the property TExportWorkSheet.NewCellDateFormat if you want to set
a specific date format for all new cells within a sheet.
TExportCell → TExportCellCustomNumber → TExportCellDateTime → TExportCellTime
Use TExportCellTime for time cells. Example time formatting: 12:54:13
(default format is system-dependent, you may specify your own with DateTimeFormat property).
Please use the property TExportWorkSheet.NewCellTimeFormat if you want to set
a specific time format for all new cells within a sheet.
TExportCell → TExportCellCustomNumber → TExportCellDateTime → TExportCellDateTimeWS
Use TExportCellDateTimeWS for datetime cells (without seconds). Example date formatting: 01.12.2012 12:54 (default format is system-dependent, you may specify your own with DateTimeFormat property).
TExportCell → TExportCellCustomNumber → TExportCellDateTime → TExportCellTime → TExportCellTimeWS
Use TExportCellTimeWS for time cells (without seconds). Example time formatting: 12:54 (default format is system-dependent, you may specify your own with DateTimeFormat property).