Feature Request: Copy all to XLS (without opening)

[marchelo]

Hello,

I faced an issue. We have some environment where we can't install Office due to security policy (macros and VBA, bla-bla).
Copy all to XLS is great but I have to search tmp*.xls* in temporary directory each time. Is it possible to switch off automatic opening and save it to some other directory? Ideally I would like a save as... dialog so I can save Excel on to network share.

Thank you.

 

[Marco Kalter]

You can set the Excel output directory in the preferences (Tools > Preferences > Files / Directories).

You can also use the EXCEL= comment directive in the SQL script. You can use environment variables for the file name. For example:

-- Excel=C:\Excel\test_%date%.xls
select * from emp;

 

[marchelo]

Thanks a lot.

Code:
-- Excel=C:\Excel\test_%date%.xls

Doesn't work for saving all tabs (Copy all to xlsx).

Can you fix?

 

[Marco Kalter]

We'll check it out.