I am trying to create an Excel file from an Excel file template that includes XML mappings, load an XML and save the Excel file. When doing it manually in Excel by the Developer ribbon it works fine, but when I use the following code I cannot get all my mappings to work. The only mappings that works are the single cell mappings, my table is not getting updated.
This is my code:
File initialFile = new File(“MyTest2.xlsx”);
InputStream targetStream = new FileInputStream(initialFile);
Workbook workbook = new Workbook(targetStream);
workbook.importXml(“MyTest2.xml”, “Sheet1”, 0, 0);
I am using the Java version of Cells, version 18.3.
Any idea of what I am doing wrong? Attached are my sample files.ExcelGeneration.zip (8.6 KB)