Bug #70887 export of file to excel spreadsheet converts it to .xml instead of .xls

• Submitted: 12 Nov 2013 10:52
• Modified: 19 Dec 2013 19:28
• Reporter: Kunal Kabra
• Status: Not a Bug
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.47,6.0.8
• OS: Any
• CPU Architecture: Any

[12 Nov 2013 10:52] Kunal Kabra

Description:
export of file to excel spreadsheet converts it to .xml instead of .xls

How to repeat:
export any data by clicking on the icon "export to a file" and choose excel spreadsheet from the dropdown menu

Suggested fix:
similar to Bug #64955 which was fixed for version 5.2.43

[12 Nov 2013 11:02] Kunal Kabra

I thought it should have been .xls and not .xml since you already have 2 more options that can export the file to .xml

Can we have something which converts the file to .xls

[12 Nov 2013 11:16] MySQL Verification Team

Hello Kunal,

Thank you for the bug report.
Indeed the export option wrongly exports Excel Spreadsheet as <filename.xml> instead of <filename.xls>.

Thanks,
Umesh

[19 Dec 2013 19:28] Alfredo Kojima

This is not a bug. The Excel format supported by Workbench is based on XML and supposedly, the extension has to be .xml. Excel should be able to open such file without problems. See bug #64955

[3 Nov 2014 10:29] MySQL Verification Team

http://bugs.mysql.com/bug.php?id=74667 marked as duplicate of this one.

[22 Dec 2014 17:10] MySQL Verification Team

http://bugs.mysql.com/bug.php?id=75290 marked as duplicate of this one.

[18 Sep 2017 11:41] MySQL Verification Team

https://bugs.mysql.com/bug.php?id=87792 marked as duplicate of this oen.

[8 Apr 2018 2:23] MySQL Verification Team

https://bugs.mysql.com/bug.php?id=90336 marked as duplicate of this one.