PHP 讀取EXCEL

標籤：utf-8   attach   tco   讀取excel   log   class   function   array   put   

PHPExcel 自己下載。

PHP讀取EXCEL

public function import_Excel($file_name){        include_once LIB_ROOT_PATH."3rdParty/phpexcel/PHPExcel.php";        $objReader = PHPExcel_IOFactory::createReader(‘Excel2007‘);        $objPHPExcel = $objReader->load($file_name,$encode=‘utf-8‘);        $sheet = $objPHPExcel->getSheet(0);        $highestRow = $sheet->getHighestRow();//取得總行數        $highestColumn = $sheet->getHighestColumn();//取得總列數        $data = array();        for($i=2;$i<=$highestRow;$i++){            for($j=‘A‘;$j<=$highestColumn;$j++){                $data[$i][] = $objPHPExcel->getActiveSheet()->getCell("$j$i")->getValue();            }        }        return $data;    }

 

　　

PHP匯出EXCEL

public function data_excel(){ include_once LIB_ROOT_PATH."3rdParty/phpexcel/PHPExcel.php";        $objPHPExcel = new PHPExcel();        $objPHPExcel->setActiveSheetIndex(0)            ->setCellValue(‘A1‘, ‘相近字‘)              ->setCellValue(‘B1‘, ‘可能的字‘);        $i = 0;        foreach ($temp as $key => $value) {            $i++;            $objPHPExcel->getActiveSheet(0)->setCellValue(‘A‘.($i+1), $key);            $objPHPExcel->getActiveSheet(0)->setCellValue(‘B‘.($i+1), $value);        }        //  sheet命名          $objPHPExcel->getActiveSheet()->setTitle(‘易錯字統計‘);        $objPHPExcel->setActiveSheetIndex(0);          // excel頭參數          header(‘Content-Type: application/vnd.ms-excel‘);          header(‘Content-Disposition: attachment;filename="(‘.date(‘Ymd-His‘).‘).xlsx"‘);  //日期為檔案名稱尾碼          header(‘Cache-Control: max-age=0‘);        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel2007‘);  //excel5為xls格式，excel2007為xlsx格式          $objWriter->save(‘php://output‘);         exit;     } 

 

PHP 讀取EXCEL