IXlsSparklineElement

COM interface ( getting help with interfaces )

interface IXlsSparklineElement : IDispatch
{
  [id(1),propput] HRESULT LocationRow([in]int sparklineLocationRow);
  [id(1),propget] HRESULT LocationRow([out, retval]int* sparklineLocationRow);
  [id(2),propput] HRESULT LocationColumn([in]int sparklineLocationColumn);
  [id(2),propget] HRESULT LocationColumn([out, retval]int* sparklineLocationColumn);
  [id(3),propput] HRESULT DataAsFormula([in]BSTR dataRangeFormula);
  [id(3),propget] HRESULT DataAsFormula([out, retval]BSTR* dataRangeFormula);
  [id(4)]         HRESULT DataAsRange([in]int row1, [in]int col1, [in]int row2, [in]int col2);
}

HRESULT LocationRow([in]int sparklineLocationRow);
defines the row of the sparkline element. Starts at 1.

HRESULT LocationRow([out, retval]int* sparklineLocationRow);
returns the row of the sparkline element. Starts at 1.

HRESULT LocationColumn([in]int sparklineLocationColumn);
defines the column of the sparkline element. Starts at 1.

HRESULT LocationColumn([out, retval]int* sparklineLocationColumn);
returns the column of the sparkline element. Starts at 1.

HRESULT DataAsFormula([in]BSTR dataRangeFormula);
defines the data range by passing a formula.

HRESULT DataAsFormula([out, retval]BSTR* dataRangeFormula);
returns the data range by passing a formula.

HRESULT DataAsRange([in]int row1, [in]int col1, [in]int row2, [in]int col2);
defines the data range. Alternative to defining a range by a formula.