How To Parse Response Table With Phpexcel Import Excel File To Input Tag (example : Autofill Input Id="fname" To Hello And Input Id="lname" To World)?
How to parse this response table with PHPExcel import Excel file into desired input fields (example : autofill input id='fname' to Hello and autofill input id='lname' to World)? I
Solution 1:
Good news : I have answer to parse response table with PHPExcel import Excel file to input tag (example : autofill input id=“fname” to Hello and input id=“lname” to World) with my full source code.
I have answer credit with link.
excelimport.xlsx(Excel file)
excelimport.php(PHP Code)
<!DOCTYPE html><html><head><metacharset="UTF-8"><title>Document</title><style>h2 {display: inline;}
</style></head><body><formaction=""method="post"enctype="multipart/form-data"name="myform1"id="myform1"><h2for="myfile1">Select files : </h2><inputtype="file"name="excelFile"id="excelFile" /><br><br><h2for="fname">First name : </h2><inputtype="text"id="fname"name="fname"><br><br><h2for="lname">Last name : </h2><inputtype="text"id="lname"name="lname"><br><br><inputtype="submit"name="btnSubmit"id="btnSubmit"value="Submit" /></form><scriptsrc="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script><scripttype="text/javascript">
$(function(){
// āđāļĄื่āļāļāļāļĢ์āļĄāļāļēāļĢāđāļĢีāļĒāļāđāļ้ evnet submit āļ้āļāļĄูāļĨ
$("#excelFile").on("change",function(e){
e.preventDefault(); // āļิāļāļāļēāļĢāđāļ้āļāļēāļ submit āļāļāļิ āđāļื่āļāđāļ้āļāļēāļāļ่āļēāļ ajax// āđāļāļĢีāļĒāļĄāļ้āļāļĄูāļĨ form āļŠāļģāļŦāļĢัāļāļŠ่āļāļ้āļ§āļĒ FormData Objectvar formData = newFormData($("#myform1")[0]);
// āļŠ่āļāļ่āļēāđāļāļ POST āđāļāļĒัāļāđāļāļĨ์ read_excel.php āļĢูāļāđāļāļ ajax āđāļāļāđāļ็āļĄ
$.ajax({
url: 'read_excel.php',
type: 'POST',
data: formData,
/*async: false,*/cache: false,
contentType: false,
processData: false
}).done(function(data){
console.log(data); // āļāļāļŠāļāļāđāļŠāļāļāļ่āļē āļูāļ่āļēāļāļŦāļ้āļē console/* āļāļēāļĢāđāļ้āļāļēāļ console log āđāļื่āļ debug javascript āđāļ chrome firefox āđāļĨāļ° ie
http://www.ninenik.com/content.php?arti_id=692 via @ninenik */
$("#fname").val(data.A2);
$("#lname").val(data.B2);
});
});
});
</script></body></html>read_excel.php(PHP Code)
<?php
header("Content-type:application/json; charset=UTF-8");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
/** Error reporting */
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Asia/Bangkok');
// http://php.net/manual/en/timezones.phprequire_once("PHPExcel/Classes/PHPExcel.php");
?><?phpif(isset($_FILES['excelFile']['name']) && $_FILES['excelFile']['name']!=""){
$tmpFile = $_FILES['excelFile']['tmp_name'];
$fileName = $_FILES['excelFile']['name']; // āđāļ็āļāļื่āļāđāļāļĨ์$_fileup = $_FILES['excelFile'];
$info = pathinfo($fileName);
$allow_file = array("csv","xls","xlsx");
/* print_r($info); // āļ้āļāļĄูāļĨāđāļāļĨ์
print_r($_fileup);*/if($fileName!="" && in_array($info['extension'],$allow_file)){
// āļ่āļēāļāđāļāļĨ์āļāļēāļ path temp āļั่āļ§āļāļĢāļēāļ§āļี่āđāļĢāļēāļัāļāđāļŦāļĨāļ$objPHPExcel = PHPExcel_IOFactory::load($tmpFile);
// āļึāļāļ้āļāļĄูāļĨāļāļāļāđāļ่āļĨāļ°āđāļāļĨāđāļāļāļēāļĢāļēāļāļĄāļēāđāļ§้āđāļ้āļāļēāļāđāļāļĢูāļāđāļāļāļัāļ§āđāļāļĢ array$cell_collection = $objPHPExcel->getActiveSheet()->getCellCollection();
// āļ§āļāļĨูāļāđāļŠāļāļāļ้āļāļĄูāļĨ$v=1;
$json_data = array();
foreach ($cell_collectionas$cell) {
// āļ่āļēāļŠāļģāļŦāļĢัāļāļูāļ§่āļēāđāļ็āļāļāļāļĨัāļĄāļ์āđāļŦāļ āđāļ่āļ A B C ....$column = $objPHPExcel->getActiveSheet()->getCell($cell)->getColumn();
// āļāļģāļŠāļģāļŦāļĢัāļāļูāļ§่āļēāđāļ็āļāđāļāļ§āļี่āđāļ่āļēāđāļŦāļĢ่ āđāļ่āļ 1 2 3 .....$row = $objPHPExcel->getActiveSheet()->getCell($cell)->getRow();
// āļ่āļēāļāļāļāļ้āļāļĄูāļĨāđāļāđāļāļĨāļĨ์āļั้āļāđ āđāļ่āļ A1 B1 C1 ....$data_value = $objPHPExcel->getActiveSheet()->getCell($cell)->getValue();
// āđāļ่āļēāļี้āđāļĢāļēāļ็āļŠāļēāļĄāļēāļĢāļāđāļŠāļāļāļ้āļāļĄูāļĨāļāļēāļāļāļēāļĢāļ่āļēāļāđāļāļĨ์āđāļ้āđāļĨ้āļ§ āđāļĨāļ°āļŠāļēāļĄāļēāļĢāļāļāļģāļ้āļāļĄูāļĨāđāļŦāļĨ่āļēāļี้// āļāļģāļāļēāļĢāļัāļāļัāļāļĨāļāļāļēāļāļ้āļāļĄูāļĨ āļŦāļĢืāļāđāļŠāļāļāđāļ้āđāļĨāļĒ$json_data["$column$row"] = $data_value;
// echo $v." ---- ".$data_value."<br>";$v++;
}
// āđāļāļĨāļ array āđāļ็āļāļĢูāļāđāļāļ json string if(isset($json_data)){
$json= json_encode($json_data);
if(isset($_GET['callback']) && $_GET['callback']!=""){
echo$_GET['callback']."(".$json.");";
}else{
echo$json;
}
}
}
}
?>I use PHPExcel library to download with link.
Post a Comment for "How To Parse Response Table With Phpexcel Import Excel File To Input Tag (example : Autofill Input Id="fname" To Hello And Input Id="lname" To World)?"