Menu

#613 Export multiple result tables names

SQuirreL
open
None
medium
2023-12-06
2023-08-10
Ginko
No

Good evening,
I would like to be able to store the workbook name and the name of the sheets at the level of the sql code with some suffix to be able to identify them. I saw that you can store it in a json file and recall it but when you have so many records it is difficult to find the right one. Mine is just an idea there are certainly other ways to solve this if you think it is important.
Best Regards,

Gino

1 Attachments

Discussion

  • Gerd Wagner

    Gerd Wagner - 2023-09-17

    Is committed to our GIT repository and will be available in future snapshots and versions.

    Excerpt from change log:

    SQL Script Plugin: In analogy to the existing syntax to export a SQL result directly using the syntax
    @file '/tmp/customers.xlsx' SELECT * FROM customers
    one may now directly create an MS-Excel workbook file with multiple sheets using the following syntax:
    @msExcelWorkbook 'C:/tmp/out.xlsx'
    @sheet 'Orders' SELECT * FROM orders;
    @sheet 'Stores' SELECT * FROM stores;
    where the ";" may need to be replaced by the SQL separator in use.

     
  • Ginko

    Ginko - 2023-12-06

    Thanks,
    very good job

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.