Expand my Community achievements bar.

SOLVED

Import data to Excell

Avatar

Level 7

Is it posible to import data into excell spreadsheet?

Thanks

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

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

View solution in original post

5 Replies

Avatar

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

Avatar

Level 7

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

Avatar

Correct answer by
Former Community Member

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

Avatar

Level 7

Thanks Steve I am almost there...

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

Thanks

Avatar

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

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----