converting xml into xls using java

Question

I wrote an xml file using the below codes, how to convert that file into xls or csv file? I want to read an xml file and covert it into an xls file using java codes, is there a possible way to do that?

        // write the content into xml file
TransformerFactory transformerFactory = TransformerFactory.newInstance();
    try {
        Transformer transformer = transformerFactory.newTransformer();
        DOMSource source = new DOMSource(doc);
        StreamResult result = new StreamResult(new File("C:\\file.xml"));
        try {
            // Output to console for testing
            // StreamResult result = new StreamResult(System.out);
            transformer.transform(source, result);

        } catch (TransformerException ex) {
            Logger.getLogger(CreditBureau.class.getName()).log(Level.SEVERE, null, ex);
        }
             System.out.println("File saved!");

    } catch (TransformerConfigurationException ex) {
        Logger.getLogger(CreditBureau.class.getName()).log(Level.SEVERE, null, ex);
    }

} catch (ParserConfigurationException ex) {
    Logger.getLogger(CreditBureau.class.getName()).log(Level.SEVERE, null, ex);
}

} }

Yes, there is a possible way, but you need to try yourself first then come back here with some code... Basically it can get quite tricky though as xls or csv aren't really suited to represent a tree... — Laurent S.
– Laurent S., Commented Dec 17, 2013 at 13:40
If you want to do it by yourself, take a look at this answer: stackoverflow.com/a/3367912/2829009 — Manuel Allenspach
– Manuel Allenspach, Commented Dec 17, 2013 at 13:43

lance-java · Accepted Answer · 2013-12-17 14:02:58Z

2

Take a look at POI and JXLS

POI is a library for writing office documents in Java and JXLS can generate excel documents in Java based on a template (the template is also an excel document). Note that JXLS is implemented on top of POI.

edited Dec 17, 2013 at 14:02

answered Dec 17, 2013 at 13:38

lance-java

29.4k6 gold badges73 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

converting xml into xls using java

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related