sgtpepper36
  • Posts: 1
  • Joined: 10/30/2019
When trying to export grid to excel with the Visualize as Excel, i get an excel error message about a mismatched extension and if i ignore the message it brings up excel with only one cell worth of data. I am using SSMSBOOST 3.7.7.7170.22760 and excel 2016. I would appreciate any help.

SSMSBoost
  • Posts: 284
  • Joined: 6/30/2012
"Visualize as " uses data of the SINGLE cell, that is exported to file and then opened in program, that you specify. It is your responsibility, that data in the cell has correct format.
Most common usage case: when files are stored in BINARY fields, you can export that file to disk and open with the associated problem (for example Sharepoint does this).

If you just want to export data to Excel from Grid you have 2 ways:
1. Use our Results Grid Scripter engine: Right-Click the Grid -> "Script Grid Data"->Script as XML Spreadsheet
2. Select all data in the Grid->Right Click->"Copy Selection as XML Spreadsheet(Excel)"
  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.