ExcelService.SetParameters Method

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.

• parameters
  Type: []

  An array ofParameterInfo class.

• 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