前端之家

  1. 首页
  2. 问答

从.xlsx（excel）文件中读取数据并排列/管理数组或创建数组

• 问答

我想从Excel文件中水平和垂直读取数据并将其排列在数组中，但是我可以根据以下结果/格式创建数组。 

code .

下面是我尝试过的代码。

"node"

代码示例

https://repl.it/repls/GrizzledAdventurousMicrokernel

Excel formate

从.xlsx（excel）文件中读取数据并排列/管理数组或创建数组

我当前的输出 

Array
(
    [ZWL] => Array
        (
            [ZWL] => 1
            [ZMW] => 2
            [ZAR] => 3
            [YER] => 4
            [XPF] => 5
        )

    [ZMW] => Array
        (
            [ZWL] => 6
            [ZMW] => 7
            [ZAR] => 8
            [YER] => 9
            [XPF] => 10
        )

    [ZAR] => Array
        (
            [ZWL] => 11
            [ZMW] => 12
            [ZAR] => 13
            [YER] => 14
            [XPF] => 15
        )

    [YER] => Array
        (
            [ZWL] => 16
            [ZMW] => 17
            [ZAR] => 18
            [YER] => 19
            [XPF] => 20
        )

    [XPF] => Array
        (
            [ZWL] => 21
            [ZMW] => 22
            [ZAR] => 23
            [YER] => 24
            [XPF] => 25
        )

    [XOF] => Array
        (
            [ZWL] => 26
            [ZMW] => 27
            [ZAR] => 28
            [YER] => 29
            [XPF] => 30
        )

    [XCD] => Array
        (
            [ZWL] => 31
            [ZMW] => 32
            [ZAR] => 33
            [YER] => 34
            [XPF] => 35
        )

    [XAF] => Array
        (
            [ZWL] => 36
            [ZMW] => 37
            [ZAR] => 38
            [YER] => 39
            [XPF] => 40
        )

    [WST] => Array
        (
            [ZWL] => 41
            [ZMW] => 42
            [ZAR] => 43
            [YER] => 44
            [XPF] => 45
        )

)
zmc9556 回答：从.xlsx（excel）文件中读取数据并排列/管理数组或创建数组

在代码下方，您应该尝试一次。因为我得到了您的预期结果。 

<?php 
require_once ('SimpleXLSX.php');

if ($xlsx = SimpleXLSX::parse('test.xlsx')) 
{

    $first_row = []; 
    $final_arr = [];

    foreach ($xlsx->rows() as $key => $row) 
    {

      if (empty($first_row))
      {
          $first_row = array_filter($row);
      }
      else
      {

         foreach($first_row as $col_number => $col)
         {
             $final_arr[$col][$row[1]] = $row[$col_number];
         }

      }

    }

    echo '<pre>';
    print_r($final_arr);
    echo '</pre>';

} 
else 
{
    echo SimpleXLSX::parseError();
}
arrayscreatearrayexcelphpreaddatafromexcelsheet
本文链接：https://www.f2er.com/3157186.html

大家都在问