views:

47

answers:

0

I have an Excel workbook which contains a PivotCache I would like to use as a data source.

var file = @"Foo.xls";
var excel = new Excel.Application();
var workbook = excel.Workbooks.Open(file);

Excel.PivotCache cache = null;
foreach (Excel.PivotCache pivotCache in workbook.PivotCaches())
{
    if (...)
    {
        cache = pivotCache;
    }
}
var records = cache.Recordset;

The last command throws an exception (Exception from HRESULT: 0x800A03EC).

How can I access the PivotCache? I tried it thru Ole DB first, but no success...