Creating a simple PivotTable

[Jerry Nixon]

Please,

In C# could you provide the basic steps (sample) to accomplish this? I have
a ListObject on Sheet1, called "ListObject1", range starting at cell B2. I
would like to create in Sheet2 (also at cell B2) a simple PivotTable, called
"PivotTable1" using the ListObject on Sheet1 as its data source.

Assuming the data is from the Orders table in Northwind, I would like the
initial column to be OrderDate, the initial Column(s) to be
EmployeeId+ShipRegion, and the initial measure to be Count of OrderID.

I have tried to figure this out using VSTO3 but there is insufficient
information on the internet to guide me through the steps. (I'm not that
smart.) Because I *can* do this in Excel, I am sure it is possible. Could you
provide a reference sample?

Thank you in advance for your reply,
Best regards,
Jerry Nixon

 

[Jerry Nixon]

Here's how:

(http://jerrytech.blogspot.com/2008/11/use-vsto-3-to-create-pivottable-in.html)

I hope this helps someone.
- Jerry