Excel日期/时间存储数值转换为具体日期/时间(java实现)

在用POI的事件模型eventusermodel读取大容量Excel时发现读取的日期、时间格式输出后是浮点数字符串,然而没有找到有类似于usermodel的分格式读取的方法,于是编写一个工具类,把获取的浮点数转换成日期/时间格式,增加可用性。
Excel用浮点数标记日期时间,整数位代表日期,小数位代表时间。
代码如下:

package Util;

import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.GregorianCalendar;

/**
 * Created by yijie on 9/15/16.
 */
public class StringToDate {
    private static final int SECONDS_PER_MINUTE = 60;
    private static final int MINUTES_PER_HOUR = 60;
    private static final int HOURS_PER_DAY = 24;
    private static final int SECONDS_PER_DAY = (HOURS_PER_DAY * MINUTES_PER_HOUR * SECONDS_PER_MINUTE);
    /**
        一天的毫秒数
    **/
    private static final long DAY_MILLISECONDS = SECONDS_PER_DAY * 1000L;

    private static SimpleDateFormat sdFormat;

    /**
        转换方法
        @parma numberString 要转换的浮点数
        @parma format 要获得的格式 例如"hh:mm:ss"
    **/
    public static String toDate(double numberString, String format) {
        sdFormat = new SimpleDateFormat(format);
        int wholeDays = (int)Math.floor(numberString);
        int millisecondsInday = (int)((numberString - wholeDays) * DAY_MILLISECONDS + 0.5);
        Calendar calendar = new GregorianCalendar();
        setCalendar(calendar, wholeDays, millisecondsInday, false);
        return sdFormat.format(calendar.getTime());

    }
    private static void setCalendar(Calendar calendar, int wholeDays,
                                   int millisecondsInDay, boolean use1904windowing) {
        int startYear = 1900;
        int dayAdjust = -1; // Excel thinks 2/29/1900 is a valid date, which it isn't
        if (use1904windowing) {
            startYear = 1904;
            dayAdjust = 1; // 1904 date windowing uses 1/2/1904 as the first day
        }
        else if (wholeDays < 61) {
            // Date is prior to 3/1/1900, so adjust because Excel thinks 2/29/1900 exists
            // If Excel date == 2/29/1900, will become 3/1/1900 in Java representation
            dayAdjust = 0;
        }
        calendar.set(startYear,0, wholeDays + dayAdjust, 0, 0, 0);
        calendar.set(GregorianCalendar.MILLISECOND, millisecondsInDay);
    }
}
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值