public void ConstructEmptyExcelPivotCacheRecords()
{
var file = new FileInfo("PivotTableDataSourceTypeWorksheet.xlsx");
Assert.IsTrue(file.Exists);
using (var package = new ExcelPackage(file))
{
var cacheDefinition = package.Workbook.PivotCacheDefinitions.First();
var ns = TestUtility.CreateDefaultNSM();
var partUri = new Uri("xl/pivotCache/pivotCacheRecords1.xml", UriKind.Relative);
var possiblePart = package.GetXmlFromUri(partUri);
int tableId = 2;
var records = new ExcelPivotCacheRecords(ns, package.Package, ref tableId, cacheDefinition);
Assert.IsNotNull(records);
Assert.AreEqual(0, records.Count);
}
}
private void AssertCacheRecord(ExcelPivotCacheRecords records, int row, int col, PivotCacheRecordType type, string value)
{
Assert.AreEqual(value, records[row].Items[col].Value);
Assert.AreEqual(type, records[row].Items[col].Type);
}
