Export Multi Sheet

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 

VDM's export multi sheet feature allows you to export a detail grid, summary grid, pivot and chart into a single Excel spreadsheet. Additionally you no longer need to have Excel installed to export to an Excel file.

 

Note: If a view does not have a summary, pivot or chart, the sheet in Excel will be blank.

 

Steps to Export Multi Sheet

 

1. Open and run the view you would like to export. If you do not run the view before exporting, the excel sheet will be empty.

 

2. Click on the Export/Print ribbon bar.

mceclip0.png

 

3. Click on the Export Multi Sheet button located in the (No Preview) section of the ribbon bar.

mceclip1.png

 

4. Save the multi sheet excel file.

mceclip2.png

 

5. Select which items to export then click Okay.

mceclip3.png

 

Optional: The order of the items being exported can be changed by dragging them up or down.

mceclip0.png

 

 

Example Multi Sheet Export

 

Detail Grid

mceclip4.png

 

Summary Grid

mceclip5.png

 

Chart

mceclip6.png

Have more questions? Submit a request

Comments