Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pch.Add(Microsoft.Office.Interop.Excel.XlPivotTableSourceType.xlDatabase, range).CreatePivotTable(sheetPivot.Cells[pivotRow, 1], "PivTbl_1", Type.Missing, Type.Missing);
- Microsoft.Office.Interop.Excel.PivotTable pvt = sheetPivot.PivotTables("PivTbl_1") as Microsoft.Office.Interop.Excel.PivotTable;
- var ptStyle = workBook.TableStyles["PivotStyleMedium2"];
- pvt.ShowTableStyleColumnHeaders = true;
- pvt.ShowTableStyleColumnStripes = true;
- pvt.ShowTableStyleLastColumn = true;
- pvt.ShowTableStyleRowHeaders = true;
- pvt.ShowTableStyleRowStripes = true;
- pvt.TableStyle = ptStyle.Name;
- pvt.TableStyle2 = ptStyle;
- foreach (var item in provider.RowGroupDescriptions)
- {
- var field = ((Microsoft.Office.Interop.Excel.PivotField)pvt.PivotFields(item.PropertyName));
- field.Orientation = Microsoft.Office.Interop.Excel.XlPivotFieldOrientation.xlRowField;
- }
- foreach (var item in provider.ColumnGroupDescriptions)
- {
- var field = ((Microsoft.Office.Interop.Excel.PivotField)pvt.PivotFields(item.PropertyName));
- field.Orientation = Microsoft.Office.Interop.Excel.XlPivotFieldOrientation.xlColumnField;
- }
- foreach (var item in provider.AggregateDescriptions)
- {
- var field = ((Microsoft.Office.Interop.Excel.PivotField)pvt.PivotFields((item as PropertyAggregateDescription).PropertyName));
- field.Orientation = Microsoft.Office.Interop.Excel.XlPivotFieldOrientation.xlDataField;
- field.Function = Microsoft.Office.Interop.Excel.XlConsolidationFunction.xlSum;
- }
- foreach (var item in provider.FilterDescriptions)
- {
- var field = ((Microsoft.Office.Interop.Excel.PivotField)pvt.PivotFields(item.PropertyName));
- field.Orientation = Microsoft.Office.Interop.Excel.XlPivotFieldOrientation.xlPageField;
- var items = (item.Condition as Telerik.Pivot.Core.Filtering.ItemsFilterCondition).DistinctCondition.Items;
- pvt.RefreshTable();
- Microsoft.Office.Interop.Excel.PivotItems _PivotItems = (Microsoft.Office.Interop.Excel.PivotItems)field.PivotItems();
- foreach (Microsoft.Office.Interop.Excel.PivotItem _PivotItem in _PivotItems)
- {
- if (items.Contains(_PivotItem.Caption))
- _PivotItem.Visible = true;
- else
- _PivotItem.Visible = false;
- }
- }
- sheetPivot.PivotTables("PivTbl_1").DataPivotField.Orientation = Microsoft.Office.Interop.Excel.XlPivotFieldOrientation.xlColumnField;
- sheetPivot.Columns.AutoFit();
- sheetPivot.Activate();
- workBook.SaveAs(FileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
- workBook.Close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement