Yii:: Read Excel File xlsx Format

Php & Yii :: Read Excel File xlsx Format

The basic is from here http://www.yiiframework.com/extension/phpexcel-codeplex/

 

Installation

• Download from phpexcel-codeplex
• Extract the release file under protected/vendors

To read the excel xlsx format:

            Yii::import('application.vendors.PHPExcel',true);
            $objReader = PHPExcel_IOFactory::createReader('Excel2007');
            $objPHPExcel = $objReader->load($file); //$file --> your filepath and filename

            $objWorksheet = $objPHPExcel->getActiveSheet();
            $highestRow = $objWorksheet->getHighestRow(); // e.g. 10
            $highestColumn = $objWorksheet->getHighestColumn(); // e.g 'F'
            $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); // e.g. 5
            echo '<table>' . "\n";
            for ($row = 2; $row <= $highestRow; ++$row) {
              echo '<tr>' . "\n";
              for ($col = 0; $col <= $highestColumnIndex; ++$col) {
                echo '<td>' . $objWorksheet->getCellByColumnAndRow($col, $row)->getValue() . '</td>' . "\n";
              }
              echo '</tr>' . "\n";
            }
            echo '</table>' . "\n";

Advertisement