How to convert Xls file into Xml file

[Former Member]

Hi,

I am trying to convert Xls file into Xml but there is no any direct procedure for it

Pls help me out to convert Xls file into Xml file

Thanks

Anushree

[Former Member]

Hi anushree,

1. First you need to save that excel file as CSV format.

2. Then upload tht file , Providing tab or ' , 'as the seperator parameter,

Regards,

Sushil Hadge.

[Former Member]

You have to create adapter module processor and you have to add to your module processor bean to the adapter...Just check the following procedure...

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

[bhavesh_kantilal]

XI's files? What do you mean by it?

Regards

Bhavesh

[Former Member]

Hi

from xls i mean Excel file is there and i need to convert it into Xml

I am not getting any solution for it, i had searched lot in sdn but i couldnt get the exact solution .

Is there any scenario which can help me out from this problem?

pls let me know the exact solution .

Thanks

[Shabarish_Nair]

you will require to write a module in your file adapter for the same.

ref: /people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter as mentioned in the earlier post.

Else you can also use Conversion Agent to read the same.

Ref: http://help.sap.com/saphelp_nw04/helpdata/en/43/4c38c4cf105f85e10000000a1553f6/content.htm