Control the Excel Presentation

Once you present your data in Excel, DAS displays the Control Presentation menu option on the Quick menu above the grid. You can use this menu to control how DAS presents your data in Excel. To access these options, click on the Control Presentation menu:

To	Do this
Adjust the Excel width automatically after each query	Check the Best fit after query button. Uncheck this button to keep Excel column widths intact.
Best fit the current visible sheet now	Click Best fit sheet.
Auto fit the sheet width to the width of the printer	Check the Auto-fit to printer. Note: If you want to add page breaks to your presentation, make sure to uncheck Auto-fit to printer!
Hide/show spacer rows used in Manual Presentation groups	Check the Filter sheet to hide the spacer rows (as defined by the Presentation > Advanced edit > Map group values To Excel > Row padding). Uncheck to show the spacer rows. Note: Show the spacer rows if you want to apply Excel Format Cells.
Format the cells of Manual Presentation	Uncheck the Filter sheet button, to make all spacer rows visible. Select the cells and spacer cells and apply the desired Excel Cell Formatting to the cells (E.g. numeric format, bolding, etc.). Re-check the Filter sheet button when you are done to once again hide spacer rows.
Show a "clean" look for your report	Click Report look.
Show a "spreadsheet" look so you can edit your report	Click Spreadsheet look.
Hide/show excel menus	Click Toggle menus.
Hide/show grid column and row headings	Click Toggle headings.
Hide/show grid lines	Click Toggle gridlines.
Hide/show worksheet tabs	Click Toggle worksheet tabs.
Hide/show status bar	Click Toggle status bar.
Wipe out the visible sheet (i.e. start with a "clean slate")	Click Clear active sheet.
Present visible grid columns in Excel	Click Map visible columns to Excel. Once you click, DAS will present the dialog to present columns in Excel Add Charts and Advanced Formatting.
Manually edit and refine previous mappings	Click Advance Edit. With this option, you can append new maps at the end. Use this option if it is important to maintain the order and columns of a previous mapping. You may also add additional mapping such as Report Parameter mapping with this editor.
Remove the Excel Presentation	Click Un-embed Excel. DAS will remove the Excel presentation and show the grid showing your query data.