Hi,
i got a business need to convert excel sheet into xml file, for ex: if excel sheet has 2 rows with 3 coloumns, say {(1,abc,xyz),(2,def,uvw)} should be converted into
1
abc
xyz
2
def
uvw
should any can help me out, how to start & proceed, is there any doc’s to help me out ??
Thanks in Advance!!!
Shankar,
First a question: Is your input file an excel sheet or a csv file?
If it is a csv file: write a ffschema for delimited file,using built in service converttovalues the o/p document generated can be used to generate the xml using documenttoXMLString service
If it is excel sheet: User 3rd party APIs like JExcel to parse your excel sheet (by writing a java service) and then use this document to generate XML string.(I believe there is a sample in wmUsers Shareware section describing how to use JExcel)
HTH
Pritam