How to exchange XML data between InfoPath and Excel

Asked By 0 points N/A Posted on -

Hi Experts,

I have heard about exchanging XML data between Infopath and Excel. Is there any way how to exchange data between infopath and excel xml. Please write detailed steps.

Answered By 0 points N/A #153645

How to exchange XML data between InfoPath and Excel


Hi Bernard,

You can exchange XML data in your InfoPath project as follows.

1.    In design mode, click Convert Main Data Source on the Tools menu.

2.    On the first page of the Data Source Wizard, click Browse.

3.    In the Open dialog box, browse to the updated XML document or XML Schema, and then click Open.

                Following are the steps that you can follow to use xml data in your Excel spreadsheet.

1.       On the File menu in Excel, click Open.

2.       In the Open dialog box, click the XML file that you want to open, and then click Open.

3.       In the Open XML dialog box, click As an XML list, and then click OK.

4.       If the XML Source task pane does not appear on the right side of the screen, click Task Pane on the Viewmenu.

Each column in the XML list corresponds to an XML element in the task pane. In this example, the XML elementns1:AuthBy is mapped to column A (ns1:AuthBy), and Annette Hill is displayed in the row data.

XML file opened as an XML list



Login/Register to Answer

Related Questions