Very simple excel file to php array returns me too many nested arrays?

Question

Excel file:

PHP code (excel to array):

function excel_to_array($excel_file) {
    $filename = dirname(dirname(__FILE__)) .'/admin/user_files/' . $excel_file['name'];
    $type = PHPExcel_IOFactory::identify($filename);
    $objReader = PHPExcel_IOFactory::createReader($type);
    $objPHPExcel = $objReader->load($filename);

    foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
        $worksheets[] = $worksheet->toArray();
    }

    var_dump($worksheets);
}

Result:

array (size=1)
    0 =>
        array (size=2)
            0 =>
                array (size=1)
                    0 => string '0894090592' (length=10)
            1 =>
                array (size=1)
                    0 => string '0894040404' (length=10)

There is too much nested arrays for such a simple excel, I'm lookig for something like this:

$worksheets = ['0894090592', '0894040404'];

Is there a way ?

P.S: I will NOT have multiple columns, but will have more rows, like these!

No!if you have multiple data on multiple rows and columns Which format is more easy to handle ? — hs-dev2 MR
– hs-dev2 MR, Commented Jul 9, 2019 at 9:12
Seems to be structured as worksheet-id row-id column-id. You will need to extract your data if you want it to look more simple. — Adder
– Adder, Commented Jul 9, 2019 at 9:15

Adder · Accepted Answer · 2019-07-09 09:22:04Z

1

Extracting the data:

function excel_to_array($excel_file) {
    $filename = dirname(dirname(__FILE__)) .'/admin/user_files/' . $excel_file['name'];
    $type = PHPExcel_IOFactory::identify($filename);
    $objReader = PHPExcel_IOFactory::createReader($type);
    $objPHPExcel = $objReader->load($filename);
    $worksheets = array();

    foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
        $worksheetArray= $worksheet->toArray();
        foreach($worksheetArray as $row) {
            if(isset($row[0])) {
                $worksheets[] = $row[0];
            }
        }
    }

    var_dump($worksheets);
}

answered Jul 9, 2019 at 9:22

Adder

5,8982 gold badges35 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andreas · Accepted Answer · 2019-07-09 09:44:08Z

1

You can use array_column to get only the values in [0].

function excel_to_array($excel_file) {
    $filename = dirname(dirname(__FILE__)) .'/admin/user_files/' . $excel_file['name'];
    $type = PHPExcel_IOFactory::identify($filename);
    $objReader = PHPExcel_IOFactory::createReader($type);
    $objPHPExcel = $objReader->load($filename);

    foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
        $worksheets[] = $worksheet->toArray();
    }

    // Here we get only the values to a flat array
    $worksheets = array_column($worksheets, 0);
    var_dump($worksheets);
}

answered Jul 9, 2019 at 9:44

Andreas

24k7 gold badges34 silver badges75 bronze badges

Collectives™ on Stack Overflow

Very simple excel file to php array returns me too many nested arrays?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related