Import data to Excell

[mmgiath]

Is it posible to import data into excell spreadsheet?

Thanks

[Former Community Member]

Microsoft Office Excel has a variety of techniques that can be used to import data.

Regarding LiveCycle Designer ES, what is the context of this question?

Steve

[mmgiath]

Hi Steve,

We have create with LiveCycle Designer ES, a dynamic form and we are wondering if we can export the data into Excell.

Thanks

[Former Community Member · Accepted solution]

You can export the data from an XFA-based form as .xml using

xfa.host.exportData("",0);

The .xml could then be imported into Excel. It has been about 15 years since I touched Excel automation and macros but I am sure the Excel tooling has support for getting .xml into a spreadsheet pretty easily.

Steve

[mmgiath]

Thanks Steve I am almost there...

Last question: Is it possible to export as .xml specific only fields than all form's fields?

Thanks

[Former Community Member]

If you set the binding in the fields that you do not want to None then that field will not be included in the XML.

Paul