#609 Export multiple Result tables to one XLSX file into separated Sheets

[Stepan RYBAR]

Good afternoon,

may I ask You for enhancement regarding Export Excel XLSX ?

I would like to have the possibility to export all (or better selected - checkbox?) opened Result tables into one XLSX file in such a way, that each Result table will be exported into separated Excel Sheet within one WorkBook (XLSX file).

It would save a lot of time consuming manual work.

Thank You in advance, Stepan

[Gerd Wagner]

Is committed to our GIT repository. A snapshot with the feature is available here
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20221114_2150/
or here
https://github.com/squirrel-sql-client/squirrel-sql-snapshot-releases/releases/tag/snapshot-20221114_2150

Excerpt from change log:

Export of multiple SQL results.
When exporting to MS Excel, multiple data sheets/tabs in the same file are created.
When exporting to other formats, multiple files are created.
The export dialog allows to name sheets/tabs or files respectively.
Howto:
To export multiple SQL results right click or open tools popup (ctl+t)
on multiple SQL queries (separated by statement separators) to open the file export dialog.
To export multiple SQL result UI tables execute multiple SQLs (ctrl+enter).
Then right click one of the UI result tables to open the file export dialog.

[Stepan RYBAR]

I think that this feature is already implemented in 4.8.0, so one can close this RFE now. Thank You, Gert, very much! Stepan

[Gerd Wagner]

Closed on user request.