//导出excel格式表
function exportData($filename,$title,$data){
header("Content-type: application/vnd.ms-excel;charset=gb2312");
header("Content-disposition: attachment; filename=" . $filename . ".xls");
echo '<html>';
echo '<head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><style type="text/css">body{font-family:"宋体";} tr{height:40px;} #blue{background-color:#33CCCC;} td{text-align:center}</sytle></head>';
echo '<body>';
if (is_array($title)){
echo '<table border="1">';
echo '<tr>';
foreach ($title as $key => $value){
echo '<th>'.$value.'</th>';
}
echo '</tr>';
}
if (is_array($data)){
$i = 0;
foreach ($data as $key => $value){
$i++;
if ($i % 2 == 0){
echo '<tr>';
}else{
echo '<tr id="blue">';
}
foreach ($value as $_key => $_value){
echo '<td>'.$_value.'</td>';
}
echo "</tr>";
}
}
echo '</table>';
echo '</body>';
echo '</html>';
}
function exportData($filename,$title,$data){
header("Content-type: application/vnd.ms-excel;charset=gb2312");
header("Content-disposition: attachment; filename=" . $filename . ".xls");
echo '<html>';
echo '<head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><style type="text/css">body{font-family:"宋体";} tr{height:40px;} #blue{background-color:#33CCCC;} td{text-align:center}</sytle></head>';
echo '<body>';
if (is_array($title)){
echo '<table border="1">';
echo '<tr>';
foreach ($title as $key => $value){
echo '<th>'.$value.'</th>';
}
echo '</tr>';
}
if (is_array($data)){
$i = 0;
foreach ($data as $key => $value){
$i++;
if ($i % 2 == 0){
echo '<tr>';
}else{
echo '<tr id="blue">';
}
foreach ($value as $_key => $_value){
echo '<td>'.$_value.'</td>';
}
echo "</tr>";
}
}
echo '</table>';
echo '</body>';
echo '</html>';
}