reading excel file in jave and produce xml as output
<p>I have developed the runnable jar which will convert the sample excel file to xml file. it is working fine but i have problem where i need to loop based on particular column i.e see my excel for information </p>

<pre><code>col  1     2               3              4 5           6             7
     10001 LD31PC15R013WD  DHULE_DEALER_2 1 C1C2003209  CHAKAN_PLANT  13-Apr-12
     10001 LD31PB15R0761WD DHULE_DEALER_2 1 C1C2003209  CHAKAN_PLANT  13-Apr-12
</code></pre>

<p>here every row converts to xml file but now if the column 5 has repetative data then it should go in one xml element by looping through it itself rather than creating new xml.</p>

<p>I have used apache poi for this utility.. Please help me if u need i will paste the code.</p>
