c# Pivot Table 操作

private
 Excel.Application m_objExcelApp;            



private
 Excel.Workbook m_objExcelWorkBook;            



private
 Excel.Worksheet m_objExcelWorkSheet;        





m_objExcelApp 
=
 
new
 Excel.Application();

m_objExcelApp.DisplayAlerts 
=
 
false
;



m_objExcelWorkBook 
=
 m_objExcelApp.Workbooks.Open(
"
你的Excel路径
"
, Type.Missing, 

                
true
,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,

                Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,

                Type.Missing,Type.Missing);



m_objExcelWorkSheet 
=
 (Excel.Worksheet)m_objExcelWorkBook.Sheets[
"
你的Sheet名
"
];



Excel.PivotCaches objPivot 
=
 m_objExcelWorkBook.PivotCaches();

            objPivot.Add(Excel.XlPivotTableSourceType.xlDatabase, 
"
a!R1C1:R102C20
"
).CreatePivotTable

                (
""
,
"
数据透视表1
"
,Type.Missing,Type.Missing);



            m_objExcelWorkBook.PivotTableWizard(Type.Missing, Type.Missing, m_objExcelWorkSheet.Cells[
3
, 
1
],

                Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,

                Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);



            Excel.Range objRange 
=
 (Excel.Range)m_objExcelWorkSheet.Cells[
3
, 
1
];

            objRange.Select();



            Excel.PivotTable objTable 
=
 (Excel.PivotTable)m_objExcelWorkSheet.PivotTables(
"
数据透视表1
"
);



            Excel.PivotField objField 
=
 (Excel.PivotField)objTable.PivotFields(
"
客户
"
);



            objField.Orientation
=
Excel.XlPivotFieldOrientation.xlRowField;

            objField.Position
=
"
1
"
;