I have many Exel files so, just want to
automate the process of transforming exel
to XML document.

Any suggestions ??

1. I should make a sax like parser of my own and implement my own
default handler, throw events and make a DOM, transform into the XML file, I am done !! Right

-> If i had a comma separated file I know, I have to throw even on
every String I get after the comma(something along this line), but
what property of exel file should I use to do this ??

2. I should find some Java API which can do this for me !!
but was unable to fine one !!

--> If you guys know one please let me know !!

Regards,
Pardeep Singh

Well i recently did the exact same thing . The csv thing is the only way to go i guess.The following is the way to go .

1] convert the excel to csv file using MSEXCEL .

2] now using the "split" command in java get the entire csv data into a ArrayList .

3] keep a method which would recognize the headers , so that they could be used as element names .

4] keep a method that would use the header name along with the corresponding data to write XML data in a file .

Hope this is good enuff