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

8 votes91 views1 answer
Laravel link storage to public
PHP
5 votes108 views1 answer
Laravel like foreach
PHP Laravel
0 vote97 views1 answer
Laravel htaccess for aws ec2
PHP
0 vote118 views1 answer
Function fun($x, $y) { $x=4; $y=1; $z=($x+($y/$y)+$x) echo "$z"; } fun(3,2); output in php code
PHP
1 vote157 views1 answer
Laravel mongodb delete
PHP Laravel
0 vote93 views1 answer
Add auth middleware to route laravel
PHP
1 vote92 views1 answer
Php salto de linea
PHP
41 votes103 views3 answers
Php sizeof
PHP
0 vote95 views3 answers
Check if any values are the same in an array php
PHP
0 vote95 views1 answer
Get url segment in php
PHP