Excel Export Issue

Mark713

Good Morning,

This morning I updated to SQL Prompt version 10.12.6.30951. Now when I try to export to Excel the following message appears.

We found a problem with some content in 'Exported results 2022-10-27-07-49-10.xlsx'. Do you want us to recover as much as we can?  If you trust this source of this workbook, click Yes.

Excel was able to open the file by repairing or removing the unreadable content.

Repaired Part: /xl/worksheets/sheet1.xml part with XML error.  HRESULT 0x8000ffff Line 1, column 0.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error008600_02.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\...\AppData\Local\Temp\asahcp4c.mxi\Exported results 2022-10-27_07-49-10.xlsx'</summary>

<repairedParts><repairedPart>Repaired Part: /xl/worksheets/sheet1.xml part with XML error.  HRESULT 0x8000ffff Line 1, column 0.</repairedPart>

</repairedParts>

</recoveryLog>

Thank you.

Dan_J

Hi @Mark713

As per my previous message via the ticket we have logged for this, this is currently being looked at by our development team.

We will come back to you again as soon as we have an update for you on this.

plolis

do we have any news abou this? thank you

Dan_J

Hi @plolis

Thanks for reaching out about this.

This is still currently with our development team and unfortunately we don't yet know when this is likely to be fixed.

We will update you as soon as we have more information for you on this.