Created attachment 24061 [details] The diff file I've implemented a tool to import XML files into XLSX using the Custom XML Mapping defined in the XLSX. This closes the loop I've started with the XML exporter (https://issues.apache.org/bugzilla/show_bug.cgi?id=47520). I've added some use cases in the test file - src/ooxml/testcases/org/apache/poi/xssf/extractor/TestXSSFImportFromXML.java To give a quick snippet of code on how to use the importer // gets one of the Custom XML mapping configured in the workbook XSSFMap map = workbook.getMapInfo().getXSSFMapByName("mapping name"); // creates a new importer for the mapping XSSFImportFromXML importer = new XSSFImportFromXML(map); // imports the XML importer.importFromXML(testXML); I did also some little modifications to enable an easier access to the map info data: - XSSFMapInfo : added the new method getXSSFMapByName(String mapName) - XSSFWorkbook: added a new method to retreive the XSSFMapInfo object - XSSFSingleXmlCell: if the related XSSFCell doesn't exists, create a new one when tring to retreive it - XSSFXmlColumnPr : added new getId() and getXPath() methods
Created attachment 24062 [details] New files Added the following files -XSSFImportFromXML.java: Importer -TestXSSFImportFromXML.java: Junit test -CustomXMLMapping-singleattributenamespace.xlsx : used for testing purpose
Patch applied. Thanks
Created attachment 24071 [details] Added this issue in status.xml file
I've forgot to set this issue in the status.xml file. I've attached a new patch, could you plese add it to the trunk? Thanks, Roberto
Added in r801342 Yegor