How do i use php read excel file

Using the PHPExcel library to read an Excel file and transfer the data into a database

//  Include PHPExcel_IOFactory
include 'PHPExcel/IOFactory.php';

$inputFileName = './sampleData/example1.xls';

//  Read your Excel workbook
try {
    $inputFileType = PHPExcel_IOFactory::identify($inputFileName);
    $objReader = PHPExcel_IOFactory::createReader($inputFileType);
    $objPHPExcel = $objReader->load($inputFileName);
} catch(Exception $e) {
    die('Error loading file "'.pathinfo($inputFileName,PATHINFO_BASENAME).'": '.$e->getMessage());
}

//  Get worksheet dimensions
$sheet = $objPHPExcel->getSheet(0); 
$highestRow = $sheet->getHighestRow(); 
$highestColumn = $sheet->getHighestColumn();

//  Loop through each row of the worksheet in turn
for ($row = 1; $row <= $highestRow; $row++){ 
    //  Read a row of data into an array
    $rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row,
                                    NULL,
                                    TRUE,
                                    FALSE);
    //  Insert row data array into your database of choice here
}

How do i use php read excel file

Mark Baker was extremely helpful in guiding me to the right answer. I don't use Composer with PHP (I should probably learn), but given that, in order to get this to work I went to the GitHub page for PHPExcel (https://github.com/PHPOffice/PHPExcel), clicked the green Clone and download button, and then the Download ZIP link.

After unzipping the file, I got a folder called PHPExcel-1.8. I moved that folder to the same folder as both the Excel file I wanted to read (in my code below test.xlsx) and the PHP file that has the code below.

The key to getting it to work was inputting the correct path to the IOFactory.php file. It may seem simple to some, but it was tripping me up.

Similar codes

-1 vote136 views1 answer
Php mysql row to json
PHP
0 vote154 views2 answers
Laravel migration table softdeletes
PHP Laravel
1 vote140 views1 answer
How to get current location in laravel
PHP
0 vote140 views2 answers
Laravel PackageManifest.php: Undefined index: name
PHP
4 votes182 views5 answers
Codeigniter 4 base_url
PHP
5 votes126 views2 answers
PDOException::("could not find driver") windows
PHP
11 votes139 views4 answers
Php append to file
PHP
0 vote173 views1 answer
Codeigniter db where between
PHP CodeIgniter
0 vote133 views1 answer
PHP Fatal error: Uncaught Error: Class 'IntlDateFormatter' not found in /var/www/html/magento/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:121
PHP
0 vote126 views1 answer
Put woocommerce orders on pending payment automatically
PHP