How to get value by column name in php spreadsheet-parser library?
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
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.fgetcsvfgetcsv — 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.
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']); }}