Excel 日期轉換

標籤：style   blog   color   os   art   io   

public static void importExcel2(File file) throws Exception, IOException {        Workbook book  =  Workbook.getWorkbook(file);        //  獲得第一個工作表對象         Sheet sheet  =  book.getSheet( 0 );        //  得到第一列第一行的儲存格          int  columnum  =  sheet.getColumns(); //  得到列數          int  rownum  =  sheet.getRows(); //  得到行數         System.out.println(columnum);       System.out.println(rownum);        for  ( int  i  =   1 ; i  <  rownum; i ++ ) //  迴圈進行讀寫          {//            for  ( int  j  =   0 ; j  <  columnum; j ++ )  {//           }              CaseInfor caseInfor = new CaseInfor();            System.out.print(sheet.getCell(0, i).getContents());            caseInfor.title=sheet.getCell(0, i).getContents();//            if(sheet.getCell(0, i).getContents()==""){//                 flash.put("error", "標題不可為空");//                 list(null,null);//            }                                    Cell cell1  =  sheet.getCell(1, i);            if(sheet.getCell(1, i).getType() == CellType.DATE){                DateCell dc = (DateCell)cell1;                    Date date = dc.getDate();                        SimpleDateFormat ds = new SimpleDateFormat("yyyy-MM-dd");                        String    cellcon = ds.format(date);                            System.out.print(cellcon);                             System.out.print( " \t " );                             caseInfor.acceptTime=date;          }            Cell cell2  =  sheet.getCell(2, i);            if(sheet.getCell(1, i).getType() == CellType.DATE){                DateCell dc = (DateCell)cell2;                Date date = dc.getDate();                SimpleDateFormat ds = new SimpleDateFormat("yyyy-MM-dd");                String    cellcon = ds.format(date);                System.out.print(cellcon);                 caseInfor.deadTime=date;                System.out.print( " \t " );            }            caseInfor.department=sheet.getCell(3, i).getContents();            caseInfor.process=sheet.getCell(4, i).getContents();            caseInfor.account=sheet.getCell(5, i).getContents();            caseInfor.information=sheet.getCell(6, i).getContents();            caseInfor.mandatory=sheet.getCell(7, i).getContents();            caseInfor.save();       }        book.close();       flash.put("success", "匯入成功");       list(null,null);    }