Package com.hybris.backoffice.excel.util

Interface ExcelDateUtils

All Known Implementing Classes:
DefaultExcelDateUtils
public interface ExcelDateUtils
Utility for excel date operations.

  • Method Details

    • extractDateRange

      org.apache.commons.lang3.tuple.Pair<String,String> extractDateRange(String cellValue)
      Extracts from given value start and end date. Expected format is "start to end"
      Parameters:
      cellValue - value from which date range will be extracted.
      Returns:
      pair of start and end date.

    • getDateRangePattern

      String getDateRangePattern()
      Returns date range patter used in excel column header e.g. [dd.MM.yyyy HH:mm:ss to dd.MM.yyyy HH:mm:ss]
      Returns:
      string with date range pattern.

    • getDateRangeParamKey

      String getDateRangeParamKey()
      Returns date range param key which will be getDateRangePattern() without [ and ] around the range.
      Returns:
      date range param key.

    • exportDateRange

      String exportDateRange(Date start, Date end)
      Exports date range
      Parameters:
      start - start date
      end - end date
      Returns:
      string representation of date range which follows pattern from getDateRangePattern()

    • getDateTimeFormat

      String getDateTimeFormat()
      Return date and time format e.g. dd.MM.yyyy HH:mm:ss.
      Returns:
      dateTime format.

    • exportDate

      String exportDate(Date date)
      Exports given date in excel date timezone using getDateTimeFormat()
      Parameters:
      date - date to be exported
      Returns:
      date string representation in excel date timezone getExportTimeZone().

    • importDate

      String importDate(String date)
      Converts date in excel date timezone into system date zone date string.
      Parameters:
      date - date in excel date timezone getExportTimeZone()
      Returns:
      date string in system timezone.

    • convertToImportedDate

      Date convertToImportedDate(String date)
      Converts given date in excel date timezone into system date in system timezone.
      Parameters:
      date - date in excel date timezone getExportTimeZone()
      Returns:
      date in system timezone.

    • getExportTimeZone

      String getExportTimeZone()
      Timezone in which dates are exported into excel e.g. UTC
      Returns:
      excel timezone