Page 1 of 1

Extract XML-mapped Data from Spreadsheet

PostPosted: Wed Oct 12, 2011 3:36 am
by tokoran
I have added an XML-Map to an Excel-Spreadsheet (via the menu Developer->XML->Source) and mapped the elements to cells in my spreadsheet. The export function in Excel (Developer->XML->Export) gives me an XML file filled with the data from the cells the XML elements are mapped to.

Now I would like to do the same in my Java application with docx4j. Ist that possible?

I can see the xpath/cell mapping in the xlsx file in /xl/tables/tableSingleCells1.xml but how do I extract the data?

Thanks in advance.

Re: Extract XML-mapped Data from Spreadsheet

PostPosted: Wed Oct 12, 2011 9:01 am
by jason
I'm sure it is possible, but there is no specific support for it at present. In other words, you'll need to write some code.