 |
| 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);
[id(12) ] HRESULT TurnToVisualComponent([in]BSTR progId, [out, retval]IXlsTableVisualComponent** vc);
[id(13),propget] HRESULT IsInferred([out, retval] BOOL* bIsInferred);
[id(14),propget] HRESULT Style([out, retval]IXlsTableStyle** style);
[id(15),propget] HRESULT AutoFilter([out, retval]IXlsAutoFilter** autofilter);
}
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.
HRESULT TurnToVisualComponent([in]BSTR progId, [out, retval]IXlsTableVisualComponent** vc);
turn the table to a visual component whose global identifier is passed as parameter.
HRESULT IsInferred([out, retval] BOOL* bIsInferred);
returns whether or not the table is inferred.
HRESULT Style([out, retval]IXlsTableStyle** style);
returns styles.
HRESULT AutoFilter([out, retval]IXlsAutoFilter** autofilter);
returns an auto-filter object.