phpexcel 导入操作 excel日期类型转换

最新推荐文章于 2024-08-20 17:53:53 发布

deven-wu

最新推荐文章于 2024-08-20 17:53:53 发布

阅读量4.6k

点赞数

分类专栏： php 文章标签： excel file

php 专栏收录该内容

6 篇文章

订阅专栏

Vendor("PHPExcel.PHPExcel");//导入PHPExcel类
Vendor("PHPExcel.PHPExcel.IOFactory");

   $objReader = PHPExcel_IOFactory::createReader('Excel2007');//创建Excel2007版本的reader对象

   $objPHPExcel = $objReader->load($save_file);//读取Excel文件到PHPExcel

   $objPHPExcel->setActiveSheetIndex(0);
   $objWorksheet = $objPHPExcel->getActiveSheet();
   $heighest = $objWorksheet->getHighestRow();

   $birthday = $objWorksheet->getCellByColumnAndRow(3, $i)->getValue();
   //   die($birthday);
    //日期格式yyyy-mm-dd
    if(is_numeric($birthday)){
     //based on 1900-1-1
     $jd = GregorianToJD(1, 1, 1970);
     $gregorian = JDToGregorian($jd+intval($birthday)-25569);
     $myDate = explode('/',$gregorian);
     $myDateStr = str_pad($myDate[2],4,'0', STR_PAD_LEFT)
       ."-".str_pad($myDate[0],2,'0', STR_PAD_LEFT)
       ."-".str_pad($myDate[1],2,'0', STR_PAD_LEFT)
       .($time?" 00:00:00":'');
     $birthday = $myDateStr;
    }