You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When downloading a table with long numbers with the excel options, these are truncated by replacing the last number with a 0. For example, 1100108628127863 would appear as 1100108628127860. This does not happen when exporting to CSV.
How to reproduce the bug
Create a table where a dimension is some large number (15-16 digits) and then download as excel.
Screenshots/recordings
This is an extract of the table in my dashboard
This is what it looks like in excel
Superset version
3.1.3
Python version
3.9
Node version
16
Browser
Chrome
Additional context
No response
Checklist
I have searched Superset docs and Slack and didn't find a solution to my problem.
I have searched the GitHub issue tracker and didn't find a similar bug report.
I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
The text was updated successfully, but these errors were encountered:
The issue with long numbers being truncated when exported to Excel from Superset is due to Excel's limitation of handling a maximum precision of 15 digits for numbers. This results in numbers longer than 15 digits being truncated or rounded. To prevent this, you can modify the df_to_excel function in Superset to convert long numbers to strings before exporting. This approach ensures that Excel treats these numbers as text, avoiding truncation or scientific notation conversion.
Here's a modification you can apply:
importiofromtypingimportAnyimportpandasaspddefdf_to_excel(df: pd.DataFrame, **kwargs: Any) ->Any:
output=io.BytesIO()
# Convert long numbers to strings to avoid truncationforcolumnindf.columns:
ifdf[column].dtype=='int64': # Check if the column is of int64 typedf[column] =df[column].astype(str)
# Handle timezonesforcolumnindf.select_dtypes(include=["datetimetz"]).columns:
df[column] =df[column].astype(str)
withpd.ExcelWriter(output, engine="xlsxwriter") aswriter:
df.to_excel(writer, **kwargs)
returnoutput.getvalue()
This code checks each column's data type and converts int64 columns to strings, ensuring that long numbers are accurately represented in the exported Excel file. Keep in mind, converting numbers to strings might not be ideal if you plan to perform numeric operations on these values in Excel, as they will be treated as text.
About Dosu
This response is meant to be useful and save you time. It is not meant to be a precise solution, but rather a starting point for your own research.
Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.
@jose-vines-toteat let us know if you want to open a PR to solve the problem. We'd love to get feedback on Dosu's suggestions here, since if it leads to a fix, that's pretty amazing.
Bug description
When downloading a table with long numbers with the excel options, these are truncated by replacing the last number with a 0. For example, 1100108628127863 would appear as 1100108628127860. This does not happen when exporting to CSV.
How to reproduce the bug
Create a table where a dimension is some large number (15-16 digits) and then download as excel.
Screenshots/recordings
This is an extract of the table in my dashboard
This is what it looks like in excel
Superset version
3.1.3
Python version
3.9
Node version
16
Browser
Chrome
Additional context
No response
Checklist
The text was updated successfully, but these errors were encountered: