Craete simple PivotTable with ListObject as DataSource

[Jerry Nixon]

Could you provide a sample in C# to create a PivotTable on Sheet2 using a
ListObject on Sheet1 as the DataSource? The initial Column should be
OrderDate, rows should be ShippingRegion, measure should be count of ID.

I'm having trouble figure this out for VSTO3/Excel 2007.

Best regards,
Jerry

 

[Jerry Nixon]

I apologize for the double post and the typo in the Title.

 

[Jerry Nixon]

Reference to other thread
(http://www.microsoft.com/communitie...ef-80cd-bbf4d13f8556&cat=&lang=&cr=&sloc=&p=1)