如下所示：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
<?phpdefine('BASE_URL', realpath(dirname(__FILE__)));//excel文件的地址$excel_fiel_path = './phpexcel.xls';$PHPExcel = new PHPExcel();// 实例化PHPExcel工具类//分析文件获取后缀判断是2007版本还是2003$extend = pathinfo("./" . $excel_fiel_path);$extend = strtolower($extend["extension"]); // 判断xlsx版本，如果是xlsx的就是2007版本的，否则就是2003if ($extend=="xlsx") { $PHPReader = new PHPExcel_Reader_Excel2007(); $PHPExcel = $PHPReader->load("./" . $excel_fiel_path);}else{ $PHPReader = new PHPExcel_Reader_Excel5(); $PHPExcel = $PHPReader->load("./" . $excel_fiel_path);} /* 第二种方法*/$objWorksheet = $PHPExcel->getActiveSheet();$highestRow = $objWorksheet->getHighestRow(); echo 'highestRow='.$highestRow;echo "<br>";$highestColumn = $objWorksheet->getHighestColumn();$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);//总列数echo 'highestColumnIndex='.$highestColumnIndex;echo "<br>";$headtitle=array(); for ($row = 2;$row <= $highestRow;$row++) { $strs=array(); //注意highestColumnIndex的列数索引从0开始 for ($col = 0;$col < $highestColumnIndex;$col++) { $strs[$col] =$objWorksheet->getCellByColumnAndRow($col, $row)->getValue(); } //todo //连接mysql ，一条条写入 } |
以上就是小编为大家带来的php通过PHPExcel导入Excel表格到MySQL数据库的简单实例全部内容了，希望大家多多支持服务器之家~
