public void ConstructExistingExcelPivotCacheDefinition()
{
var file = new FileInfo("PivotTableDataSourceTypeWorksheet.xlsx");
Assert.IsTrue(file.Exists);
using (var package = new ExcelPackage(file))
{
var uri = new Uri("xl/pivotCache/pivotCacheDefinition1.xml", UriKind.Relative);
var possiblePart = package.GetXmlFromUri(uri);
var cacheDefinition = new ExcelPivotCacheDefinition(TestUtility.CreateDefaultNSM(), package, possiblePart, uri);
Assert.IsNotNull(cacheDefinition);
Assert.AreEqual(4, cacheDefinition.CacheFields.Count);
Assert.AreEqual("C3:F6", cacheDefinition.GetSourceRangeAddress().Address);
}
}
