IXlsPivotTableFields

COM interface ( getting help with interfaces )

interface IXlsPivotTableFields : IDispatch
{
  [id(1),propget] HRESULT Count([out, retval]int* count);
  [id(2),propget] HRESULT Item([in]int i, [out, retval]IXlsPivotTableField** pivotField);
  [id(3)]         HRESULT AddByIndex([in]int i, [out, retval]IXlsPivotTableField** pivotField);
  [id(4)]         HRESULT AddByName([in]BSTR name, [out, retval]IXlsPivotTableField** pivotField);
  [id(5)]         HRESULT AddDataFields();

}

HRESULT Count([out, retval]int* count);
tells how many pivot fields there are in the pivot table.

HRESULT Item([in]int i, [out, retval]IXlsPivotTableField** pivotField);
retrieves the i-th pivot field. The index is 1-based.

HRESULT AddByIndex([in]int i, [out, retval]IXlsPivotTableField** pivotField);
adds a pivot field (i-th column of the data source). The index is 1-based.

HRESULT AddByName([in]BSTR name, [out, retval]IXlsPivotTableField** pivotField);
adds a pivot field (column name of the data source).

HRESULT AddDataFields();
adds data fields. Applies to columns or rows.