Export Query/SQL to Excel

[kabin01]

It would be great if there were an option to export the query/SQL to Excel as an additional sheet.
I am aware that the 'real source SQL' is not available in the data grid.

What about the following idea? An optional feature to add the content from the current query window as an additional sheet?
I am aware that a user could misuse this feature (run SQL in tab 1, switch to tab 2 and export the data grid with the SQL in tab 2).
However, if the user is aware and uses it correctly, the result is almost exactly what the user wants.

Regards, Robert

[alex-bochkov]

Hi Robert,

Thanks for the suggestion. Could you please try this build and let me know how it works? If you hold Shift while clicking “OK” in the folder-selection dialog, it will export either the selected query text or the entire tab content. I can add a new setting - "Always Export Query Text" - later.

Please use the latest version of SSMS 21 that was released a few days ago.

AxialSqlTools_SSMS21.zip

[kabin01]

Hi Alex,

SSMS21 can not start up extension:

The 'AxialSqlToolsPackage' package did not load correctly.

The problem may have been caused by a configuration change or by the installation of another extension. You can get more information by examining the file 'C:\Users\KABIN01\AppData\Roaming\Microsoft\SSMS\21.0_8424a45f\ActivityLog.xml'.

Continue to show this error message?

ActivityLog.xml as ActivityLog.log because GitHub doesn't support XML: ActivityLog.log

... CreateInstance failed for package [AxialSqlToolsPackage]Source: 'mscorlib'; Description: Could not load file or assembly ...

KR, Robert

[alex-bochkov]

Maybe the DLL got blocked? Open the properties of AxialSqlTools.dll, click "Unblock", then click OK on the first page.
This is the only issue I can think of right now.

[kabin01]

You are right, with "Rightclick - Properties - Unblock" the Extension is smoothly loading.

[alex-bochkov]

I’ve made a few updates to the logic:

• Added a new setting to control whether the source text is included by default.
• Holding Shift will now reverse the default behavior set by that setting.
• Shift must be held at the time the command is triggered for the override to apply.

[kabin01]

In general: Thank you for working on this!

1. Why "FolderBrowserDialog" and not "SaveFileDialog"?
2. a setting for "Default-Directory" would be nice
3. a setting for "Default-FileName" (including wildcard for datetime-elements) would be nice
4. Are there binaries (or a branch) for testing?
5. I would not call it "source query" in settings but "content of attached query-window"

I can not see excel-export-settings (yet?), I only refer to your screenshot.

KR, Robert

[alex-bochkov]

Robert, give this a shot please. I believe I got everything.
AxialSqlTools_SSMS21.zip

[alex-bochkov]

Could you please attach the Excel file itself maybe?
Here is the example that works for me:
Data.xlsx

[kabin01]

Hi Alex,
attached you find the excel-file: DataExport_20250604_081146.xlsx

I use this excel-version: Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18623.20266) 64-bit
KR, Robert

[alex-bochkov]

That helps. I suspect the issue is related to regional number format settings (comma vs. period). I'll try to reproduce it and fix it.

[alex-bochkov]

I believe this should help to fix the issue.
cac9749
AxialSqlTools_SSMS21.zip

[kabin01]

Yes, the error is gone, thank you!
Of course I can not tell for "any type" / "any format" / "any culture".

Btw: you have an empty catch / are missing a throw in

AxialSqlTools/AxialSqlTools/Modules/ExcelExport.cs

Line 275 in 857dcd2