1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| using MSExcel = Microsoft.Office.Interop.Excel;
/* .... */
var excel = new MSExcel.Application();
excel.Visible = true;
excel.DisplayAlerts = true;
var wb = excel.Workbooks.Open(@"C:\Documents and Settings\USERNAME\Bureau\TMP.xlsx",false);
var sheets = GetSheets(wb); // fonction perso pour mapper workbook.worksheets avec les indices "int" en dictionary avec les noms "string"
object[] sources = new object[2];
sources[0] = new object[2] { ((MSExcel.Range) sheets["Test"].Range["A1:C4"]).AddressLocal[true,true,MSExcel.XlReferenceStyle.xlR1C1,true] ,
"Test" };
sources[1] = new string[2] { ((MSExcel.Range) sheets["Test2"].Range["A1:C4"]).AddressLocal[true,true,MSExcel.XlReferenceStyle.xlR1C1,true] ,
"Test2" };
sheets["TCD"].Activate();
((MSExcel.Range) sheets["TCD"].Range["A3"]).Select();
wb.PivotTableWizard(MSExcel.XlPivotTableSourceType.xlConsolidation,sources,sheets["TCD"].Range["A3"]); |
Partager