Excel integration for importing of data

[l_robert32]

Hi all,

I'm currently looking at a way of testing the funcionality of forms by importing a range of input data.

The data is being collated in an Excel spreadsheet.  Does anyone know a way of integrating forms with the spreadsheet to populate the specified fields?

Thanks,

Rob.

[Former Community Member]

I was able to open a blank XML file (export xml data from the PDF) in Excel using "Use the XML Source task pane".

From there you can map all the XML fields to a cell in the Excel file. Save as XML and it comes out looking pretty.

Hope this helps.

[l_robert32]

Thanks for this.

I was more looking for using Excel as source to populate the fields within the form, rather than the other way round.

Any ideas?

Thanks,

Rob.