/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

0 vote149 views1 answer
Get array key based on value php
PHP
7 votes154 views3 answers
Laravel active menu item
PHP
3 votes189 views2 answers
How to use required_with in laravel to array element
PHP Laravel
37 votes161 views4 answers
How to generate unique alphanumeric 6 digit code through php myadmin
PHP
2 votes173 views4 answers
Laravel redirect action
PHP Laravel
0 vote182 views1 answer
Composer create-project --prefer-dist laravel/laravel blog
PHP Laravel
0 vote167 views1 answer
Php pdo random multiple insert query
PHP
1 vote171 views4 answers
Get month name php
PHP
5 votes142 views2 answers
Memory limit wordpress
PHP
0 vote155 views1 answer
Import separate graphql file laravel
PHP