php 导入excel

来源:互联网 发布:台湾旅游软件 编辑:程序博客网 时间:2024/06/01 08:17
$cwd = getcwd();chdir( DIR_SYSTEM.'PHPExcel' );require_once( 'Classes/PHPExcel.php' );chdir( $cwd );
// parse uploaded spreadsheet file$inputFileType = PHPExcel_IOFactory::identify($filename);$objReader = PHPExcel_IOFactory::createReader($inputFileType);$objReader->setReadDataOnly(true);$reader = $objReader->load($filename);         set_time_limit(0);
$data = $reader->getSheetByName( 'Categories' );
$i = 0;$k = $data->getHighestRow();for ($i=0; $i<$k; $i+=1) {   if ($i==0) {      $max_col = PHPExcel_Cell::columnIndexFromString( $data->getHighestColumn() );      for ($j=1; $j<=$max_col; $j+=1) {         $first_row[] = $this->getCell($data,$i,$j);      }      continue;   }   $j = 1;