Hướng dẫn đọc file excel bằng lib – php thuần

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.13.5/xlsx.full.min.js"></script>
<script src="excel.js"></script>
<input type="file" id="file_upload">
<button id='getData'>Get Data</button><br>

$(document).ready(function(){
$('#getData').click(function(){
var selectedFile = $('#file_upload')[0].files[0];
var reader = new FileReader();
reader.onload = function(event) {
var data = event.target.result;
var workbook = XLSX.read(data, {
type: 'binary'
});
workbook.SheetNames.forEach(function(sheetName) {
var XL_row_object = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
var json_object = JSON.stringify(XL_row_object);
console.log(json_object);
$.ajax({
url: 'excel.php',
type: 'POST',
data: 'data_excel=' + json_object,
success:function(data) {
},
error: function (e) {
}
});
})
};
reader.onerror = function(event) {
console.error("File could not be read! Code " + event.target.error.code);
};
reader.readAsBinaryString(selectedFile);
});
});