PHP

php excel to array

// I recommand using
// https://github.com/PHPOffice/PhpSpreadsheet

$reader = new PhpOfficePhpSpreadsheetReaderXls();
// reader = new PhpOfficePhpSpreadsheetReaderXlsx();
$reader->setReadDataOnly(true);
$spreadsheet = $reader->load($inputFileName);

// Get the value from cell B5
$cellValue = $spreadsheet->getActiveSheet()->getCellByColumnAndRow(2, 5)->getValue();