java excel 日期,用Java程序将日期转换为序列号，就像在Excel中一样

I have written a function but it does not give an actual 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;

}

Main class

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));

}

Output date-----39556

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

My program O/P doesn't actually match with Excel O/P.

解决方案

The right algorithm is already implemented in Apache POI.

Take a look at class org.apache.poi.ss.usermodel.DateUtil.