Home > Article > Backend Development > PHP implements uploading excel tables and obtaining data

PHP implements uploading excel tables and obtaining data

墨辰丷Original: 2018-05-23 14:34:306041browse

This article mainly introduces the knowledge related to php uploading excel tables and obtaining data. Has very good reference value. Let’s take a look at it with the editor

1: First is the html part

<html>
<body>
<form action="upload_file.php" method="post" enctype="multipart/form-data">
<input type="file" name="file" id="file" /> 
<input type="submit" name="submit" value="Submit" />
</form>
</body>
</html>

Two: Just to receive and process the uploaded files. PHP part

//文件存放的路径
$save_path = "/upload/";　

//文件存放的文件夹
$save_files = $this->geturl();

这个是以年月日新建的文件夹，仅供参考。

//先检查当前文件夹是否存在，如不存在，创建文件夹
function geturl()
{
$year = date(&#39;Y&#39;);
$month= date(&#39;m&#39;);
$day= date(&#39;d&#39;);

$str = $year.$month.$day;
if(strtoupper(substr(PHP_OS,0,3))==&#39;WIN&#39;){
$path = getcwd() . "/upload/".$str;
}else{
$path = "/mnt/erp/".$str;
}
if(!file_exists($path))//判断文件夹是否存在
{
mkdir($path);
}

//return $path."/";
return $str."/";
}

//这个是上传文件到需要保存的位置，
if (!@move_uploaded_file($_FILES[$upload_name]["tmp_name"], $save_path.$file_path)) {
$error = "error|上传文件错误.";
exit(0);
}

Now let’s get the excel data you uploaded

//获取上传表格的数据
$file_name = $save_path.$file_path; 　　　　　　　　　　 　　　　 　　 //获取上传文件的地址名称
require_once APPPATH . &#39;views/IDC/config/PHPExcel.php&#39;;　　　　 　　
require_once APPPATH . &#39;views/IDC/config/PHPExcel/IOFactory.php&#39;;
require_once APPPATH . &#39;views/IDC/config/PHPExcel/Cell.php&#39;;

$objReader = PHPExcel_IOFactory::createReader(&#39;excel2007&#39;); //建立reader对象

$objPHPExcel = $objReader->load($file_name);
$sheet = $objPHPExcel->getSheet();
$highestRow = $sheet->getHighestDataRow(); // 取得总行数

$highestColumn_num = PHPExcel_Cell::columnIndexFromString($sheet->getHighestDataColumn()); //列数

//$columns = PHPExcel_Cell::getColumn($highestColumn_num);
$columns = array(&#39;A&#39;,&#39;B&#39;,&#39;C&#39;,&#39;D&#39;,&#39;E&#39;,&#39;F&#39;,&#39;G&#39;);

$arr_result = array();
$dealer_element = array();

for ($j = 2; $j <= $highestRow; $j++) {
for ($k = 0; $k < count($columns); $k++) {
//读取单元格
$value = $objPHPExcel->getActiveSheet()->getCell($columns[$k] . $j)->getValue();//这个就是获取每个单元格的值

$value = trim($value);
if (empty($value)) {
$value = NULL;
}
$dealer_element[$k] = $value;
//这里可以根据要求，做一些数据的验证
}

$arr_result[$j] = $dealer_element;
}
echo json_encode($arr_result);

The above is the entire content of this article, I hope it will be helpful to everyone's study.

Related recommendations:

php simple method of copying files_php tips

php Simple method to upload images in batches_php skills

php data access query keywords_php skills

The above is the detailed content of PHP implements uploading excel tables and obtaining data. For more information, please follow other related articles on the PHP Chinese website!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：PHP implements the method of regular regular verification helper public classNext article：PHP implements the method of regular regular verification helper public class

See more

PHP implements uploading excel tables and obtaining data

Related articles