Phpexcel How to read Excel files? Phpexcel example of reading an XLS file

Error_reporting (E_all); Date_default_timezone_set (' Asia/shanghai '); /** Phpexcel_iofactory */ Require_once '. /classes/phpexcel/iofactory.php '; Check Prerequisites if (!file_exists ("31excel5.xls")) { Exit ("not found 31excel5.xls.\n"); } $reader = Phpexcel_iofactory::createreader (' Excel5 '); Set in EXCEL5 format (excel97-2003 workbook) $PHPExcel = $reader->load ("31excel5.xls"); Loading Excel files $sheet = $PHPExcel->getsheet (0); Read the first worksheet $highestRow = $sheet->gethighestrow (); Total number of rows obtained $highestColumm = $sheet->gethighestcolumn (); Total number of columns obtained $highestColumm = phpexcel_cell::columnindexfromstring ($colsNum); The letter column is converted to a number column such as: AA to 27 /** cycle through the data of each cell */ for ($row = 1; $row <= $highestRow; $row + +) {//lines start at line 1th for ($column = 0; $column < $highestColumm; $column + +) {//Number of columns starts with column NO. 0 $columnName = Phpexcel_cell::stringfromcolumnindex ($column); Echo $columnName. $row. ":". $sheet->getcellbycolumnandrow ($column, $row)->getvalue (). " "; } } ?> Copy Code Example 2, a simplified way to read an Excel file : Error_reporting (E_all); Date_default_timezone_set (' Asia/shanghai '); /** Phpexcel_iofactory */ Require_once '. /classes/phpexcel/iofactory.php '; Check Prerequisites if (!file_exists ("31excel5.xls")) { Exit ("not found 31excel5.xls.\n"); } $reader = Phpexcel_iofactory::createreader (' Excel5 '); Set in EXCEL5 format (excel97-2003 workbook) $PHPExcel = $reader->load ("31excel5.xls"); Loading Excel files $sheet = $PHPExcel->getsheet (0); Read the first worksheet $highestRow = $sheet->gethighestrow (); Total number of rows obtained $highestColumm = $sheet->gethighestcolumn (); Total number of columns obtained /** cycle through the data of each cell */ for ($row = 1; $row <= $highestRow; $row + +) {//lines start at line 1th for ($column = ' a '; $column <= $highestColumm; $column + +) {//The number of columns starts with column A $dataset [] = $sheet->getcell ($column. $row)->getvalue (); Echo $column. $row. ":". $sheet->getcell ($column. $row)->getvalue (). " "; } } ?> Copy Code

