Examples of org.apache.poi.xssf.extractor.XSSFExportToXml

org.apache.poi.xssf.extractor.XSSFExportToXml
Maps an XLSX to an XML according to one of the mapping defined. The output XML Schema must respect this limitations:
- all mandatory elements and attributes must be mapped (enable validation to check this)
- no <any> in complex type/element declaration
- no <anyAttribute> attributes declaration
- no recursive structures: recursive structures can't be nested more than one level
- no abstract elements: abstract complex types can be declared but must not be used in elements.
- no mixed content: an element can't contain simple text and child element(s) together
- no <substitutionGroup> in complex type/element declaration


    public static void main(String[] args) throws Exception {
        XSSFWorkbook wb = new XSSFWorkbook(args[0]);


        for (XSSFMap map : wb.getCustomXMLMappings()) {
            XSSFExportToXml exporter = new XSSFExportToXml(map);


            ByteArrayOutputStream os = new ByteArrayOutputStream();
            exporter.exportToXML(os, true);
            String xml = os.toString("UTF-8");
            System.out.println(xml);
        }
    }

View Full Code Here

    public static void main(String[] args) throws Exception {
        OPCPackage pkg = OPCPackage.open(args[0]);
        XSSFWorkbook wb = new XSSFWorkbook(pkg);


        for (XSSFMap map : wb.getCustomXMLMappings()) {
            XSSFExportToXml exporter = new XSSFExportToXml(map);


            ByteArrayOutputStream os = new ByteArrayOutputStream();
            exporter.exportToXML(os, true);
            String xml = os.toString("UTF-8");
            System.out.println(xml);
        }
        pkg.close();
    }

View Full Code Here

TOP

Related Classes of org.apache.poi.xssf.extractor.XSSFExportToXml

org.apache.poi.xssf.model.Table

org.apache.poi.xssf.usermodel.examples.CustomXMLMapping

org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell

org.apache.poi.xssf.usermodel.helpers.XSSFXmlColumnPr

org.apache.poi.xssf.usermodel.XSSFCell

org.apache.poi.xssf.usermodel.XSSFRow

org.apache.poi.xssf.usermodel.XSSFSheet

org.apache.poi.xssf.usermodel.XSSFTable

java.text.DateFormat

java.text.SimpleDateFormat

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.