1 <?php 2 header("Content-Type:text/html;charset=utf-8"); 3 include_once 'PHPExcel.php'; 4 include_once 'PHPExcel/IOFactory.php'; 5 6 set_time_limit(600); 7 //文件的目录 8 $dir = './files/'; 9 $array = scandir($dir);//列出指定路径中的文件和目录 10 $count = 3832; 11 $p = $_GET['p']; 12 if($p <= 1) { 13 $p = 1; 14 } 15 $countP = $p + 5; 16 $countP = $countP > $count ? $count : $countP; 17 18 for($i = $p; $i<$countP; $i++) { 19 $reader = PHPExcel_IOFactory::createReader('Excel5'); 20 // $resource = $dir . '3815.xls'; 21 $resource = $dir . $i . '.xls'; 22 //echo $resource; 23 $PHPExcel = $reader->load($resource); // 文件名称 24 $sheet = $PHPExcel->getSheetByName('低压线路');//文件下的一个sheet表 25 $highestRow = $sheet->getHighestRow(); // 取得总行数 26 //echo $highestRow.'<br>'; 27 //连接数据库 28 $dsn = "mysql:host=localhost;dbname=data_info"; 29 $username = "root"; 30 $passwd = ""; 31 $pdo = new PDO($dsn, $username, $passwd); 32 $pdo->query("SET NAMES utf8"); 33 34 for ($j = 4; $j <= $highestRow; $j++) { 35 //取出数据 36 //getCellByColumnAndRow(参数1,参数2)->getValue(); ————获取某行某列的数据值 37 //其中： 参数1：列的位置 参数2: 行的位置 38 $name = $sheet->getCellByColumnAndRow(3, $j)->getValue(); 39 $id = $sheet->getCellByColumnAndRow(7, $j)->getValue(); 40 $byq = $sheet->getCellByColumnAndRow(8, $j)->getValue(); 41 $bz = $sheet->getCellByColumnAndRow(11, $j)->getValue(); 42 $time = $sheet->getCellByColumnAndRow(13, $j)->getValue(); 43 if ($name) { 44 $sql = "insert into low_line_copy(circuit_name, trans_id, trans_name, maintain_group, `time`) values 45 ('" . $name . "','" . $id . "','" . $byq . "','" . $bz . "','" . $time . "'); \n"; 46 echo $sql . '<br>'; 47 //指定数据存到文件中 48 file_put_contents('./a.txt', $i . ',' . $sql . "\r\n", FILE_APPEND); 49 } 50 //$pdo->exec($sql); 51 } 52 unset($reader); 53 } 54 ?> 55 <script> 56 //每页执行5条，之后跳转 57 location.href = "1.php?p=<?=($i);?>"; 58 </script>