-
Book Overview & Buying
-
Table Of Contents
Processing XML documents with Oracle JDeveloper 11g
In the previous section an Excel document was generated from an XML document. In this section the Excel document is converted back to an XML document. The Apache POI HSSF API may also be used to parse an Excel spreadsheet and retrieve the cell values from the spreadsheet.
In the ExcelToXML.java application in the XMLExcel project in JDeveloper, import the Apache POI HSSF API.
import org.apache.poi.hssf.usermodel.*;
The root element of the XML document that we shall generate is catalog. We shall add a journal element to the root element corresponding to each of the rows of the Excel spreadsheet. First, generate an XML document and specify the root element of the document using the JAXP API, which was discussed in Chapter 1.
DocumentBuilderFactory factory =DocumentBuilderFactory.newInstance(); DocumentBuilder builder = factory.newDocumentBuilder(); Document document = builder.newDocument(); Element catalogElement=document...
Change the font size
Change margin width
Change background colour