How to exchange XML data between InfoPath and Excel

Asked By Bernard Fleck 0 points N/A Posted on - 01/26/2013

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.

• Status: Open
• Question Views: 847
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Baker Mich 5 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

Thanks

Baker

About Baker Mich

Questions
3

Answers
101

Best Answers
53

• Vote Up 0 Vote Down

• Posted on - 01/30/2013
• Question Category: MS Excel