excel导入时间文本格式转换

有时候再在poi开源类中，如果用Excel导入时间格式是43188.468333这种格式;

其中43188是yyyy-MM-dd，0.468333是hh:mm:ss;

需要将43188转换成2018-03-29格式， 0.468333转换成11:14:24格式.

如下代码（转换 年月日 时分秒）：

public static Date getDate(int days) {

Calendar c = Calendar.getInstance();

c.set(1900, 0, 1);

c.add(Calendar.DATE, days - 2);

return c.getTime();

}

public static Date getTime(Date date, double ditNumber) {

Calendar c = Calendar.getInstance();

int mills = (int) (Math.round(ditNumber * 24 * 3600));

int hour = mills / 3600;

int minute = (mills - hour * 3600) / 60;

int second = mills - hour * 3600 - minute * 60;

c.setTime(date);

c.set(Calendar.HOUR_OF_DAY, hour);

c.set(Calendar.MINUTE, minute);

c.set(Calendar.SECOND, second);

return c.getTime();

}

public static void main(String[] args) throws java.lang.Exception {

// SimpleDateFormat s = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");

// System.out.println(s.format(43188.468333)); Excel数字时间

int days = 43188;

double ditNumber = 0.468333;

Date date =new DateConvert().getDate(days);

Date dateTime = new DateConvert().getTime(date, ditNumber);

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

System.out.println(sdf.format(dateTime));

              //输出：yyyy-MM-DD 11:14:24

}

//只转换年月日

String  deliveryDate_name = list.get ( deliveryDate_index ).trim ().toString ();//获取到时间
Integer fomatDate = Integer.valueOf ( deliveryDate_name );//转换时间成
 Date date_fomatDate = getDate(fomatDate);//转换方法
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String deliveryDate_nameYMD = sdf.format ( date_fomatDate );

public static Date getDate(int days) {
        Calendar c = Calendar.getInstance();
        c.set(1900, 0, 1);
        c.add(Calendar.DATE, days - 2);
        return c.getTime();
    }

 

 

                              

转载于:https://www.cnblogs.com/ysySelf/p/11528106.html