| java.lang.Object
 org.apache.poi.hssf.usermodel.HSSFDateUtil
| HSSFDateUtil | | public class HSSFDateUtil (Code) | | Contains methods for dealing with Excel dates.
author:
Michael Harhen
author:
Glen Stampoultzis (glens at apache.org)
author:
Dan Sherman (dsherman at isisph.com)
author:
Hack Kampbjorn (hak at 2mba.dk)
author:
Alex Jacoby (ajacoby at gmail.com)
author:
Pavel Krupets (pkrupets at palmtreebusiness dot com) |
| Method Summary | |
| static int | absoluteDay(Calendar cal, boolean use1904windowing)
Given a Calendar, return the number of days since 1900/12/31. | | public static double | getExcelDate(Date date)
Given a Date, converts it into a double representing its internal Excel representation,
which is the number of days since 1/1/1900. | | public static double | getExcelDate(Date date, boolean use1904windowing)
Given a Date, converts it into a double representing its internal Excel representation,
which is the number of days since 1/1/1900. | | public static Date | getJavaDate(double date)
Given an Excel date with using 1900 date windowing, and
converts it to a java.util.Date.
NOTE: If the default TimeZone in Java uses Daylight
Saving Time then the conversion back to an Excel date may not give
the same value, that is the comparison
excelDate == getExcelDate(getJavaDate(excelDate,false))
is not always true. | | public static Date | getJavaDate(double date, boolean use1904windowing)
Given an Excel date with either 1900 or 1904 date windowing,
converts it to a java.util.Date.
NOTE: If the default TimeZone in Java uses Daylight
Saving Time then the conversion back to an Excel date may not give
the same value, that is the comparison
excelDate == getExcelDate(getJavaDate(excelDate,false))
is not always true. | | public static boolean | isADateFormat(int formatIndex, String formatString)
Given a format ID and its format String, will check to see if the
format represents a date format or not. | | public static boolean | isCellDateFormatted(HSSFCell cell)
Check if a cell contains a date
Since dates are stored internally in Excel as double values
we infer it is a date if it is formatted as such. | | public static boolean | isCellInternalDateFormatted(HSSFCell cell)
Check if a cell contains a date, checking only for internal
excel date formats. | | public static boolean | isInternalDateFormat(int format)
Given a format ID this will check whether the format represents
an internal excel date format or not. | | public static boolean | isValidExcelDate(double value)
Given a double, checks if it is a valid Excel date. |
| absoluteDay | | static int absoluteDay(Calendar cal, boolean use1904windowing)(Code) | | Given a Calendar, return the number of days since 1900/12/31.
days number of days since 1900/12/31
Parameters:
cal - the Calendar
exception:
IllegalArgumentException - if date is invalid |
| getExcelDate | | public static double getExcelDate(Date date)(Code) | | Given a Date, converts it into a double representing its internal Excel representation,
which is the number of days since 1/1/1900. Fractional days represent hours, minutes, and seconds.
Excel representation of Date (-1 if error - test for error by checking for less than 0.1)
Parameters:
date - the Date |
| getExcelDate | | public static double getExcelDate(Date date, boolean use1904windowing)(Code) | | Given a Date, converts it into a double representing its internal Excel representation,
which is the number of days since 1/1/1900. Fractional days represent hours, minutes, and seconds.
Excel representation of Date (-1 if error - test for error by checking for less than 0.1)
Parameters:
date - the Date
Parameters:
use1904windowing - Should 1900 or 1904 date windowing be used? |
| getJavaDate | | public static Date getJavaDate(double date)(Code) | | Given an Excel date with using 1900 date windowing, and
converts it to a java.util.Date.
NOTE: If the default TimeZone in Java uses Daylight
Saving Time then the conversion back to an Excel date may not give
the same value, that is the comparison
excelDate == getExcelDate(getJavaDate(excelDate,false))
is not always true. For example if default timezone is
Europe/Copenhagen, on 2004-03-28 the minute after
01:59 CET is 03:00 CEST, if the excel date represents a time between
02:00 and 03:00 then it is converted to past 03:00 summer time
Parameters:
date - The Excel date. Java representation of the date, or null if date is not a valid Excel date
See Also: java.util.TimeZone |
| getJavaDate | | public static Date getJavaDate(double date, boolean use1904windowing)(Code) | | Given an Excel date with either 1900 or 1904 date windowing,
converts it to a java.util.Date.
NOTE: If the default TimeZone in Java uses Daylight
Saving Time then the conversion back to an Excel date may not give
the same value, that is the comparison
excelDate == getExcelDate(getJavaDate(excelDate,false))
is not always true. For example if default timezone is
Europe/Copenhagen, on 2004-03-28 the minute after
01:59 CET is 03:00 CEST, if the excel date represents a time between
02:00 and 03:00 then it is converted to past 03:00 summer time
Parameters:
date - The Excel date.
Parameters:
use1904windowing - true if date uses 1904 windowing,or false if using 1900 date windowing. Java representation of the date, or null if date is not a valid Excel date
See Also: java.util.TimeZone |
| isADateFormat | | public static boolean isADateFormat(int formatIndex, String formatString)(Code) | | Given a format ID and its format String, will check to see if the
format represents a date format or not.
Firstly, it will check to see if the format ID corresponds to an
internal excel date format (eg most US date formats)
If not, it will check to see if the format string only contains
date formatting characters (ymd-/), which covers most
non US date formats.
Parameters:
formatIndex - The index of the format, eg from ExtendedFormatRecord.getFormatIndex
Parameters:
formatString - The format string, eg from FormatRecord.getFormatString
See Also: HSSFDateUtil.isInternalDateFormat(int) |
| isValidExcelDate | | public static boolean isValidExcelDate(double value)(Code) | | Given a double, checks if it is a valid Excel date.
true if valid
Parameters:
value - the double value |
|
|