Creating a PivotTable Programmatically

home
database
view story

3 Kicks

Creating a PivotTable Programmatically (blogs.msdn.com)

submitted by wisemx(8074) 3 years, 10 months ago

I received an email from a customer the other day asking how to set up an Excel pivot table programmatically. The Excel OM exposes a number of objects and methods that you can use to create pivot tables, some more sophisticated than others. I wanted the simplest possible way to set up a pivot table from an external data source, and this is what I ended up with... I used the AdventureWorks SQL database, which you can download from here. In my solution, I first set up a data connection to the database, with a SQL select statement to fetch all the SalesPerson sales records:

add a comment |category: Database |Views: 158
Tweet