Exporting to Excel file fails when one of the columns is a dictionary

[wloverine]

Issue Summary

get error when exporting query results to excel file:

environment:ec2 on ecs

Steps to Reproduce

1. create a new query
2. excute the query,save it ,then download it as excel file

Any other info e.g. Why do you consider this to be a bug? What did you expect to happen instead?

Technical details:

• Redash Version:6.0.0+b8537
• Browser/OS:chrome
• How did you install Redash:run redash by ecs on aws

[kyoshidajp]

Can you show the error log more detail? And can you download CSV successfully?

[wloverine]

Can you show the error log more detail? And can you download CSV successfully?

i can download csv successfully,but get error when downloading excel ,and i found that there is a field whose attribute is json.that maybe the cause,because I can export query without json attribute to excel successfully.
BTW,the data source is postgres.

[wloverine]

Can you show the error log more detail? And can you download CSV successfully?

�I see the similiar problem has benn sloved in issue #2060,is this the same problem?

[arikfr]

Indeed it looks like a similar issue.

[kyoshidajp]

@wloverine I have submitted #3323. How about converting the field to text as a workaround on your version.

cast(field as text)

[wloverine]

@kyoshidajp thanks !

[wloverine]

Indeed it looks like a similar issue.

will there be a new version of redash on docker hub incoming that fixs this problem? @arikfr

[arikfr]

Yes, it will be part of the next release.