poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Fisher <dfis...@jmlafferty.com>
Subject Re: XSSFExportToXML help trying to export xlsx to xml
Date Fri, 16 Oct 2009 17:15:18 GMT
Roberto contributed this functionality to POI - Thanks!

Here is the bugzilla titled - [PATCH] Implementation of an XLSX to XML  
Exporter using Custom XML Mapping
https://issues.apache.org/bugzilla/show_bug.cgi?id=47520

When he says that it requires a Custom Mapping to work then that must  
be true.

You could try patching in a default mapping.

Good luck,
Dave

On Oct 16, 2009, at 9:59 AM, Dhaval Parekh wrote:

> Thanks for the reply.
>
> I just have to convert a xlsx to xml.
> I do not have any custom mappings defined.
>
> This is what I am doing at the moment and its throwing an exception
> java.io.IOException: error: Illegal XML character: 0x3
> org.apache.xmlbeans.impl.piccolo.io.IllegalCharException:
> Illegal XML character: 0x3 at
> (UTF8XMLDecoder.java:196)
>
> My code is below
>
> File inputfile = new File("test.xlsx");
> FileInputStream inp = new FileInputStream(inputfile);
> MapInfo info = new MapInfo();
>
>
> info.readFrom(inp);
> //this is where its throwing an error above
>
>
> XSSFMap xmap = info.getXSSFMapById(0);
> CTMap ctMap = null;
> XSSFExportToXml ex = new XSSFExportToXml(xmap);
> OutputStream writer = new FileOutputStream("outxml.txt");			
> ex.exportToXML(writer ,false);
>
> Thanks a lot for your help
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message