Custom tab name for Excel export

I've recently figured out how to export multiple result sets to a single Excel file as separate tabs (very handy!). Please consider adding the ability to supply a name for the spreadsheet tab, both in the Export dialog and as an "@Export set" parameter ("ExcelTabName" perhaps).

In the new DbVisualizer 9.2 it's possible to change the name of a resultset with the new client-side command: *@set resultset name <name>* ... but this is not retained when exporting to an Excel spreadsheet. Could the custom resultset names be used for exported spreadsheet tab labels rather than introducing another client-side command?

I noticed that this was added in today's 9.2.1 update and just had to try it out straightaway. Works great! Love it !!!!

Hi Steve, The new feature for resultset name seem not consistent with the other @export options. Consider the following sample: @export on; @export set Filename="Report.xls" Format="XLS" AppendFile="True" ExcelFileFormat="ooxml"; @export set ExcelTitle="Sample Output"; {color:#0000FF} @set resultset name Sample Report 1 ;{color} select now() TODAY; {color:#FF0000} @set resultset name "Sample Report 2";{color} select now() TODAY; @export off; The first generates a sheet called "Sample Report 1" - whilst the second generates a sheet called " "Sample Report 2"" (including the double quotes ). Looking at the rest of the @export options, the second one seem more "consistent" in terms of using quoted paramaters. Any thoughts on this? BTW, is this feature meant to replace the current "@export set TableName" feature when exporting to named sheets? Thanks again to the dev teams and keep up the good work! Regards, Ricky Edited by: Ricky Banaag on Mar 11, 2015 9:27 AM Edited by: Ricky Banaag on Mar 11, 2015 9:27 AM