<?php

require_once 'PHPExcel.php';
require_once ("PHPExcel/Writer/Excel5.php");
require_once ("PHPExcel/Reader/Excel5.php");

$data = array();
$filename = "data.xls";
//获取xls的内容
try {
$o = new PHPExcel_Reader_Excel5();
$d = $o->load($filename);
$cell = $d->getAllSheets();
$data = $cell[0]->toArray();
//print_r($data);exit;
}
catch (Exception $e) {
echo $e->getMessage();
}

//$data 的值 Array ( [1] => Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 5 ) [2] => Array ( [0] => 2 [1] => 3 [2] => 4 [3] => 5 [4] => 6 ) )

$title = 'first';
$filename = $title.".xls"; //@iconv("UTF-8", "GB2312//IGNORE", $title);
$excel = new PHPExcel();
$excel->setActiveSheetIndex(0);
$excel->getActiveSheet()->setCellValue('A1', '频道');
$excel->getActiveSheet()->setCellValue('B1', '姓名');
$excel->getActiveSheet()->setCellValue('C1', '手机号');
$excel->getActiveSheet()->setCellValue('D1', '公司名');
$excel->getActiveSheet()->setCellValue('E1', '服务专员');

$i = 2;
foreach ($data as $d) {
$excel->getActiveSheet()->setCellValue('A'.$i, $d['channel']);
$excel->getActiveSheet()->setCellValue('B'.$i, $d['username']);
$excel->getActiveSheet()->setCellValue('C'.$i, $d['number']);
$excel->getActiveSheet()->setCellValue('D'.$i, $d['corpname']);
$excel->getActiveSheet()->setCellValue('E'.$i, $d['waitername']);
$i++;
}
$excel->getActiveSheet()->calculateColumnWidths();
$excel->setActiveSheetIndex(0);

header('Content-type: application/xls');
header("Content-Disposition: attachment; filename={$filename}");
header("Content-Transfer-Encoding:binary");

$objWriter = new PHPExcel_Writer_Excel5($excel);
$objWriter->save('php://output');
$objWriter = null;
?>