<?php
require_once 'PHPExcel.php';
require_once 'libs/IOFactory.php';
require_once 'libs/Excel5.php';
require_once 'Common_Oper.php';
class Excel_Oper
{
function ArrayToExcel($par_columans,$par_array,$filename)
{
try{
$resultExcel=new PHPExcel();
$columns=array('A1','B1','C1','D1','E1','F1','G1','H1','I1','J1','K1','L1','M1','L1','O1','P1','Q1','R1','S1','T1','U1','V1','W1','X1','Y1','Z1');
$columns2=array('A','B','C','D','E','F','G','H','I','J','K','L','M','L','O','P','Q','R','S','T','U','V','W','X','Y','Z');
//表头
if(is_array($par_columans))
{
for($n=0;$n<sizeof($par_columans);$n++)
{
$resultExcel->getActiveSheet()->setCellValue($columns[$n],$par_columans[$n]);
}
}
//标题
if(is_array($par_array))
{
$p=2;
$com_oper=new Common_Oper();
if($com_oper->IsNumArray($par_array))
{
for($n=0;$n<sizeof($par_array);$n++)
{
for($i=0;$i<sizeof($par_array[$n]);$i++)
{
$resultExcel->getActiveSheet()->setCellValue($columns2[$i].$p,$par_array[$n][$i]);
}
$p++;
}
}else
{
$p=2;
foreach($par_array as $key=>$value)
{
foreach($par_columans as $key2=>$value2)
{
$resultExcel->getActiveSheet()->setCellValue($columns2[$key2].$p,$value[$value2]);
}
$p++;
}
}
}
$xlswrite=new PHPExcel_Writer_Excel5($resultExcel);
$xlswrite->save("E:\\4.xls");
$xlswrite->save("C:\\wamp\\www\\phpstudy\\4.xls");
echo '<script>window.location.href=".//4.xls"</script>';
echo "看结果!";
/*header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header('Content-Disposition:inline;filename="'.$filename.'"');
header("Content-Transfer-Encoding: binary");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: no-cache");
//$xlswrite->save($filename);
$xlswrite->save( "php://output" );*/
}catch(Exception $exception)
{
echo $exception->getMessage();
}
}
}
?>