AnsweredAssumed Answered

Is there a way to generate complex excel workbooks from complex XSDs and then generate those workbooks into an XML file to be read by our webservices tests?

Question asked by Lisa_Holdener on Dec 1, 2015
Latest reply on Dec 1, 2015 by AnkushSharma62132828

Here is an example (snippet) of an XSD that we need to convert to an excel workbook so our functional testers can enter test data.  Then we need this spreadsheet converted to an XML file to be used in our webservice tests.

 

<complexType name="AvailabilityOutputType">

     <sequence>

          <element name="IndexOfReqItem" type="long" minOccurs="0"/>

          <element name="AvailabilityDetail" type="tns:AvailabilityDetailOutputType" minOccurs="0" maxOccurs="100"/>

      </sequence>

</complexType>

<complexType name = "AvailabilityDetailOutputType">

     <sequence>

          <element name="ItemCategoryCode" type="string" minOccurs="0"/>

          <element name="ItemCharge" type="double" minOccurs="0"/>

     </sequence>

</complexType/>

 

Is this possible in DevTest itself?  Thanks in advance for any guidance!

Outcomes