Share via


ExcelService.Refresh Method

Retrieves updated data from external data sources for the open workbook.

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

Syntax

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

instance.Refresh(sessionId, connectionName, _
    status)
[WebMethodAttribute]
public void Refresh(
    string sessionId,
    string connectionName,
    out Status[] status
)

Parameters

  • sessionId
    Type: System.String
    The Excel Web Services session ID.
  • connectionName
    Type: System.String
    The name of the connection entry in the Excel workbook. To use all available connections, pass in Empty string or Null.
  • status
    Type: []
    Alert information.

Remarks

Refreshes a data connection in the workbook, or all connections if an empty connection string is provided.

The connection argument refers to a named connection in the Excel workbook. That connection (and the data in all objects using it) is refreshed.

The refresh operations will be attempted regardless of the type of authentication used, without any further confirmation or prompt.

See Also

Reference

ExcelService Class

ExcelService Members

Microsoft.Office.Excel.Server.WebServices Namespace