How is SQL Prompt helping your team? Share your experience.

Open in Excel Numbers to String - please revert the change.

Open in Excel Numbers to String - please revert the change. 
This is bug and not a feature.
Money/decimal/int should be a number in excel and not string.
Tagged:

Answers

  • When exporting data to excel, I have to jump through loops to convert text to numbers. Please fix asap.
  • Hi @ivanpark777

    Thanks for your post.

    The latest release of SQL Prompt addresses the export to excel issue.

    You can take a look at the release notes and download the latest version here.
    Sarah Beckett| Customer Support| Redgate Software
    Have you visited our Help Center? 
  • MrLivingroomMrLivingroom Posts: 1 New member
    Decimal still exports to Excel as string... (SQL Prompt version 10.13.1.32087)
  • Roland_BRoland_B Posts: 1 New member
    Hello,
    I do have the same issue. Since Version 10.13. the decimal values do have an issue with the decimal separator. All are converted to comma although they are showing as point in SSMS.
    Excel Error Message is 
    We found some issues with the content.

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <logFileName>error180320_01.xml</logFileName>
    <summary>Fehler in Datei 'C:\Users\xxxxx\AppData\Local\Temp\p4ph41gw.tma\Exported results 2023-01-25_09-37-09.xlsx'</summary>
    <repairedRecords>
    <repairedRecord>Reparierte Datensätze: Zellinformationen von /xl/worksheets/sheet1.xml-Part</repairedRecord>
    </repairedRecords>
    </recoveryLog>

    I am using SQLPrompt version 10.13.4.32349 and SSMS v18.12.1
    Please go back to the 10.12. functionallity with this and don't try to adopt to language specific notations.
Sign In or Register to comment.