feat: Excel file export

[blcksrx]

SUMMARY

Support excel for exporting

BEFORE/AFTER SCREENSHOTS OR ANIMATED GIF

TEST PLAN

ADDITIONAL INFORMATION

• Has associated issue:
• Changes UI
• Requires DB Migration.
• Confirm DB Migration upgrade and downgrade tested.
• Introduces new feature or API
• Removes existing feature or API

[codecov-commenter]

Codecov Report

Merging #9924 into master will decrease coverage by 1.45%.
The diff coverage is 80.75%.

@@            Coverage Diff             @@
##           master    #9924      +/-   ##
==========================================
- Coverage   71.22%   69.77%   -1.46%     
==========================================
  Files         585      184     -401     
  Lines       30828    18257   -12571     
  Branches     3237        0    -3237     
==========================================
- Hits        21957    12738    -9219     
+ Misses       8762     5519    -3243     
+ Partials      109        0     -109     

Flag	Coverage Δ
#cypress	?
#javascript	?
#python	69.77% <80.75%> (-1.64%)	⬇️

Impacted Files	Coverage Δ
superset/charts/schemas.py	100.00% <ø> (ø)
superset/sql_validators/presto_db.py	82.89% <ø> (ø)
superset/views/base_schemas.py	0.00% <0.00%> (ø)
superset/viz_sip38.py	0.00% <0.00%> (ø)
...uperset/utils/dashboard_filter_scopes_converter.py	34.04% <22.22%> (ø)
superset/jinja_context.py	80.95% <43.75%> (-4.77%)	⬇️
superset/db_engine_specs/pinot.py	67.56% <57.14%> (+9.03%)	⬆️
superset/viz.py	56.99% <66.66%> (-14.99%)	⬇️
superset/utils/dict_import_export.py	55.81% <71.42%> (-0.60%)	⬇️
superset/charts/api.py	80.31% <73.68%> (-1.61%)	⬇️
... and 435 more

---

Continue to review full report at Codecov.

Legend - Click here to learn more
Δ = absolute <relative> (impact), ø = not affected, ? = missing data
Powered by Codecov. Last update 9edfc8f...a116941. Read the comment docs.

[blcksrx]

@villebro

[bkyryliuk]

just a general comment - it would be nice to fix CI first.

[bkyryliuk]

@blcksrx - could you share more about this feature use case and why .csv is not good enough? e.g. excel supports csv files as well as I know

[rusackas]

Pulling over a comment from a Slack discussion:

I would say it's worth embracing the growth of additional save/export options with a dropdown menu, e.g.:

+------------------------+
| Export Data To...  | ▼ |
+------------------------+
| Clipboard              |
| CSV                    |
| Excel                  |
| Parquet                |
| Google Sheet           |
+------------------------+

... to avoid button proliferation and add a spot for future integrations.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[opus-42]

Hello @bkyryliuk. I have provided additional context on why this may be useful
#11162.

Not every user may be CSV-friendly users. Excel Export are easier to handle for those users. For me, this is about Superset being more accessible to generic users.

This feature would be really helpful in production

[ninad-casebook]

One additional use-case for Excel over CSV is that datetime formats are not preserved in CSV. If the data being exported contains several datetime columns, then since CSV does not store date formatting this data is lost.

[arojoal]

I would like to know why finally this is not included into Superset. Here you can read a very good explanation of the importance of this feature for end users.
https://medium.com/geekculture/apache-superset-export-data-to-excel-38b8170a30ee

[blcksrx]

Actually Im frustrated about this, I made PRs two time about it, but after a while nobody did pay attention

[timnick-snow]

export-data-to-excel

[niyouzhu]

we need exporting as excel. it's common.

[lukoou3]

we need exporting as excel. it's common.

[Habeeb556]

++