Оповещения для служб Excel

Статья
03/21/2023

Веб-службы Excel предоставляют оповещения об ошибках, возникающих в веб-службе и возвращаемых службами вычислений Excel.

Ошибки могут быть представлены следующими способами:

Excel calculation errors are returned similarly to how they are shown in Excelthat is, as cell error values, such as #VALUE!. When you call the GetCell or GetRange methods and request formatted values, you will get the # style error string. If you request unformatted values, you will get an enumerated error code. For more information, see the Error Codes section later in this topic.
When an error occurs during the processing of one of the Web service methods, preventing the method from finishing successfully, the error is exposed as a Simple Object Access Protocol (SOAP) exception. You can and should catch this error in your code. These types of errors are also known as "stop" alerts.
Errors that do not prevent the method from returning normal results are returned as part of the method arguments, specifically as an output argument. These types of errors are considered non-critical errors. The reason the errors are returned as an output argument instead of an exception is because throwing an exception would divert the code from its normal execution path, which is not desirable with noncritical errors. Checking for these errors is optional. These types of errors are also known as "continue" alerts.

Типы оповещений

Существует два типа оповещений: с остановкой и с продолжением.

Оповещения с остановкой

The "stop" alert causes the current operation to stop. This means the workbook will be rolled back to its state prior to execution of the current operation. The "stop" alerts are exposed as SOAP exceptions.

Оповещения с продолжением

The "continue" alert is typically a warning or non-critical error. When Службы вычислений Excel throws a "continue" alert, the operation continues. These alerts are returned as out argumentsa struct with the various alert fields. For more information, see the Status class reference topics in the Microsoft.Office.Excel.Server.WebServices namespace.

Перехватываемые исключения

You should catch errors specific to Службы вычислений Excel that you know the user might cause. For example, if your application prompts the user to type the path to a workbook, the user might type the wrong path or select a workbook that does not exist. You cannot control what the user types, but you can control the user experience when a user unintentionally misspells a workbook file name.

You should catch the SOAP exceptions (that is, "stop" alerts) in your code. For "continue" alerts, the calling code may choose to ignore or review the alert information.

Коды ошибок

To enable catching specific error conditions, an Службы вычислений Excel alert has an associated error code. The web service then returns the error using properties from the SoapException class.

Дополнительные сведения см. в статье "Класс SoapException" документации по пакету SDK Microsoft .NET Framework.

Обработка исключений

If your application (that is, your SOAP client) sends a request to a web service that the service is unable to process, the service returns a SOAP exception to the client. Handling exceptions thrown by Веб-службы Excel is an important part of the applications that you develop, because you can return specific information to users when errors occur. Exception handling can also help improve the user experience when something unexpected happens in your application.

Общие сведения об обработке исключений см. в статье "Обработка и вызов исключений" документации по пакету SDK Microsoft .NET Framework.