ExcelTemplate can be uses with Microsoft Analysis Services to create fully functional excel reports with advanced features such as Pivot Tables and Pivot Charts.

Technical Overview

This example establishes a connection to an Analysis Services database and performs a Multidimensional eXpression Language (MDX) query. Once we have an AdomdDataReader object we can pass it to the SetDataSource method of the ExcelTemplate object, this will populate any data markers that you have defined in your template file. The template for this sample contains data markers and also a Pivot Table bound to those markers. When the data is retreived the Pivot Table references will be updated.

View the template to see where the various data markers are placed and how the Pivot Table references them. Then, run the demo to generate a workbook filled with the results of our MDX query.

Click to run demo

Copyright 2005 © SoftArtisans, Inc. All Rights Reserved.