java excel 日期_使用Java编程将日期转换为序列号,如在Excel...

我写了一个函数,但它没有提供实际的O / P …

public int date(Object O) {

if (O instanceof Date) {

Date d1 = (Date) O;

Calendar cal = Calendar.getInstance();

cal.setTime(d1);

int dd, mm, yy;

dd = cal.get(Calendar.DAY_OF_MONTH);

mm = cal.get(Calendar.MONTH);

yy = cal.get(Calendar.YEAR);

if (dd == 29 && mm == 02 && yy == 1900)

return 60;

long nSerialDate = ((1461 * (yy + 4800 + ((mm - 14) / 12))) / 4)

+ ((367 * (mm - 2 - 12 * ((mm - 14) / 12))) / 12)

- ((3 * (((yy + 4900 + ((mm - 14) / 12)) / 100))) / 4) + dd

- 2415019 - 32075;

if (nSerialDate < 60) {

// Because of the 29-02-1900 bug, any serial date

// under 60 is one off... Compensate.

nSerialDate--;

}

return (int) nSerialDate;

}

return -1;

}

主要课程

p s v main(String args[]){

CommonFunctionsImpl cmp= new CommonFunctionsImpl();

Date date1 = null;

try {

date1 = new SimpleDateFormat("MM/dd/yy").parse("05/18/2008");

} catch (ParseException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

System.out.println("date-----"+cmp.date(date1));

}

输出日期—– 39556

在Excel DATE(2008,5,18)= 39586.00

我的程序O / P实际上与Excel O / P不匹配.