IXlsVisualComponentParameter

COM interface ( getting help with interfaces )

interface IXlsVisualComponentParameter : IDispatch
{
  [id(1),propget] HRESULT Name([out, retval] BSTR* pbstrName);
  [id(2),propget] HRESULT Type([out, retval] enumDataType* parametertype);
  [id(3),propget] HRESULT NativeType([out, retval] BSTR* parameternativetype);
  [id(4),propget] HRESULT Formula([out, retval] BSTR* pvValue);
  [id(4),propput] HRESULT Formula([in] BSTR pvValue);
  [id(5),propput] HRESULT ValueAsNumber([in] int pvValue);
  [id(6),propput] HRESULT ValueAsFloat([in] double pvValue);
  [id(7),propput] HRESULT ValueAsLabel([in] BSTR pvValue);
}

HRESULT Name([out, retval] BSTR* pbstrName);
returns the name of the parameter.

HRESULT Type([out, retval] enumDataType* parametertype);
returns the data type of the parameter. Note that the data type does not include its cardinality, i.e. whether it's a single value, a vector (1D) or a matrix (2D).

HRESULT NativeType([out, retval] BSTR* parameternativetype);
returns the native data type of the parameter. The native type is the data type of the parameter known as per the underlying component COM IDL interface.

HRESULT Formula([out, retval] BSTR* pvValue);
returns the value for the parameter. Restricted to single value cardinalities.

HRESULT Formula([in] BSTR pvValue);
sets the value for the parameter. The value can be a single value, a cell reference, an area or a general formula.

HRESULT ValueAsNumber([in] int pvValue);
sets the value for the parameter as an integer.

HRESULT ValueAsFloat([in] double pvValue);
sets the value for the parameter as a floating-point value.

HRESULT ValueAsLabel([in] BSTR pvValue);
sets the value for the parameter as a string.