TExportCellDateTime

TExportCellTExportCellCustomNumberTExportCellDateTime

Description

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.

Properties

NameTypeDescription
DateTimeTDateTimeDatetime value of the cell.
DateTimeFormatOWideStringDelphi-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).
DateTimeTypeTExportCellDateTimeTypeSet Read-only property that returns the date type of the current cell:
  • [dtDate] - cell is formatted as date-only.
  • [dtTime] - cell is formatted as time-only.
  • [dtDate, dtTime] - cell is formatted as datetime.
AllowMoreThan24HoursBoolean Applicable only to time cells:
  • False: only time value will be extracted from the DateTime property (maximum allowed value is 23:59:59. Negative time is not allowed.
  • True: the DateTime property will be formatted as time from 31.12.1899. Negative time is allowed in Calc but not in Excel.
    Example: DateTime = 2 will be formatted as 48:00:00.

TExportCellDate

TExportCellTExportCellCustomNumberTExportCellDateTimeTExportCellDate

Description

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.

TExportCellTime

TExportCellTExportCellCustomNumberTExportCellDateTimeTExportCellTime

Description

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.

TExportCellDateTimeWS

TExportCellTExportCellCustomNumberTExportCellDateTimeTExportCellDateTimeWS

Description

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).

TExportCellTimeWS

TExportCellTExportCellCustomNumberTExportCellDateTimeTExportCellTimeTExportCellTimeWS

Description

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).

Categories