Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Experience Manager Champion Program are open!

xml nodes appearing in spreadsheet

Avatar

Level 2

Hi all,

I have another question so thought I'd better start a new thread.

If I have a number of .xml files containing the form data from a Livecycle designer form, I've found that I can merge them all into an excel spreadsheet. When I open up the spreadsheet, I noticed that the data in the first row looks like the following:

form1[0].Table2[1].Row2[0].firstname[0]

I named this field "firstname" in the bindings panel and I thought that this would be the content that would appear in that cell within Excel, but it's adding in all those xml nodes which confuses things a lot.

Is there a way to avoid this?

Appreciate any further assistance.

0 Replies