Convert exel file to XML

[karephul]

Hi,
Sorry for not being very active member ..

How can we convert exel file to xml document ??
1. Use event model and use default handler (implement it) in
java ..

the problem is, what property should I use of exel by which
I can retrieve the information ..

--> if you have any differnt idea please let me know ..

John

 

[slurpee55]

Hi,

A lot depends on which version of Excel you have, however, even 2003 claims to save as xml but doesn't do it well.
I found it much easier recently to save the file in .csv format, then get a transformer program to convert it.
Obviously, you could build it in WordPad, line by line, but that is incredibly tedious, and, given a large Excel file, not worth the amount of time you would have to invest.

 

[Diancecht]

Some discussion on the issue:

http://www.xml.com/pub/a/2002/01/09/q-and-a.html

Cheers,
Dian

 

[karephul]

Thanks for the reply,

I will just check the link, but my first glance says
it is usefull.

Regards