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.