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

ivanpark777

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.

ivanpark777

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

Sarah B

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.

MrLivingroom

Decimal still exports to Excel as string... (SQL Prompt version 10.13.1.32087)

Roland_B

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"?>

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

<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.