Free Support Forum - aspose.app

XSD and data in excel file - Need to use Aspose to create XML

I have the following XSD

<xs:schema xmlns:xs=“http://www.w3.org/2001/XMLSchema”>
<xs:element name=“Document”>
xs:complexType
xs:sequence
<xs:element name=“ActorFirstName” type=“xs:string” minOccurs=“1” maxOccurs=“1”>
xs:annotation
xs:appinfoDisplayName:First Name</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name=“ActorMiddleName” type=“xs:string” minOccurs=“0” maxOccurs=“1”>
xs:annotation
xs:appinfoDisplayName:Middle Name</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name=“ActorLastName” type=“xs:string” minOccurs=“1” maxOccurs=“1”>
xs:annotation
xs:appinfoDisplayName:Last Name</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name=“AgentCompanyName” type=“xs:string” minOccurs=“0” maxOccurs=“1”>
xs:annotation
xs:appinfoDisplayName:Company Name</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

In Actor Data excel file .xslx, I have the following.

ActorFirstName ActorMiddleName ActorLastName AgentCompanyName
George Mighty Cool LAWide
Jason David Batman QAWilde
Brad O Cricketer LV Studios

Based on the XSD, I want to generate One xml record per row.

How can this be achieved using aspose.cells?

Note:
The generated xml will be passed as a parameter to a third-party webservice which in-turn saves the record to the database.

@DotnetUser23

Do you want to achieve this using back-end .NET Aspose.Cells API?

Yes wanted to use .net Aspose.cells API. Excel will contain rows of data, based on the XSD, my requirement is to generate xml file per row.

This topic has been moved to the related forum: https://forum.aspose.com/t/xsd-and-data-in-excel-file-need-to-use-aspose-to-create-xml/226411