Example usage for Java org.apache.poi.ss.usermodel DateUtil fields, constructors, methods, implement or subclass
The text is from its open source code.
| long | DAY_MILLISECONDS |
| double | convertTime(String timeStr) Converts a string of format "HH:MM" or "HH:MM:SS" to its (Excel) numeric equivalent |
| double | getExcelDate(LocalDate date) Given a LocalDate, converts it into a double representing its internal Excel representation, which is the number of days since 1/1/1900. |
| double | getExcelDate(LocalDateTime date) Given a LocalDateTime, converts it into a double representing its internal Excel representation, which is the number of days since 1/1/1900. |
| 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. |
| double | getExcelDate(LocalDate date, boolean use1904windowing) Given a LocalDate, converts it into a double representing its internal Excel representation, which is the number of days since 1/1/1900. |
| double | getExcelDate(LocalDateTime date, boolean use1904windowing) Given a LocalDateTime, converts it into a double representing its internal Excel representation, which is the number of days since 1/1/1900. |
| 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. |
| double | getExcelDate(Calendar date, boolean use1904windowing) Given a Date in the form of a Calendar, converts it into a double representing its internal Excel representation, which is the number of days since 1/1/1900. |
| Calendar | getJavaCalendarUTC(double date, boolean use1904windowing) Get EXCEL date as Java Calendar with UTC time zone. |
| Date | getJavaDate(double date) Given an Excel date with using 1900 date windowing, and converts it to a java.util.Date. |
| Date | getJavaDate(double date, TimeZone tz) Given an Excel date with using 1900 date windowing, and converts it to a java.util.Date. |
| Date | getJavaDate(double date, boolean use1904windowing) Given an Excel date with either 1900 or 1904 date windowing, converts it to a java.util.Date. |
| 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. |
| boolean | isADateFormat(ExcelNumberFormat numFmt) Given a format ID and its format String, will check to see if the format represents a date format or not. |
| boolean | isCellDateFormatted(Cell 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. |
| boolean | isCellInternalDateFormatted(Cell cell) Check if a cell contains a date, checking only for internal excel date formats. |
| boolean | isValidExcelDate(double value) Given a double, checks if it is a valid Excel date. |
| Date | parseYYYYMMDDDate(String dateStr) Converts a string of format "YYYY/MM/DD" to its (Excel) numeric equivalent |
| void | setCalendar(Calendar calendar, int wholeDays, int millisecondsInDay, boolean use1904windowing, boolean roundSeconds) |