3.1.4.50 GenerateWorkbookFromHtml

  • Article

This operation is used to create a new workbook session for a workbook containing named objects based on the input parameters.

The following is the WSDL port type specification of the GenerateWorkbookFromHtml WSDL operation.

 <wsdl:operation name="GenerateWorkbookFromHtml" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:input wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GenerateWorkbookFromHtml" message="tns:ExcelServiceSoap_GenerateWorkbookFromHtml_InputMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
   <wsdl:output wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GenerateWorkbookFromHtmlResponse" message="tns:ExcelServiceSoap_GenerateWorkbookFromHtml_OutputMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
   <wsdl:fault wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/GenerateWorkbookFromHtmlExcelServerMessageFault" name="ExcelServerMessageFault" message="tns:ExcelServiceSoap_GenerateWorkbookFromHtml_ExcelServerMessageFault_FaultMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
 </wsdl:operation>

The protocol client sends an ExcelServiceSoap_GenerateWOrkbookFromHtml_InputMessage request message, and the protocol server responds with an ExcelServiceSoap_GenerateWorkbookFromHtml_OutputMessage response, message as follows:

  1. If the GenerateItems field of the options parameter in the GenerateWorkbookFromHtml input is not 0 and does not include WorkbookGenerationItems.Table, the protocol server MUST return a SOAP fault, as specified in section 2.2.2. The Id element of the ExcelServerMessage SHOULD<67> be one of the values specified in section 2.2.2.1

  2. Else, the protocol server will first obtain a new workbook session and insert a table into the workbook

  3. If the GenerateItems field of the options parameter in the GenerateWorkbookFromHtml input includes WorkbookGenerationItems.Slicers, then the protocol server MUST insert slicers for the table into the workbook.

  4. If the GenerateItems field of the options parameter in the GenerateWorkbookFromHtml input includes WorkbookGenerationItems.Chart, then the protocol server SHOULD insert a chart into the workbook.

  5. If the GenerateItems field of the options parameter in the GenerateWorkbookFromHtml input includes WorkbookGenerationItems.ConditionalFormatting, then the protocol server MUST provide additional formatting information for the previously inserted table in the workbook.