We're sorry AsposeApp doesn't work properply without JavaScript enabled.

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:element name=“ActorFirstName” type=“xs:string” minOccurs=“1” maxOccurs=“1”>
xs:appinfoDisplayName:First Name</xs:appinfo>
<xs:element name=“ActorMiddleName” type=“xs:string” minOccurs=“0” maxOccurs=“1”>
xs:appinfoDisplayName:Middle Name</xs:appinfo>
<xs:element name=“ActorLastName” type=“xs:string” minOccurs=“1” maxOccurs=“1”>
xs:appinfoDisplayName:Last Name</xs:appinfo>
<xs:element name=“AgentCompanyName” type=“xs:string” minOccurs=“0” maxOccurs=“1”>
xs:appinfoDisplayName:Company Name</xs:appinfo>

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?

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


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