I have attach
field type for attach an excel file so How do I read data of attached file in client side i have done that with button
field type
load_shift_schedule(frm) {
new frappe.ui.FileUploader({
as_dataurl: true,
allow_multiple: false,
on_success(file) {
frappe.require('/assets/erpnext_addons/js/xlsx.core.min.js', () => {
var workbook = XLSX.read(file.dataurl.split("base64,")[1],{type:"base64"});
workbook.SheetNames.forEach(function(sheetName){
var data = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
console.log(data)
}
})
}
})
}