<?php

require '/vendor/autoload.php'; // Include PhpSpreadsheet library

use PhpOffice\PhpSpreadsheet\IOFactory;

$xlsxFile = 'local.xlsx'; // path to XLSX file

$targetRowNumber = 302; // row number to access

$targetColumn = 3; // column number (C = 3)

try {

    $trystarttime = microtime(true);

    // Load the XLSX file

    $spreadsheet = IOFactory::load($xlsxFile);

    // Get the value of the specified cell (column 2, row 301)

    $value = $spreadsheet->getActiveSheet()->getCellByColumnAndRow($targetColumn, $targetRowNumber)->getValue();

    echo "Value in column $targetColumn, row $targetRowNumber: " . $value . "\n";

    $tryendtime = microtime(true);

    $durationInMilliseconds = (number_format(($tryendtime - $trystarttime) * 1000, 2)) . "ms to fetch the required row value" . PHP_EOL;

    echo $durationInMilliseconds;

} catch (Exception $e) {

    echo "Error: " . $e->getMessage() . "\n";

    echo "Trace: " . $e->getTraceAsString() . "\n";

}

?>

$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();

$spreadsheet = $reader->load($inputFileName);