Recent changes to 613: Export multiple result tables names

#613 Export multiple result tables names

2023-12-06T11:34:15.572000Z

Thanks,
very good job

#613 Export multiple result tables names

2023-09-17T20:06:14.310000Z

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.

Export multiple result tables names

2023-08-10T14:22:01.177000Z

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