php导入excel php使用phpexcel导入excel文件

3. //载入PHPExcel类

4. include(dirname(__FILE__).'/phpexcel/PHPExcel.php');

5. $Obj = new PHPExcel_Reader_Excel5();

6. $Obj->setReadDataOnly(true);

7. //读取demo.xls文件

8. $phpExcel = $Obj->load(dirname(__FILE__).'/output.xls');

9. //获取当前活动sheet

10. $objWorksheet = $phpExcel->getActiveSheet();

11. //获取行数

12. $highestRow = $objWorksheet->getHighestRow();

13. //获取列数

14. //by bbs.it-home.org
15. $highestColumn = $objWorksheet->getHighestColumn();
16. $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);

17. //循环输出数据

18. $data = array();
19. for($row = 1; $row for($col = 0; $col $val = $objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
20. $data[$row][$col] = trim($val);
21. }
22. }

23. echo '

    ';

24. print_r($data);
25. echo '';

复制代码