IXlsTableResults

COM interface ( getting help with interfaces )

interface IXlsTableResults : IDispatch
{

  [id(1),propget] HRESULT Columns([out, retval]IXlsTableColumns** columns);
  [id(2)]         HRESULT Insert();
  [id(3),propget] HRESULT RowCount([out, retval]int* rowcount);
  [id(4),propget] HRESULT Name([out, retval] BSTR* name);
  [id(4),propput] HRESULT Name([in] BSTR name);
  [id(5)        ] HRESULT InsertAt([in]int row, [in]int col);
  [id(6)        ] HRESULT Transpose();
  [id(7)        ] HRESULT RemoveDuplicates([in]IXlsList* list);
  [id(8)        ] HRESULT ApplyTemplate([in]IXlsWorksheet* sheet);
  [id(9)        ] HRESULT TurnToChart([in]enumChartType type);
  [id(10)       ] HRESULT TurnToTable();
  [id(11),propget] HRESULT Prompts([out, retval]IXlsTablePrompts** prompts);

}

HRESULT Columns([out, retval]IXlsTableColumns** columns);
returns columns.

HRESULT Insert();
inserts the table results in the worksheet.

HRESULT RowCount([out, retval]int* rowcount);
returns how many rows in the recordset.

HRESULT Name([out, retval] BSTR* name);
retrieves the name of the range associated to the table results.

HRESULT Name([in] BSTR name);
sets the name of the range associated to the table results.

HRESULT InsertAt([in]int row, [in]int col);
inserts the table results in the worksheet at location (row,col).

HRESULT Transpose();
switches rows and columns.

HRESULT RemoveDuplicates([in]IXlsList* list);
removes duplicates. An optional list can be passed to ease the value matching.

HRESULT ApplyTemplate([in]IXlsWorksheet* sheet);
applies the template styles inferred from the passed worksheet.

HRESULT TurnToChart([in]enumChartType type);
turn the table to a chart.

HRESULT TurnToTable();
turn the chart back to a table.

HRESULT Prompts([out, retval]IXlsTablePrompts** prompts);
returns the collection of result prompts.