PivotCache.SourceCellArea

PivotCache.SourceCellArea property

Returns the range of the data source using with SourceSheet.

public WebCellArea SourceCellArea { get; }

Examples


 [C#]

 //Changes data source range
 //Original value: StartRow=0;StartColumn=0;EndRow=10;EndColumn=4;
 PivotTable table = GridWeb1.WebWorksheets.PivotTables["myPivotTable"];
 //Adds 2 row data
 table.PivotCache.SourceCellArea.EndRow = 12;

 [VB]

 'Changes data source range
 'Original value: StartRow=0;StartColumn=0;EndRow=10;EndColumn=4;
 Dim table As PivotTable =  GridWeb1.WebWorksheets.PivotTables("myPivotTable")
  'Adds 2 row data
 table.PivotCache.SourceCellArea.EndRow = 12

See Also