Excel= directive in a comment section

[Duddha]

Very nice feature, thank you , but there is one problem:
-- Excel = file name gives me file named "file name.xls", but when I try something like -- Excel = file name %date% I'm getting file "file name 22.07.2013" (without .xls extension) and "Error opening document" message in PL/SQL Developer.
That's because of "." existence in file name. Any file names with points in them will get the same result.

 

[Marco Kalter]

I see. If the date format includes dots you will need to add the extension. For example:

-- Excel=filename_%date%.xls

We'll fix this for the next patch release.

 

[Duddha]

Can this feature be used for multitab queries?
"Copy all as xls..." creates tmp001.xls

 

[Marco Kalter]

No, this is currently not possible.