php获取excel时间,详细介绍PHPExcel读取Excel时间的示例代码

PHPExcel读取Excel 时间//读取Excel文件

$info = pathinfo ( $path );

$ext = $info ['extension'];

$excelReader = null;

if ( $ext == 'xls' )

$excelReader = new PHPExcel_Reader_Excel5();

else

$excelReader = new PHPExcel_Reader_Excel2007();

$phpExcelInstance = $excelReader->load($path);

$sheet = $phpExcelInstance -> getSheet ( 0 );

// 读取第一個工作表

$highestRow = $sheet->getHighestRow(); // 取得总行数

$highestColumm = $sheet->getHighestColumn(); // 取得总列数

/** 循环读取每个单元格的数据 **/

$arr = array ();

for ( $row = 2 ; $row <= $highestRow ; $row ++ )

{ // 行数是以第2行开始

$cell = $sheet->getCellByColumnAndRow(0, $row);

$value = $cell->getValue();

if (empty($create_date) || !isset($create_date))

{

$create_date = date("Y-m-d");

}

else

{

if ($cell->getDataType()==PHPExcel_Cell_DataType::TYPE_NUMERIC)

{

$cellstyleformat=$cell->getStyle()->getNumberFormat(); //获取cell类型

$formatcode=$cellstyleformat->getFormatCode(); //获取cell格式代码，时间格式为mm-dd-yy

if (preg_match('/^(/[/$[A-Z]*-[0-9A-F]*/])*[hmsdy]/i', $formatcode))

{

$create_date = gmdate("Y-m-d", PHPExcel_Shared_Date::ExcelToPHP($value));

}else{

$create_date = PHPExcel_Style_NumberFormat::toFormattedString($value,$formatcode);

}

}

else

{

$create_date = date("Y-m-d");

}

}

//读取Excel文件

$info = pathinfo ( $path );

$ext = $info ['extension'];

$excelReader = null;

if ( $ext == 'xls' )

$excelReader = new PHPExcel_Reader_Excel5();

else

$excelReader = new PHPExcel_Reader_Excel2007();

$phpExcelInstance = $excelReader->load($path);

$sheet = $phpExcelInstance -> getSheet ( 0 );

// 读取第一個工作表

$highestRow = $sheet->getHighestRow(); // 取得总行数

$highestColumm = $sheet->getHighestColumn(); // 取得总列数

/** 循环读取每个单元格的数据 **/

$arr = array ();

for ( $row = 2 ; $row <= $highestRow ; $row ++ )

{ // 行数是以第2行开始

$cell = $sheet->getCellByColumnAndRow(0, $row);

$value = $cell->getValue();

if (empty($create_date) || !isset($create_date))

{

$create_date = date("Y-m-d");

}

else

{

if ($cell->getDataType()==PHPExcel_Cell_DataType::TYPE_NUMERIC)

{

$cellstyleformat=$cell->getStyle()->getNumberFormat(); //获取cell类型

$formatcode=$cellstyleformat->getFormatCode(); //获取cell格式代码，时间格式为mm-dd-yy

if (preg_match('/^(/[/$[A-Z]*-[0-9A-F]*/])*[hmsdy]/i', $formatcode))

{

$create_date = gmdate("Y-m-d", PHPExcel_Shared_Date::ExcelToPHP($value));

}else{

$create_date = PHPExcel_Style_NumberFormat::toFormattedString($value,$formatcode);

}

}

else

{

$create_date = date("Y-m-d");

}

}

相关文章：