Error when trying to export report to Excel

Traceback (most recent call last):
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/”, line 62, in application
response = frappe.handler.handle()
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/”, line 22, in handle
data = execute_cmd(cmd)
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/”, line 53, in execute_cmd
return, **frappe.form_dict)
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/”, line 939, in call
return fn(*args, **newargs)
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/desk/”, line 169, in export_query
xlsx_file = make_xlsx(result, “Query Report”)
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/utils/”, line 40, in make_xlsx
File “/home//frappe/cvs/frappe-bench-cvs/env/local/lib/python2.7/site-packages/openpyxl/writer/”, line 241, in append
File “/home/frappe/cvs/frappe-bench-cvs/env/local/lib/python2.7/site-packages/openpyxl/writer/”, line 171, in _write_header
raise ValueError

I fixed it by myself refer this link if any of you guys have the same issue ValueError (writing xlsx) (pymongo) · Issue #99 · pyexcel/pyexcel · GitHub

1 Like