use PhpOffice\PhpSpreadsheet\IOFactory; $inputFileName = 'myfile.csv'; // Create a reader instance $reader = IOFactory::createReader('Csv'); $reader->setDelimiter(','); $reader->setEnclosure('"'); $reader->setSheetIndex(0); // Load CSV into a worksheet object $spreadsheet = $reader->load($inputFileName); // Get row count $rowCount = $spreadsheet->getActiveSheet()->getHighestRow(); // Loop through rows for ($row = 1; $row <= $rowCount; $row++) { // Get cell values $name = $spreadsheet->getActiveSheet()->getCellByColumnAndRow(1, $row)->getValue(); $email = $spreadsheet->getActiveSheet()->getCellByColumnAndRow(2, $row)->getValue(); // Process data // ... }
use PhpOffice\PhpSpreadsheet\IOFactory; $inputFileName = 'myfile.xlsx'; // Create a reader instance $reader = IOFactory::createReader('Xlsx'); $reader->setSheetIndex(0); // Load Excel into a worksheet object $spreadsheet = $reader->load($inputFileName); // Get row count $rowCount = $spreadsheet->getActiveSheet()->getHighestRow(); // Loop through rows for ($row = 1; $row <= $rowCount; $row++) { // Get cell values $name = $spreadsheet->getActiveSheet()->getCellByColumnAndRow(1, $row)->getValue(); $email = $spreadsheet->getActiveSheet()->getCellByColumnAndRow(2, $row)->getValue(); // Process data // ... }In both examples, the package library used is PhpOffice\PhpSpreadsheet.