SourceData Property

SourceData

Declaration

IRange SourceData { get; set; }

Property SourceData As IRange

Examples

worksheet.Range["A1:C4"].Value = new object[,] {
    {"Product", "Category", "Amount"},
    {"Apple", "Fruit", 100},
    {"Pear", "Fruit", 200},
    {"Carrot", "Vegetable", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:C4"]);
IRange sourceData = pivotCache.SourceData;