8. Quick Excel & Excel 2007 Support (Revision #38)

When developers or business analysts are asked to generate reports for others in the enterprise, the most commonly requested format is the spreadsheet. The process of writing a query and then sending the desired results in an .xls or .xslx file requires using multiple applications and can be tedious. We've made it easier to get results to end-users in a format they can view with the View as Spreadsheet, Email Excel Attachment button and Excel 2007 support.

How do I quickly send a selection from query results as a spreadsheet?

Use the View as Spreadsheet and Email Excel Attachment button in the Grid Results view.

A button in the Grid Results toolbar allows you to either View as Spreadsheet, or Email as Excel Attachment (with email smtp settings entered in File-> Options-> Email) selected cells or rows in the grid.

What's New?

Configurable Excel Format

Excel 2007 is now available as an option in "Save Results As" or "View as Spreadsheet", and as a format for generating Pivot Grid and Pivot Grid Charts. Files can be saved as .xls or as .xlsx. Anywhere you can generate Excel results or use the View in Excel Viewer feature within the application you can now select which version of Excel (2003 or 2007) you would like for your output from within File -> Options - > General -> General -> Default Spreadsheet Format.

Save Results As Excel 2007	Query Results View as Spreadsheet	Excel Version Defaults Options

Excel interoperability is also equally supported in Aqua Open APIs.