Interface IParameter
Represents the parameter used in a query table.
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
public interface IParameter : IParentApplication
Properties
DataType
Gets or sets the data type of the query parameter.
Declaration
ExcelParameterDataType DataType { get; set; }
Property Value
Name
Returns or sets the name of the object.
Declaration
string Name { get; set; }
Property Value
PromptString
Returns the phrase that prompts the user for a parameter value in a parameter query.
Declaration
string PromptString { get; }
Property Value
RefreshOnChange
True if the specified query table is refreshed whenever you change the parameter value of a parameter query.
Declaration
bool RefreshOnChange { get; set; }
Property Value
SourceRange
Returns a Range object that represents the cell that contains the value of the specified query parameter.
Declaration
IRange SourceRange { get; }
Property Value
Type
Gets or sets the parameter type.
Declaration
ExcelParameterType Type { get; }
Property Value
Value
Declaration
Property Value
Methods
add_Prompt(PromptEventHandler)
Declaration
void add_Prompt(PromptEventHandler value)
Parameters
remove_Prompt(PromptEventHandler)
Declaration
void remove_Prompt(PromptEventHandler value)
Parameters
SetParam(ExcelParameterType, Object)
Set parameter type and value.
Declaration
void SetParam(ExcelParameterType Type, object Value)
Parameters
Events
Prompt
Occurs while refresh the table whenever the parameter type is set as prompt.
Declaration
event PromptEventHandler Prompt
Event Type
Extension Methods