I'm using DbVisualizer 9.5.1
I used to use Aqua Data Studio. That program had a feature called "View as Spreadsheet". I so miss that feature. Here's an example of what it did.
First, user writes a query and returns a recordset into the grid.
Second, user clicks an icon on the grid toolbar "View as Spreadsheet".
Third, user is brought to a new Excel workbook with the grid (columns and rows) provided.
That's it! It's oh so simple but oh so nice. I realize users can export to a file but this is so handy when you want to do a little bit of analytics on some ad-hoc analysis. Often I don't need to save my results. I just want to check something out and Excel is a very powerful tool for that type of work. What Aqua did to marry their tool up with Excel was genius. I might urge you all to consider this functionality.
If you want the DbVisualizer's implementation to be even better than Aqua's I would urge the process makes two worksheets in the workbook. The first worksheet would be the grid results. The second worksheet would be the code used to generate the results. THAT WOULD BE AWESOME!!!!
Thanks for the suggestion. I will open a ticket.
Just to let you know DbVisualizer 10.0.2 has just been released with support for Open in Spreadsheet.
Easiest is that you open Help->Check for Update in DbVisualizer to perform the upgrade.
An alternative is to download from our web site:
Unbelievable! This is very exciting. Thank you very much for taking suggestions so seriously. I'll have to patiently wait (and encourage) my IT department to deploy it at my company but they'll get there eventually.
Again, thank you. I'm happy to be getting on board with software that is so receptive to change.
SCORE!!!! My company finally upgraded and I tested this feature. It's great! Even better than asked, you all included the source code in the XLSX export. This is absolutely wonderful. Thank you for listening to your customers and taking such decisive action. Ya'll are the best!