帮我用php写一个上传Excel的代码
时间: 2023-05-18 16:07:25 浏览: 51
好的,以下是一个简单的上传Excel文件的PHP代码:
<form action="upload.php" method="post" enctype="multipart/form-data">
<input type="file" name="excel_file">
<input type="submit" value="上传">
</form>
<?php
if(isset($_FILES['excel_file'])){
$file_name = $_FILES['excel_file']['name'];
$file_tmp = $_FILES['excel_file']['tmp_name'];
$file_type = $_FILES['excel_file']['type'];
$file_size = $_FILES['excel_file']['size'];
$file_ext = strtolower(end(explode('.',$_FILES['excel_file']['name'])));
$extensions = array("xls","xlsx");
if(in_array($file_ext,$extensions)=== false){
echo "只能上传Excel文件";
exit();
}
if($file_size > 2097152){
echo '文件大小不能超过2MB';
exit();
}
$upload_path = "uploads/";
$file_path = $upload_path . $file_name;
if(move_uploaded_file($file_tmp,$file_path)){
echo "文件上传成功";
}else{
echo "文件上传失败";
}
}
?>
请注意,这只是一个简单的上传Excel文件的示例代码,您需要根据您的实际需求进行修改和完善。