const requestFunc = async(url, method = "GET", data = null, token = null) => {
apihost = 'http://127.0.0.1/api'
method = method.toLocaleUpperCase()
let fullurl = `${apihost}${url}`;
let options = {
method: method,
headers: {
"Content-Type": "application/json",
"Authorization": `Bearer ${token}`,
},
};
switch(method) {
case "PUT":
delete options.headers["Content-Type"];
options.body = data;
break;
case "POST": case "PATCH": case "DELETE":
options.body = JSON.stringify(data);
break;
}
const res = await fetch(fullurl, options);
return await res.json();
};
var selectedFile;
document
.getElementById("fileUpload")
.addEventListener("click", function(event){
selectedFile = event.target.files[0];
});
document
.getElementById("uploadExcel")
.addEventListener("click", function(){
if (selectedFile) {
console.log("hi");
var fileReader = new FileReader();
fileReader.onload = function(event) {
var data = event.target.result;
var workbook = XLSX.read(data, {
type: "binary"
});
workbook.SheetNames.forEach(sheet => {
let rowObject = XLSX.utils.sheet_to_row_object_array(
workbook.Sheets[sheet]
);
var myHeaders = new Headers();
myHeaders.append("Content-Type", "application/json");
var raw = JSON.stringify(rowObject);
requestFunc(url="/studyplan/", method="POST", data=raw)
console.log(jsonObject);
// let jsonObject = JSON.stringify(rowObject);
// document.getElementById("jsonData").innerHTML = jsonObject;
// console.log(jsonObject);
});
};
fileReader.readAsBinaryString(selectedFile);
}
});
// //
// //
// //