Package com.hybris.backoffice.excel.util
Class DefaultExcelDateUtils
java.lang.Object
com.hybris.backoffice.excel.util.DefaultExcelDateUtils
- All Implemented Interfaces:
ExcelDateUtils
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionconvertToImportedDate(String date) Converts given date in excel date timezone into system date in system timezone.exportDate(Date date) Exports given date in excel date timezone usingExcelDateUtils.getDateTimeFormat()exportDateRange(Date start, Date end) Exports date rangeextractDateRange(String cellValue) Extracts from given value start and end date.Returns date range param key which will beExcelDateUtils.getDateRangePattern()without [ and ] around the range.Returns date range patter used in excel column header e.g.Return date and time format e.g.Timezone in which dates are exported into excel e.g.importDate(String date) Converts date in excel date timezone into system date zone date string.voidsetDateTimeFormat(String dateTimeFormat) voidsetExportTimeZone(String exportTimeZone) voidsetI18NService(I18NService i18NService)
-
Constructor Details
-
DefaultExcelDateUtils
public DefaultExcelDateUtils()
-
-
Method Details
-
extractDateRange
Description copied from interface:ExcelDateUtilsExtracts from given value start and end date. Expected format is "start to end"- Specified by:
extractDateRangein interfaceExcelDateUtils- Parameters:
cellValue- value from which date range will be extracted.- Returns:
- pair of start and end date.
-
getDateRangePattern
Description copied from interface:ExcelDateUtilsReturns date range patter used in excel column header e.g. [dd.MM.yyyy HH:mm:ss to dd.MM.yyyy HH:mm:ss]- Specified by:
getDateRangePatternin interfaceExcelDateUtils- Returns:
- string with date range pattern.
-
getDateRangeParamKey
Description copied from interface:ExcelDateUtilsReturns date range param key which will beExcelDateUtils.getDateRangePattern()without [ and ] around the range.- Specified by:
getDateRangeParamKeyin interfaceExcelDateUtils- Returns:
- date range param key.
-
exportDateRange
Description copied from interface:ExcelDateUtilsExports date range- Specified by:
exportDateRangein interfaceExcelDateUtils- Parameters:
start- start dateend- end date- Returns:
- string representation of date range which follows pattern from
ExcelDateUtils.getDateRangePattern()
-
getDateTimeFormat
Description copied from interface:ExcelDateUtilsReturn date and time format e.g. dd.MM.yyyy HH:mm:ss.- Specified by:
getDateTimeFormatin interfaceExcelDateUtils- Returns:
- dateTime format.
-
exportDate
Description copied from interface:ExcelDateUtilsExports given date in excel date timezone usingExcelDateUtils.getDateTimeFormat()- Specified by:
exportDatein interfaceExcelDateUtils- Parameters:
date- date to be exported- Returns:
- date string representation in excel date timezone
ExcelDateUtils.getExportTimeZone().
-
importDate
Description copied from interface:ExcelDateUtilsConverts date in excel date timezone into system date zone date string.- Specified by:
importDatein interfaceExcelDateUtils- Parameters:
date- date in excel date timezoneExcelDateUtils.getExportTimeZone()- Returns:
- date string in system timezone.
-
convertToImportedDate
Description copied from interface:ExcelDateUtilsConverts given date in excel date timezone into system date in system timezone.- Specified by:
convertToImportedDatein interfaceExcelDateUtils- Parameters:
date- date in excel date timezoneExcelDateUtils.getExportTimeZone()- Returns:
- date in system timezone.
-
getExportTimeZone
Description copied from interface:ExcelDateUtilsTimezone in which dates are exported into excel e.g. UTC- Specified by:
getExportTimeZonein interfaceExcelDateUtils- Returns:
- excel timezone
-
setExportTimeZone
-
setDateTimeFormat
-
setI18NService
-