时间戳

首页 > 解决方案 > php excel为多维数组创建excel

php - php excel为多维数组创建excel

问题描述

我在变量中得到这样的数组现在我想以这种格式使用它创建一个 excel 我如何循环通过它以这种方式获得 excel。excel的格式我想以哪种方式在excel上显示我的数据请帮助我与此相关我是新手在这里thanx提前

Array
(
            [id] => 266
            [comp] => 374
            [freq] => Week 1
            [empComp] => Array
                (
                    [0] => Array
                        (
                    [name] => ABC
                    [value] => 123
                    [age] => 19
                        )

                    [1] => Array
                        (
                            [name] => XYZ
                            [value] => 123
                            [age] => 20
                       ) 

        )

)


Array
(
            [id] => 277
            [comp] => 355
            [freq] => Week 2
            [empComp] => Array
                (
                    [0] => Array
                        (
                    [name] => ABC1
                    [value] => 1231
                    [age] => 21
                        )

                    [1] => Array
                        (
                            [name] => XYZ1
                            [value] => 1231
                            [age] => 22
                       ) 

        )

)



....................................................
id      |     226       |      comp     |    374 |             
....................................................
name    |      value          |     age            |
....................................................
ABC     |     123             |          19        |
XYZ     |     423             |          20        |
....................................................
id      |     277       |      comp     |    355 |             
....................................................
name    |      value          |     age            |
....................................................
ABC1     |     1231             |          21       |
XYZ1    |     4231             |          22        |
.....................................................

标签： phpphp-5.6

解决方案

假设您的数组存储在$mainArr.

你可以写这样的东西来实现你想要的输出。

我以表格格式显示结果，但您可以放置​​您的 excel 语法。

echo "<table>";

foreach($mainArr as $values){

    echo "<tr>";
    echo "<td>" . "id" . "</td><td>" . $values['id'] . "</td>";
    echo "<td>" ."comp " . "</td><td>" . $values['comp'] ." </td>";
    echo "</tr>";
    echo "<tr>";
    echo "<td>Name</td>";
    echo "<td>Value</td>";
    echo "<td>Age</td>";
    echo "</tr>";

    foreach($values['empComp'] as $value){ 

        echo "<tr>";
        echo "<td>" . $value['name'] . "</td>";
        echo "<td>" . $value['value'] . "</td>";
        echo "<td>" . $value['age'] ."</td>";
    }
}

echo "</table>";

让我知道上面的代码是否为您提供了所需的输出。

推荐阅读