How is SQL Prompt helping your team? Share your experience.
Excel Export Issue
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"?>
<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>
2 · Share on Twitter