Excel Sheet to XSD Conversion

[manikandan_shanmugam3]

Dear Champs,

I have to create a data type which has more than 50 fields, so trying to create a XSD from Excel sheet and upload same in PI.

I tried to search in google but confused that suggestion are like convert excel to xml then xsd and so on.

I have no idea how to provide the element and its occurrence in excel sheet and go on with like above steps.

Kindly give me suggestion how to generate a XSD from Excel sheet directly as i have multiple interface which are having more than 50 fields.

Thanks,

mani

[Former Member]

what i understand is you have got a requirement in the form of excel and that you would like to create a XSD with the details mentioned in the excel.

If so then, use stylus studio or altova or  any other tool that helps you create a XSD.

These tools will help you create the XSD graphically and then you press on a button called xsd and that would give you the XSD. upload this XSD to ESR as external definition.

[Former Member]

just use the excel function CONCATENATE

Default you need three columns, first column for the string before field name,

second column is the field name,

third is the string after field.

Hope it will help you.

[baskar_gopalakrishnan2]

Use jexcel api to convert excel to xml

[ambrish_mishra]

Hi Mani,

found one link relevant to you. http://scn.sap.com/thread/1227446

I have seen an ABAP report in one of the projects which had a specific excel template to be filled and it could generate an XSD but then again, it means converting your excel into report specific template.

if you have found tools which can convert excel to XML, try to do that and then you can easily convert XML to XSD (through Altova XML spy or Turbo xml).

Hope it helps!

Ambrish

[manikandan_shanmugam3]

Hi Ambrish,

I am confused about occurrence of elements. if i convert excel in to XML later XSD then how occurrence are handled.

[ambrish_mishra]

Hi Mani,

When you create an XML to XSD, we have options to set the occurrence and data type.

Try with Altova or Turbo XML.

Ambrish