You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2009/07/29 23:00:05 UTC
DO NOT REPLY [Bug 47604] New: [PATCH] Implementation of an XML to
XLSX Importer using Custom XML Mapping
https://issues.apache.org/bugzilla/show_bug.cgi?id=47604
Summary: [PATCH] Implementation of an XML to XLSX Importer
using Custom XML Mapping
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Mac OS X 10.4
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: dev@poi.apache.org
ReportedBy: roberto.manicardi@gmail.com
Created an attachment (id=24061)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24061)
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
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47604] [PATCH] Implementation of an XML to XLSX
Importer using Custom XML Mapping
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47604
Paolo Mottadelli <pa...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #2 from Paolo Mottadelli <pa...@gmail.com> 2009-07-30 06:25:29 PST ---
Patch applied. Thanks
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47604] [PATCH] Implementation of an XML to XLSX
Importer using Custom XML Mapping
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47604
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |RESOLVED
Resolution| |FIXED
--- Comment #5 from Yegor Kozlov <ye...@dinom.ru> 2009-08-05 11:00:31 PDT ---
Added in r801342
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47604] [PATCH] Implementation of an XML to XLSX
Importer using Custom XML Mapping
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47604
--- Comment #1 from Roberto Manicardi <ro...@gmail.com> 2009-07-29 14:02:23 PST ---
Created an attachment (id=24062)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24062)
New files
Added the following files
-XSSFImportFromXML.java: Importer
-TestXSSFImportFromXML.java: Junit test
-CustomXMLMapping-singleattributenamespace.xlsx : used for testing purpose
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47604] [PATCH] Implementation of an XML to XLSX
Importer using Custom XML Mapping
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47604
Roberto Manicardi <ro...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|FIXED |
--- Comment #4 from Roberto Manicardi <ro...@gmail.com> 2009-07-31 05:27:11 PST ---
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
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47604] [PATCH] Implementation of an XML to XLSX
Importer using Custom XML Mapping
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47604
--- Comment #3 from Roberto Manicardi <ro...@gmail.com> 2009-07-31 05:25:53 PST ---
Created an attachment (id=24071)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24071)
Added this issue in status.xml file
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org