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

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

2 votes150 views1 answer
Var_dump not showing all
PHP
0 vote166 views1 answer
Laravel blade get array count in Blade
PHP
0 vote160 views3 answers
Script @php artisan package:discover handling the post-autoload-dump event returned with error code 255
PHP
0 vote192 views2 answers
Laravel roles and permissions
PHP Laravel
0 vote160 views1 answer
Iterate over assets container statamic
PHP
1 vote148 views1 answer
Check if string is base64 php
PHP
1 vote209 views1 answer
How to display user id from a function on a wordpress page
PHP Wordpress
2 votes185 views4 answers
Laravel where in array
PHP
4 votes211 views4 answers
How to connect to a database in php
PHP
0 vote186 views1 answer
Laravel collection forPage
PHP Laravel