Creating pivot table with C# in visual studio 2010

See more:

C#

Visual-Studio

MS-Excel

Hi everyone!

I'm trying to generate a Pivot Table from a Excel file using C# with Visual Studio 2010 without using Spire.xls. For example, my sheet 1 have the information and I want to create a Sheet2 with the pivot table. I have seen a lot of examples but I can't run anyone...

In what have I tried you can see my code ...

What could am I doing wrong? Is there some example to create a Pivot Table using an existing excel sheet?

Thank you in advance!

What I have tried:

This is my code:

//Usings
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Office.Interop.Excel;
using System.Globalization;

Workbooks libro = Excel.Workbooks;
Workbook libroActual = libro.Add();
Sheets sheets = libroActual.Worksheets;
Microsoft.Office.Interop.Excel._Worksheet Worksheet = libroActual.ActiveSheet; Worksheet.Name = "Desglose";

// Operations here with sheed 1

Worksheet sheetMMPP = sheets.Add();
sheetMMPP.Name = "MMPP";

//Range of the origin sheet
Microsoft.Office.Interop.Excel.Range oRange = Worksheet.UsedRange;
Microsoft.Office.Interop.Excel.Range oRange2 = sheetMMPP.Cells[1, 1]; 
Microsoft.Office.Interop.Excel.PivotCache oPivotCache = (Microsoft.Office.Interop.Excel.PivotCache)libroActual.PivotCaches().Add(Microsoft.Office.Interop.Excel.XlPivotTableSourceType.xlDatabase, oRange2);
Microsoft.Office.Interop.Excel.PivotCaches pch = libroActual.PivotCaches(); 
Microsoft.Office.Interop.Excel.PivotTable pvt = sheetMMPP.PivotTables("PivTbl_1") as Microsoft.Office.Interop.Excel.PivotTable;