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

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

  ivanpark777 October 18, 2022 16:45

  - 0 +
• 
  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 B October 20, 2022 19:24

  - 0 +
• 
  Decimal still exports to Excel as string... (SQL Prompt version 10.13.1.32087)

  MrLivingroom January 09, 2023 13:44

  - 0 +
• 
  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.

  Roland_B January 25, 2023 08:45

  - 0 +

Add comment

Please sign in to leave a comment.