Bug #97761 export qery result into Excel spreadsheet produce incorrect file
Submitted: 24 Nov 2019 20:48 Modified: 26 Nov 2019 5:41
Reporter: Denys Dudko Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.16 OS:Any
Assigned to: CPU Architecture:Any
Tags: Excel spreadsheet, export, workbench

[24 Nov 2019 20:48] Denys Dudko 
Description:
Excel can't open exported file - report error. See example
It's happen if data contains character '<' inside (not in the end field)

How to repeat:
run query 
select '</' Field
export data into format Excel spreadsheet

try to open in excel

Suggested fix:
replace character '<' by '&lt;' ; character '>' by '&gt;' and character '&' by '&amp;'
[25 Nov 2019 9:09] Denys Dudko 
Also found small problem in the export into excel spreadsheet
When we exporting decimal field with null values - in excel it opens as '0'. To avoid this in the xml file, for fields with NULL value,  should be written
    <Cell><Data ss:Type="String"></Data></Cell>
instead 
    <Cell><Data ss:Type="Number"></Data></Cell>
[26 Nov 2019 5:41] MySQL Verification Team 
Hello Denys Dudko,

Thank you for the bug report.
IMHO this is duplicate of bug #96420. Please see the bug #96420.

Regards,
Ashwini Patil