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

Aspose.Cells App Product Family
1

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.

2

@DotnetUser23

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

3

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.

4

This topic has been moved to the related forum: XSD and data in excel file - Need to use Aspose to create XML - Free Support Forum - aspose.com

5