I have an excel file, which i want to convert it to xml using JAVA. anyway to do it?
My concept:
The excel is uploaded and the values are inserted into database. I need to grab the header and the values, and generate out 1 xml file. eg
excel file format:
header1 header2 header3
rs1 rs2 rs3
rs4 rs5 rs6
i would like to store the value in Vector either this way [[header1,header2,header3],[rs1,rs2,rs3]] OR
[[header1,rs1,rs4][header2,rs2,rs5]]
my code is as follow
my desired xml format is
<header1>
<content>rs1</content>
<content>rs4</content>
</header1>
<header2>
<content>rs2</content>
<content>rs5</content>
</header2>
<header3>
<content>rs3</content>
<content>rs6</content>
</header3>
[ July 05, 2006: Message edited by: fang eve ]
[ July 05, 2006: Message edited by: fang eve ]