dosubot[bot] commented on issue #27947: URL: https://github.com/apache/superset/issues/27947#issuecomment-2704701654
<!-- Answer --> The error 500 when exporting to Excel with a 'DATE' formatted column might be related to how Superset handles 'DATE' and 'DATETIME' formats differently. While I couldn't find specific details on the conversion process for these formats in the codebase, the error handling for 500 responses is managed by the `show_unexpected_exception` function in `superset/views/error_handling.py`. This function logs the exception and returns a JSON error response with a generic backend error message <sup>[[1]](https://github.com/apache/superset/blob/master/superset/views/error_handling.py)</sup>. Additionally, Superset uses the `pandas[excel]` and `xlsxwriter` libraries for exporting data to Excel <sup>[[2]](https://github.com/apache/superset/blob/master/pyproject.toml)</sup>. If there are any issues with these libraries handling 'DATE' formats, it might contribute to the error. To further investigate, you might want to check the Superset logs for any specific error messages related to the 'DATE' format during the export process. This could provide more insight into the root cause of the issue. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/e640307e-3818-4f24-899f-15bf570680c6?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/e640307e-3818-4f24-899f-15bf570680c6?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/e640307e-3818-4f24-899f-15bf570680c6?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/e640307e-3818-4f24-899f-15bf570680c6?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/e640307e-3818-4f24-899f-15bf570680c6?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/e640307e-3818-4f24-899f-15bf570680c6?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/e640307e-3818-4f24-899f-15bf570680c6?feedback_type=other)</sup> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
