Alertas dos serviços do Excel

Os Serviços Web do Excel expõem alertas para erros que ocorrem no serviço Web e erros retornados pelos Serviços de Cálculo do Excel.

Os erros são expostos das seguintes maneiras:

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.

Types of Alerts

Existem dois tipos de alertas: "parar" e "continuar".

alertas "parar"

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.

alertas "continuar"

The "continue" alert is typically a warning or non-critical error. When Serviços de Cálculo do 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.

Exceções a serem capturadas

You should catch errors specific to Serviços de Cálculo do 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.

Códigos de erro

To enable catching specific error conditions, an Serviços de Cálculo do Excel alert has an associated error code. The web service then returns the error using properties from the SoapException class.

Para saber mais, confira o tópico "Class SoapException" na documentação do SDK do Microsoft .NET Framework.

Tratamento de exceções

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 Serviços Web do 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.

Para obter informações gerais sobre o tratamento de exceções, confira "Como manipular e lançar exceções" na documentação do SDK do Microsoft .NET Framework.