Share via

ExcelService.SetParameters Method

  • Article

Sets multiple published parameters with a single Web Service call.

Namespace:  Microsoft.Office.Excel.Server.WebServices
Assembly:  Microsoft.Office.Excel.Server.WebServices (in Microsoft.Office.Excel.Server.WebServices.dll)

Syntax

'Declaration
<WebMethodAttribute> _
Public Sub SetParameters ( _
    sessionId As String, _
    parameters As ParameterInfo(), _
    <OutAttribute> ByRef status As Status() _
)
'Usage
Dim instance As ExcelService
Dim sessionId As String
Dim parameters As ParameterInfo()
Dim status As Status()

instance.SetParameters(sessionId, parameters, _
    status)

[WebMethodAttribute]
public void SetParameters(
    string sessionId,
    ParameterInfo[] parameters,
    out Status[] status
)

Parameters

  • sessionId
    Type: System.String

    The Excel Web Services session ID.

  • status
    Type: []

    Alert information.

Remarks

The objects must be values, that is, numbers or text. This method does not support formulas.

Setting values into a cell replaces the previous values, but does not affect the formatting of the cell. Passing a a null reference (Nothing in Visual Basic) value clears the respective parameter.

See Also

Reference

ExcelService Class

ExcelService Members

Microsoft.Office.Excel.Server.WebServices Namespace