c# code to copy paste whole pivot table in another sheet

Mar 20 2014 6:44 AM

Hi, I have a pivot table in excel sheet 1. I need to write a C# code to copy and paste whole pivot table in sheet 2 of same excel file. While copying, I need to expand all columns data also. Please help me in doing this. Thanks