php - html表格到phpexcel

Question

require_once 'data.php';
echo '<table cellspacing="3" cellpadding="2" border="1">';
reset($mas);
$header = current($mas);
$header = array_merge(array('tankla'=>'tankla'), $header);
foreach ($header as $key=>$val) {
    echo '<th>'.$key.'</th>';
}
echo '</tr>';
foreach ($mas as $tankla=>$data) {
    echo '<tr>';
    echo '<td>'.utf8_decode($tankla).'</td>';
    foreach ($data as $day=>$value) {
        echo '<td style="text-align: right;">'.$value.'</td>';
    }
    echo '</tr>';
}
echo '</table>';

我需要这个东西在 phpexcel 中。关于如何编写此代码的任何建议？

Answer 1

你可以看看PHPEXCEL图书馆

示例用法:

$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0);

//foreach loop{
    $objPHPExcel->getActiveSheet()->SetCellValue('A', <your_column_val>);
    $objPHPExcel->getActiveSheet()->SetCellValue('B', <your_column_val>);

//}
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save('your_file_name.xlsx');