How to get Excel data into an array in PHP local site?

Question

How to get Excel data into an array in PHP local site. I want to print data in Excel as array in my practice site. I have created Excel in htdocs as test.xlsx. How can I print it's data in PHP?

stackoverflow.com/questions/563670/reading-an-excel-file-in-php — Keith A
– Keith A, Commented Jun 30, 2015 at 7:16
First off, are you talking about a real xlsx file, created with MS Excel? Or simply a csv or html markup file with an extension of .xlsx? — Mark Baker
– Mark Baker, Commented Jun 30, 2015 at 7:27

Priye Ranjan · Accepted Answer · 2015-06-30 09:32:35Z

1

First include PhpExcel library into your code then use this

PHPExcel_IOFactory::addSearchLocation($filepath, $savedfilename);
        $objReader = PHPExcel_IOFactory::load($filepath);

        $data = array();
        $worksheet = $objReader->getActiveSheet();
        foreach ($worksheet->getRowIterator(2) as $row) {
            $cellIterator = $row->getCellIterator();
            $cellIterator->setIterateOnlyExistingCells(false);
            foreach ($cellIterator as $cell) {
                $data[$cell->getRow()][$cell->getColumn()] = $cell->getValue();
            }
        }
print_r($data);

answered Jun 30, 2015 at 9:32

Priye Ranjan

4424 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mark Baker Over a year ago

Or you could simply use the HTML Writer and save the output to php://output.... even fewer lines of code

Collectives™ on Stack Overflow

How to get Excel data into an array in PHP local site?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related