I Can Export General Ledger transactions Data to CSV But Not to Excel

ERPNext
1

Hi All,

I was trying to export General Ledger transactions in an account to Excel and encountered the error below:

Traceback (most recent call last):
** File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 59, in application**
** response = frappe.handler.handle()**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 22, in handle**
** data = execute_cmd(cmd)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/handler.py”, line 61, in execute_cmd**
** return frappe.call(method, frappe.form_dict)
** File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1054, in call**
** return fn(args, newargs)
** File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 314, in export_query*
** xlsx_data = build_xlsx_data(columns, data, visible_idx, include_indentation)**
** File “/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py”, line 327, in build_xlsx_data**
** result[0].append(columns[idx][“label”])**
KeyError: u’label’

But when I tried CSV, it worked. I do not know what this means. Any ideas? Please?

2

Hi, @Sirjames I am experiencing something similar, were you able to fix your error?

3

Not yet.