How do i read attached excel file in client side with attach field type

ERPNext
, ,
1

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)
                                                 }
                                 })
                }
       })
}
2

@Sagar_Patil I am also facing this issue. I added a custom field attach to a doctype and in V13 the attachment would be accessible from the left panel but as of V14 the attachment no longer shows up there and the attach field becomes read-only.

3

Did you find any solution

4

@Sagar_Patil No I did not find any solution

5 
def read_xlsx_file_from_attached_file(file_url=None, fcontent=None, filepath=None):
	if file_url:
		_file = frappe.get_doc("File", {"file_url": file_url})
		filename = _file.get_full_path()
	elif fcontent:
		filename = BytesIO(fcontent)
	elif filepath:
		filename = filepath
	else:
		return

	rows = []
	wb1 = load_workbook(filename=filename, data_only=True)
	ws1 = wb1.active
	for row in ws1.iter_rows():
		rows.append([cell.value for cell in row])
	return rows