Start a new topic

Worksheet name default when exporting to Excel?

[This topic is migrated from our old forums. The original author name has been removed]

When exporting to excel, is there a way to *control* the worksheet name - instead of the default "DbVisualizer Personal" it currently sets?

[This reply is migrated from our old forums.]

Re: Worksheet name default when exporting to Excel?
Andrew, http://www.dbvis.com/forum/thread.jspa?messageID=17142 Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Worksheet name default when exporting to Excel?
When exporting results manually, is there a way to set the default worksheet name to Sheet1 when creating a .xlsx file? This would be great. It is the default for Excel, and would be helpful for consistency's sake. Edited by: Andrew on Oct 15, 2013 11:06 PM
[This reply is migrated from our old forums. The original author name has been removed]

Re: Worksheet name default when exporting to Excel?// multiple worksheets?
The name of the sheets can wait... Nice feature Roger/all!
[This reply is migrated from our old forums.]

Re: Worksheet name default when exporting to Excel?// multiple worksheets?
Ricky, The @export feature can be used in combination with the "append" option. This means that each result set will appear as a separate sheet in the same Excel document. It is however not possible to express a unique sheet name for each of the result sets. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Worksheet name default when exporting to Excel?// multiple worksheets?
Thanks again Roger and all! While we're on the topic, is there any plan too - for exporting multiple resultsets to separate worksheets (say, something similar to @export)?
[This reply is migrated from our old forums.]

Re: Worksheet name default when exporting to Excel?
Ricky, The worksheet name can currently not be modified. It is set automatically to either a table name or DbVisualizer Personal (if table cannot be determined). I'll add it to the list. Regards Roger