How to get value by column name in php spreadsheet-parser library?

Question

I'm using akeneo-labs spreadsheet-parser library to extract data from xlsx file.

use Akeneo\Component\SpreadsheetParser\SpreadsheetParser;

$workbook = SpreadsheetParser::open('myfile.xlsx');

$myWorksheetIndex = $workbook->getWorksheetIndex('myworksheet');

foreach ($workbook->createRowIterator($myWorksheetIndex) as $rowIndex => $values) {
    var_dump($rowIndex, $values);
}

Actually, you can get value by column index in a loop, is it possible to get value by column name instead?

Try [phpExcel](https://github.com/PHPOffice/PHPExcel) its the bee's neez — RiggsFolly, Feb 15 '17 at 12:37
Use [PhpSpreadsheet](https://github.com/PHPOffice/PhpSpreadsheet), the successor of PHPExcel instead. — fabrik, Sep 13 '18 at 07:54
phpExcel is deprecated since 2017 and permanently archived since 2019. Avoid using it — noxter, Feb 08 '22 at 07:47

score 0 · Answer 1 · answered Jun 12 '19 at 10:14

0

maybe using another package as suggested fixes your problem. also you can use array_column https://www.php.net/manual/en/function.array-column.php

answered Jun 12 '19 at 10:14

Moaaz

21
2

score 0 · Answer 2 · edited Jun 23 '21 at 23:10

0

Maybe you can do that in a spreadsheet CSV file by using PHP default function fgetcsv(), you can go throw an overview from here: https://www.php.net/manual/en/function.fgetcsv fgetcsv — Gets line from file pointer and parse for CSV fields

First of all, save as your Xls file in CSV type then you can take your value from that CSV file by column name.

edited Jun 23 '21 at 23:10

Nayana Chandran

1,416
1
16
30

answered Jun 22 '21 at 15:53

Ahm Harunur Rashid

1
2

score 0 · Answer 3 · answered Sep 28 '21 at 06:28

You can try this.

use Akeneo\Component\SpreadsheetParser\SpreadsheetParser;

$workbook = SpreadsheetParser::open('myfile.xlsx');

$myWorksheetIndex = $workbook->getWorksheetIndex('myworksheet');
// all columns
$columns = [];

foreach ($workbook->createRowIterator($myWorksheetIndex) as $rowIndex => $values) {
    if ($rowIndex == 1) {
        $columns = $values;
    } else {
        $datum = array_combine($columns, $values);
        // get value by column name
        var_dump($datum['name']);
    }
}

How to get value by column name in php spreadsheet-parser library?

3 Answers3