Forum Discussion
Export to Excel is not working
Hi,
After the recent Azure Data Explorer Web UI update, the "Export to Excel" feature is no longer functioning as expected. While it works for simple tables but it takes longer time than before, it fails for tables containing complex data outputs, such as Empty, Null, Array [], or JSON data. Clicking the "Export to Excel" option does not produce the expected results.
Could you please investigate this issue and provide guidance on a resolution?
Thank you,
3 Replies
I agree, for example, datetime columns are exported as numerbs (ticks?) that Excel cannot convert to datetime
The null value issue appears to be resolved. However, when using JSON data as a dynamic type, it cannot be exported to Excel via the menu option, unless it's explicitly cast to a string using tostring(myDynamicJsonObject).
This workaround, however, results in the loss of the formatted JSON view in the UI, making it difficult to read, especially for large or complex JSON structures.The null value issue appears to be resolved. However, when using JSON data as a dynamic type, it cannot be exported to Excel via the menu option, unless it's explicitly cast to a string using tostring(myDynamicJsonObject).
This workaround, however, results in the loss of the formatted JSON view in the UI, making it difficult to read, especially for large or complex JSON structures.
