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)

[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.

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.

Show: