Error when trying to export report to Excel

Traceback (most recent call last):
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/app.py”, line 62, in application
response = frappe.handler.handle()
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/handler.py”, line 22, in handle
data = execute_cmd(cmd)
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/handler.py”, line 53, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/init.py”, line 939, in call
return fn(*args, **newargs)
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/desk/query_report.py”, line 169, in export_query
xlsx_file = make_xlsx(result, “Query Report”)
File “/home/frappe/cvs/frappe-bench-cvs/apps/frappe/frappe/utils/xlsxutils.py”, line 40, in make_xlsx
ws.append(clean_row)
File “/home//frappe/cvs/frappe-bench-cvs/env/local/lib/python2.7/site-packages/openpyxl/writer/write_only.py”, line 241, in append
self.writer.send(row)
File “/home/frappe/cvs/frappe-bench-cvs/env/local/lib/python2.7/site-packages/openpyxl/writer/write_only.py”, line 171, in _write_header
raise ValueError
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