HTML上传excel文件，php解析逐条打印输出

最新推荐文章于 2024-07-26 16:07:01 发布

dreamboycs

最新推荐文章于 2024-07-26 16:07:01 发布

阅读量407

点赞数

分类专栏： html php

本文链接：https://blog.csdn.net/dreamboycs/article/details/104784392

版权

php 同时被 2 个专栏收录

42 篇文章 0 订阅

订阅专栏

html

6 篇文章 0 订阅

订阅专栏

HTML===demo

<!DOCTYPE html>
<html lang="zh">

   <head>
       <meta charset="UTF-8">
       <title>Title</title>
       <script src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-3.2.1.js"></script>
   </head>

   <body>
       <form action="http://gohosts.com/index.php" enctype="multipart/form-data" method="post">
           <input type="file" name="excel_file" class="input">
           <button class="btn btn-primary" type="submit">上传</button>
       </form>
   </body>

</html>

PHP===demo

<?php
header("Content-type: text/html; charset=utf-8");
require_once 'phpExcel/PHPExcel.php';
   $filePath = $_FILES ['excel_file'] ['tmp_name']; //[文件名][临时路径-写死的]
   $PHPReader = new PHPExcel_Reader_Excel2007();
   if(!$PHPReader->canRead($filePath)){
   $PHPReader = new PHPExcel_Reader_Excel5();
   if(!$PHPReader->canRead($filePath)){
   echo 'no Excel';
   return;
   }
   }
$PHPExcel = $PHPReader->load($filePath);
$currentSheet = $PHPExcel->getSheet(0); //读取第一张工作表
$allColumn = $currentSheet->getHighestColumn(); //取得最大的列号
$allRow = $currentSheet->getHighestRow(); //取得一共有多少行
for($currentRow = 1;$currentRow <= $allRow;$currentRow++){
   for($currentColumn='A';$currentColumn<= $allColumn; $currentColumn++){
$arr[$currentColumn] = (string)$currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65,$currentRow)->getValue();
}
       $val[]=$arr;
}
echo "<pre>";
print_r($val);