Thread: Java program to read a XMLs (from a folder) & extract specific values and store it in Excel sheet + Eclipse

Hi All,

I am very new to Java and I need some help here.

I am looking for a java code ( which can be run in eclipse). The code should do the below:
1) It should pick up XMLs one by one from a folder location ( which should be hard coded )
2) when it picks up the first XML, it should scan through and get a couple of values like business, order number etc ( User should have an option to specify the tag name as well)
Sample file
<Business>Student</Business>
<OrderNumber>0534</OrderNumber>
<Code>CZ01</Code>
<Phone>11</Phone>
<Sex>F</Sex>

If he wants to extract the Phone number ( he should be able to enter it "somewhere" & when the code is run it should pick up the tags entered by the user)

3) On picking the tags from the code ( or from where the user can enter) the code should extract the values from the XML & place it in the excel sheet

4) It should save the excel sheet in the folder from where it picks the XMLs.

Please help me out here...

Regards,
Blue J

Hi Kevin,

Yes I need a code which does all what i just said, is it possible for you to help me out.. I am very new to Java.

Please let me know if you need more explanation on the things Ive written.

Thanks in advance.

Regards,
Blue J

Hi,

I have not tried anything. I do not know Java.. and i need to work on this assignment. Please help me out.


Thanks,
Blue J

Yes I have, but I have to show this in 2 days... I ve tried learning things...but I am finding it very difficult..

Not a problem if you cant help me with the code...

I have used the code avail on google but i cant debug the errors, i do not know where to go.

But thanks for your responses.

Regards,
Blue J