PHPEXCEL 讀取excel ，寫入excel

1、include 這三隻
require_once(PHPExcel.php") ;
require_once(PHPExcel/IOFactory.php") ;
require_once(PHPExcel/Reader/Excel5.php") ;


讀取的部分
2、for2003前的版本
$reader = PHPExcel_IOFactory::createReader('Excel5');
$PHPExcel = $reader->load('2012_09_05_member.xls'); // 檔案名稱 需與執行的程式放在同一目錄
$sheet = $PHPExcel->getSheet(0); // 讀取第一個工作表(編號從 0 開始)
$highestRow = $sheet->getHighestRow(); // 取得總列數


$i =0;
// 一次讀取一列
for ($row = 2; $row <= $highestRow; $row++) {
for ($column = 0; $column <= 7; $column++) {
$val = $sheet->getCellByColumnAndRow($column, $row)->getValue();
// echo $val . '';
}
$i++;
// echo "<br />";
}

寫入的部份：
3、

$PHPExcel->setActiveSheetIndex(0);
$l=0;
 for ($k = 0; $k < count($member) ; $k++) {
$PHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8,($k+2) ,$member[$l][8]);
  $l++;
 }


4、輸出的部份

$PHPExcelWriter = PHPExcel_IOFactory::createWriter($PHPExcel, 'Excel5');
$PHPExcelWriter->save('檔名');
ob_end_clean();
header("Content-type: application/force-download");
header("Content-Disposition: attachment; filename= 檔名 ");
header("Content-Length: ".filesize(' 檔名 '));
@readfile(' 檔名 ');