IXlsPivotTable

COM interface ( getting help with interfaces )

interface IXlsPivotTable : IDispatch
{
  [id(1),propget] HRESULT DataSource([out, retval] IXlsPivotTableDatasource** datasource);
  [id(2),propget] HRESULT Rows([out, retval] IXlsPivotTableFields** rows);
  [id(3),propget] HRESULT Columns([out, retval] IXlsPivotTableFields** columns);
  [id(4),propget] HRESULT Data([out, retval] IXlsPivotTableFields** data);
  [id(5),propget] HRESULT ReportFilters([out, retval] IXlsPivotTableFields** reportfilters);
  [id(6),propget] HRESULT Options([out, retval] IXlsPivotTableOptions** options);
  [id(7)]         HRESULT InsertAt([in]int row, [in]int column);
  [id(8),propget] HRESULT Name([out, retval] BSTR* name);
  [id(8),propput] HRESULT Name([in] BSTR name);

}

HRESULT DataSource([out, retval] IXlsPivotTableDatasource** datasource);
returns the data source of the pivot table.

HRESULT Rows([out, retval] IXlsPivotTableFields** rows);
returns the rows of the pivot table.

HRESULT Columns([out, retval] IXlsPivotTableFields** columns);
returns the columns of the pivot table.

HRESULT Data([out, retval] IXlsPivotTableFields** data);
returns the data of the pivot table.

HRESULT ReportFilters([out, retval] IXlsPivotTableFields** reportfilters);
returns the report filters of the pivot table.

HRESULT Options([out, retval] IXlsPivotTableOptions** options);
returns the options of the pivot table.

HRESULT InsertAt([in]int row, [in]int column);
inserts the pivot table at (row, col) in the current sheet.

HRESULT Name([out, retval] BSTR* name);
retrieves the name of the pivot table.

HRESULT Name([in] BSTR name);
sets the name of the pivot table.